API tools faq
paste
Guest User

Untitled

a guest
Nov 2nd, 2016
102
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.79 KB | None | 0 0
raw download clone embed print report
  1. CREATE DATABASE shopping
  2. CREATE TABLE `clients` (   `id` mediumint(8) unsigned NOT NULL auto_increment,   `name` varchar(255) default NULL,   `phone` varchar(100) default NULL,   `email` varchar(255) default NULL,   `city` varchar(255),   `state` varchar(50) default NULL,   `pincode` varchar(10) default NULL,   PRIMARY KEY (`id`) ) AUTO_INCREMENT=1;
  3. CREATE TABLE `products`( `id` mediumint(8) unsigned NOT NULL auto_increment, `productName` varchar(200) default NULL, `price` decimal(9,1) unsigned default NULL, PRIMARY KEY (`id`));
  4. CREATE TABLE `orders` ( `orderId` mediumint(8) unsigned NOT NULL auto_increment, `custId` mediumint(8) unsigned NOT NULL, `prodId` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`orderId`), FOREIGN KEY (`custId`) REFERENCES clients(`id`) );
  5.  
  6. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Manisila Ismail","+91 6726269262","dictum.eu@id.ca","Mangalore","Karnataka","129073"),("Abhi Raj","+91 0437426650","venenatis.a.magna@egetnisidictum.com","Orai","Uttar Pradesh","642052"),("Anju Jain","+91 9379993216","aliquam@Donecfeugiatmetus.co.uk","Barrackpur","West Bengal","262926"),("Punthali Patel","+91 1995668376","feugiat.tellus.lorem@esttemporbibendum.edu","Agartala","Tripura","854566"),("Adityavardhana Raj","+91 2949560293","nunc.nulla@ametluctus.co.uk","Mandya","Karnataka","402160"),("Trivikram Jain","+91 4774138961","vitae.erat@quisdiamPellentesque.net","Shimla","Himachal Pradesh","898078"),("Abhijvala Khan","+91 6377255209","ridiculus.mus.Donec@liberolacus.com","Ongole","Andhra Pradesh","643743"),("Deepamala Khan","+91 2505109221","vestibulum.nec@tinciduntpedeac.co.uk","Dera Ghazi Khan","Punjab","202748"),("Prabodh Jain","+91 9206164306","euismod.in@arcuac.edu","Ichalkaranji","Maharastra","824154"),("Ivy Raj","+91 1746808531","pede@ProindolorNulla.co.uk","Mathura","Uttar Pradesh","658786");
  7. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Mehboob Kumar","+91 2391427009","id@sociis.net","Banda","Uttar Pradesh","244722"),("Foolan Singh","+91 6358218246","Nulla@Integer.co.uk","Vellore","Tamil Nadu","480246"),("Shantashil Raj","+91 4808966091","Nullam.nisl@Integer.edu","Jabalpur","Madhya Pradesh","491272"),("Milika Jain","+91 4658411083","Aliquam.ultrices.iaculis@seddui.org","Surendranagar","Gujarat","204407"),("Premendra Singh","+91 7403133749","egestas.Fusce@Maecenas.com","Guntakal","Andhra Pradesh","728751"),("Kovida Singh","+91 0541439671","nec.urna.et@loremipsum.edu","Tirunelveli","Tamil Nadu","974753"),("Soma Kumar","+91 3659466791","magna.malesuada.vel@maurisut.ca","Jammu","Jammu and Kashmir","941917"),("Gursharan Khan","+91 9024113258","metus.facilisis.lorem@DonecegestasAliquam.ca","Bhuj","Gujarat","719434"),("Bankim Patel","+91 8094210264","eu@estmollis.co.uk","Khanewal","Punjab","177010"),("Marala Jain","+91 0378538860","ipsum@sagittisaugueeu.edu","Palakkad","Kerala","429909");
  8. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Rabia Ismail","+91 1657940571","eu@leo.org","Panipat","Haryana","688160"),("Daksha Raj","+91 3641589125","eget@urnaUttincidunt.com","Berhampore","West Bengal","804737"),("Mandakranta Patel","+91 9852272862","massa.Vestibulum.accumsan@augue.org","Sasaram","Bihar","623102"),("Anuprabha Kumar","+91 6237900334","Pellentesque@adipiscingenim.edu","Nizamabad","Andhra Pradesh","593445"),("Vir Patel","+91 2579927466","nibh.Aliquam.ornare@ligula.ca","Kalyan","Maharastra","174189"),("Tarala Kumar","+91 2605442982","molestie.Sed.id@ipsumSuspendissenon.com","Ambala Sadar","Haryana","241425"),("Lakshman Ismail","+91 3984265569","commodo@sed.com","Meerut Cantonment","Uttar Pradesh","859861"),("Faiz Jain","+91 0123429103","pharetra.ut.pharetra@odioPhasellusat.ca","Gadag Betigeri","Karnataka","410269"),("Tapasranjan Raj","+91 1086946600","lorem.fringilla.ornare@ipsumprimisin.edu","Dibrugarh","Assam","176175"),("Praful Raj","+91 9366449342","ac.arcu.Nunc@atrisus.com","Jamshedpur","Jharkhand","188654");
  9. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Sajni Raj","+91 4013952029","Aenean@mollislectuspede.ca","Haridwar","Uttarakhand","619964"),("Chithayu Ismail","+91 1022697096","eget.massa@sitamet.co.uk","Haridwar","Uttarakhand","169322"),("Kunjalata Kumar","+91 9278004211","orci.Ut.semper@malesuadamalesuadaInteger.ca","Jammu","Jammu and Kashmir","585487"),("Jagadip Patel","+91 7946515503","odio.a@risus.co.uk","Shimla","Himachal Pradesh","958300"),("Rajani Jain","+91 5344737535","vel.vulputate.eu@Nuncpulvinar.com","Jaipur","Rajasthan","744903"),("Sanjushree Patel","+91 1525259102","in@hendreritDonecporttitor.net","Rohtak","Haryana","774298"),("Ekanga Jain","+91 6936089875","eu.odio.Phasellus@NullamnislMaecenas.co.uk","Varanasi","Uttar Pradesh","394734"),("Parindra Raj","+91 4847225814","Etiam.laoreet@ac.org","Srinagar","Jammu and Kashmir","867882"),("Girika Singh","+91 1518847324","rutrum.lorem@dolorvitae.ca","Dehri","Bihar","362390"),("Paridhi Khan","+91 9496633285","magna@rutrum.net","Trivandrum","Kerala","235737");
  10. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Labangalata Jain","+91 0179755524","lacinia.orci.consectetuer@iaculislacus.co.uk","Kharagpur","West Bengal","818516"),("Nikhila Patel","+91 5249395657","risus.Donec.nibh@nonmassanon.edu","Dabgram","West Bengal","857091"),("Egaiarasu Raj","+91 7257542959","dictum.augue.malesuada@ametloremsemper.net","Chhindwara","Madhya Pradesh","952234"),("Vajra Singh","+91 9512500148","id.nunc@tinciduntpede.org","Patan","Gujarat","710909"),("Kavan Jain","+91 6621933921","Integer.in.magna@metusIn.net","Mirzapur-cum-Vindhyachal","Uttar Pradesh","511773"),("Hansanandini Ismail","+91 2625553960","Aliquam@tinciduntnibhPhasellus.net","Ganganagar","Rajasthan","283747"),("Sheetal Singh","+91 9946963375","nec.urna@vitaediam.ca","Darbhanga","Bihar","310985"),("Rasna Patel","+91 2249690880","sed.facilisis@Maecenas.edu","Ratlam","Madhya Pradesh","308967"),("Nileen Kumar","+91 8906951028","eleifend.Cras@pede.org","Pali","Rajasthan","918117"),("Ulhas Ismail","+91 7856615943","metus.Aliquam.erat@amet.ca","Tiruppur","Tamil Nadu","454635");
  11. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Kush Khan","+91 8594428218","sed.tortor.Integer@pharetranibh.net","Kollam","Kerala","670661"),("Nairit Jain","+91 5444534893","sodales.purus.in@CraspellentesqueSed.com","Nagpur","Maharastra","516616"),("Teja Ismail","+91 6041493029","nibh.Aliquam.ornare@non.com","Tirunelveli","Tamil Nadu","719114"),("Satyamurty Raj","+91 4348764573","Duis@enimnonnisi.co.uk","Sonipat","Haryana","566443"),("Pradeepta Jain","+91 8512244663","augue.eu.tellus@elitEtiam.co.uk","Belgaum","Karnataka","828139"),("Nitin Khan","+91 9292734729","ullamcorper.velit@Integersemelit.org","Kanchipuram","Tamil Nadu","110598"),("Latafat Jain","+91 5319148673","vitae.aliquet@Donecfelis.co.uk","Nadiad","Gujarat","101486"),("Harshavardhan Raj","+91 4042991523","porta.elit@nonummyultricies.ca","Bhind","Madhya Pradesh","346217"),("Devamati Ismail","+91 1734004105","sollicitudin@mollisnon.net","Trivandrum","Kerala","946781"),("Vajrapani Singh","+91 7386213844","rhoncus@etnetuset.ca","Yeotmal","Maharastra","669403");
  12. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Jayanti Jain","+91 1062530597","semper.auctor@afacilisis.co.uk","Balurghat","West Bengal","250627"),("Shashibala Raj","+91 3280194914","habitant.morbi@elitpellentesque.com","Jhelum","Punjab","928089"),("Kapotakshi Singh","+91 6665598594","enim@velit.net","Bhilwara","Rajasthan","971140"),("Kanan Khan","+91 2724386909","sit@mauris.co.uk","Salem","Tamil Nadu","287199"),("Japesh Raj","+91 9771071422","luctus@iaculis.org","Tenali","Andhra Pradesh","365484"),("Shaswati Singh","+91 4615758562","eu@Curabiturvellectus.ca","Vejalpur","Gujarat","914892"),("Suvarnmala Ismail","+91 5437208937","cursus.Nunc.mauris@tincidunt.net","Delhi","Delhi","607355"),("Bharadwaj Jain","+91 7022710810","tempus.lorem@sagittis.net","Rampur","Uttar Pradesh","674963"),("Hemadri Raj","+91 5556575307","est.congue@seddictum.com","Bikaner","Rajasthan","878837"),("Nirmala Ismail","+91 3825180620","scelerisque@metussitamet.net","Gandhidham","Gujarat","831089");
  13. INSERT INTO products VALUES (Cello pen,5.0)
  14. INSERT INTO products VALUES ('Cello pen','5.0')
  15. INSERT INTO products (productName,price) VALUES ('Cello pen','5.0')
  16. INSERT INTO products (productName,price) VALUES ('A4 sheet','0.5')
  17. INSERT INTO products (productName,price) VALUES ('Graph sheet','1');
  18. INSERT INTO products (productName,price) VALUES ('Micromax A50','4999');
  19. INSERT INTO products (productName,price) VALUES ('Logitech Wireless mouse','699');
  20. INSERT INTO products (productName,price) VALUES ('Woodland Mens Wallet','999');
  21. INSERT INTO products (productName,price) VALUES ('Book:The Alchemist','399');
  22. INSERT INTO products (productName,price) VALUES ('Book:The Alchemist','399');
  23. INSERT INTO products (productName,price) VALUES ('Micromax A50','4999');
  24. INSERT INTO products (productName,price) VALUES ('Woodland Mens Wallet','999');
  25. INSERT INTO products (productName,price) VALUES ('Logitech Wireless mouse','699');
  26. INSERT INTO products (productName,price) VALUES ('Classmate 200 page notebook','40');
  27. INSERT INTO products (productName,price) VALUES ('Mens T shirt','179');
  28. INSERT INTO products (productName,price) VALUES ('Red salwar','499');
  29. INSERT INTO products (productName,price) VALUES ('Dell Inspiron 15','32999');
  30. INSERT INTO products (productName,price) VALUES ('Philips earphones','251');
  31. INSERT INTO products (productName,price) VALUES ('Philips toaster','899');
  32. INSERT INTO orders (`custId`,`prodId`) VALUES (`2`,`2`);
  33. INSERT INTO orders (`custId`,`prodId`) VALUES ('2','2');
  34. INSERT INTO orders (`custId`,`prodId`) VALUES ('2','10');
  35. INSERT INTO orders (`custId`,`prodId`) VALUES ('2','5');
  36. INSERT INTO orders (`custId`,`prodId`) VALUES ('4','1');
  37. INSERT INTO orders (`custId`,`prodId`) VALUES ('9','3');
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!