Skip to content

Instantly share code, notes, and snippets.

@operateur-mar

operateur-mar/AddData.sql

Created September 28, 2018 10:07
Show Gist options
  • Save operateur-mar/a01757dbb4707055e92e2720700b7a38 to your computer and use it in GitHub Desktop.
Save operateur-mar/a01757dbb4707055e92e2720700b7a38 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AddData.sql
/* Add Single & Full Data to table */
INSERT INTO customer VALUES(1,'Rida','Dahhane' ,'0678963214','MyStreet',251,2500)
/* Add Multiple & Full Data to table */
INSERT INTO customer VALUES
(2,'Tarek','Jamal' ,'0689874138','A Random Street',211,89000),
(3,'Ahmed','Mahmoud','0589631247','HisStreet',258,28932),
(4,'Aqua','Web','0514785236','www.aqweeb.com / Street adress',280,20000)
/* Add Single Customized Data */
INSERT INTO customer(custID,LN,FN) VALUES(6,'Ahmed','Rihab')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment