Search
 
SCRIPT & CODE EXAMPLE
 

SQL

input in mysql

-- Example for MysQL:
SET @my_Id:=30;
SELECT * FROM my_table WHERE id=@my_Id;

-- Example in Oracle:
SELECT * FROM my_table WHERE id = :my_id;
Comment

PREVIOUS NEXT
Code Example
Sql :: SQL Server Get the current identity value of the table 
Sql :: add column with foreign key constraint sql server 
Sql :: sql where max date 
Sql :: how to get id of last inserted row in mysql 
Sql :: date diff sql 
Sql :: what is integrity constraints 
Sql :: tsql insert 
Sql :: oracle difference between two dates in seconds 
Sql :: select and condition in sql 
Sql :: sql update null values 
Sql :: get duplicate records in sql 
Sql :: remove duplicates sql server select 
Sql :: mysqli last row 
Sql :: mysql error 1251 
Sql :: SQL Auto Increment Primary Key - SQL Server 
Sql :: sql decimal vs float 
Sql :: postgres float to int 
Sql :: sqlalchemy join on column 
Sql :: How do I add a user to a postgres database? cli 
Sql :: rename column sql 
Sql :: cursor.execute in python sqlite3 
Sql :: get record which is available in one table but not in another mysql 
Sql :: mysql remove html tag 
Sql :: how to make a select in sql 
Sql :: oracle log files 
Sql :: mysql select into new table 
Sql :: update with select postgresql 
Sql :: restroe pg_dump example 
Sql :: sql datetime format dd/mm/yyyy hh:mm am/pm 
Sql :: postgres select duplicate columns 
ADD CONTENT
Topic
Content
Source link
Name
3+7 =