Difference between revisions of "INSERT .. VALUES"

From SQLZOO
Jump to: navigation, search
 
Line 10: Line 10:
  
 
INSERT INTO USERS (Fname,Mname,Lname) VALUES ('Saad','A','Mian');
 
INSERT INTO USERS (Fname,Mname,Lname) VALUES ('Saad','A','Mian');
 +
 +
 +
http://www.kanzulashya.com/oracle-sql/

Latest revision as of 12:30, 7 April 2014

CREATE TABLE USERS (

 UserId INT NOT NULL AUTO_INCREMENT,
 Fname VARCHAR (255),
 Mname VARCHAR (255),
 LName VARCHAR (255),
 PRIMARY KEY (UserId)
 )

INSERT INTO USERS (Fname,Mname,Lname) VALUES ('Saad','A','Mian');


http://www.kanzulashya.com/oracle-sql/

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense