API tools faq
paste
Guest User

Untitled

a guest
Nov 2nd, 2016
108
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","[email protected]","Mangalore","Karnataka","129073"),("Abhi Raj","+91 0437426650","[email protected]","Orai","Uttar Pradesh","642052"),("Anju Jain","+91 9379993216","[email protected]","Barrackpur","West Bengal","262926"),("Punthali Patel","+91 1995668376","[email protected]","Agartala","Tripura","854566"),("Adityavardhana Raj","+91 2949560293","[email protected]","Mandya","Karnataka","402160"),("Trivikram Jain","+91 4774138961","[email protected]","Shimla","Himachal Pradesh","898078"),("Abhijvala Khan","+91 6377255209","[email protected]","Ongole","Andhra Pradesh","643743"),("Deepamala Khan","+91 2505109221","[email protected]","Dera Ghazi Khan","Punjab","202748"),("Prabodh Jain","+91 9206164306","[email protected]","Ichalkaranji","Maharastra","824154"),("Ivy Raj","+91 1746808531","[email protected]","Mathura","Uttar Pradesh","658786");
  7. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Mehboob Kumar","+91 2391427009","[email protected]","Banda","Uttar Pradesh","244722"),("Foolan Singh","+91 6358218246","[email protected]","Vellore","Tamil Nadu","480246"),("Shantashil Raj","+91 4808966091","[email protected]","Jabalpur","Madhya Pradesh","491272"),("Milika Jain","+91 4658411083","[email protected]","Surendranagar","Gujarat","204407"),("Premendra Singh","+91 7403133749","[email protected]","Guntakal","Andhra Pradesh","728751"),("Kovida Singh","+91 0541439671","[email protected]","Tirunelveli","Tamil Nadu","974753"),("Soma Kumar","+91 3659466791","[email protected]","Jammu","Jammu and Kashmir","941917"),("Gursharan Khan","+91 9024113258","[email protected]","Bhuj","Gujarat","719434"),("Bankim Patel","+91 8094210264","[email protected]","Khanewal","Punjab","177010"),("Marala Jain","+91 0378538860","[email protected]","Palakkad","Kerala","429909");
  8. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Rabia Ismail","+91 1657940571","[email protected]","Panipat","Haryana","688160"),("Daksha Raj","+91 3641589125","[email protected]","Berhampore","West Bengal","804737"),("Mandakranta Patel","+91 9852272862","[email protected]","Sasaram","Bihar","623102"),("Anuprabha Kumar","+91 6237900334","[email protected]","Nizamabad","Andhra Pradesh","593445"),("Vir Patel","+91 2579927466","[email protected]","Kalyan","Maharastra","174189"),("Tarala Kumar","+91 2605442982","[email protected]","Ambala Sadar","Haryana","241425"),("Lakshman Ismail","+91 3984265569","[email protected]","Meerut Cantonment","Uttar Pradesh","859861"),("Faiz Jain","+91 0123429103","[email protected]","Gadag Betigeri","Karnataka","410269"),("Tapasranjan Raj","+91 1086946600","[email protected]","Dibrugarh","Assam","176175"),("Praful Raj","+91 9366449342","[email protected]","Jamshedpur","Jharkhand","188654");
  9. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Sajni Raj","+91 4013952029","[email protected]","Haridwar","Uttarakhand","619964"),("Chithayu Ismail","+91 1022697096","[email protected]","Haridwar","Uttarakhand","169322"),("Kunjalata Kumar","+91 9278004211","[email protected]","Jammu","Jammu and Kashmir","585487"),("Jagadip Patel","+91 7946515503","[email protected]","Shimla","Himachal Pradesh","958300"),("Rajani Jain","+91 5344737535","[email protected]","Jaipur","Rajasthan","744903"),("Sanjushree Patel","+91 1525259102","[email protected]","Rohtak","Haryana","774298"),("Ekanga Jain","+91 6936089875","[email protected]","Varanasi","Uttar Pradesh","394734"),("Parindra Raj","+91 4847225814","[email protected]","Srinagar","Jammu and Kashmir","867882"),("Girika Singh","+91 1518847324","[email protected]","Dehri","Bihar","362390"),("Paridhi Khan","+91 9496633285","[email protected]","Trivandrum","Kerala","235737");
  10. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Labangalata Jain","+91 0179755524","[email protected]","Kharagpur","West Bengal","818516"),("Nikhila Patel","+91 5249395657","[email protected]","Dabgram","West Bengal","857091"),("Egaiarasu Raj","+91 7257542959","[email protected]","Chhindwara","Madhya Pradesh","952234"),("Vajra Singh","+91 9512500148","[email protected]","Patan","Gujarat","710909"),("Kavan Jain","+91 6621933921","[email protected]","Mirzapur-cum-Vindhyachal","Uttar Pradesh","511773"),("Hansanandini Ismail","+91 2625553960","[email protected]","Ganganagar","Rajasthan","283747"),("Sheetal Singh","+91 9946963375","[email protected]","Darbhanga","Bihar","310985"),("Rasna Patel","+91 2249690880","[email protected]","Ratlam","Madhya Pradesh","308967"),("Nileen Kumar","+91 8906951028","[email protected]","Pali","Rajasthan","918117"),("Ulhas Ismail","+91 7856615943","[email protected]","Tiruppur","Tamil Nadu","454635");
  11. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Kush Khan","+91 8594428218","[email protected]","Kollam","Kerala","670661"),("Nairit Jain","+91 5444534893","[email protected]","Nagpur","Maharastra","516616"),("Teja Ismail","+91 6041493029","[email protected]","Tirunelveli","Tamil Nadu","719114"),("Satyamurty Raj","+91 4348764573","[email protected]","Sonipat","Haryana","566443"),("Pradeepta Jain","+91 8512244663","[email protected]","Belgaum","Karnataka","828139"),("Nitin Khan","+91 9292734729","[email protected]","Kanchipuram","Tamil Nadu","110598"),("Latafat Jain","+91 5319148673","[email protected]","Nadiad","Gujarat","101486"),("Harshavardhan Raj","+91 4042991523","[email protected]","Bhind","Madhya Pradesh","346217"),("Devamati Ismail","+91 1734004105","[email protected]","Trivandrum","Kerala","946781"),("Vajrapani Singh","+91 7386213844","[email protected]","Yeotmal","Maharastra","669403");
  12. INSERT INTO `myTable` (`name`,`phone`,`email`,`city`,`state`,`pincode`) VALUES ("Jayanti Jain","+91 1062530597","[email protected]","Balurghat","West Bengal","250627"),("Shashibala Raj","+91 3280194914","[email protected]","Jhelum","Punjab","928089"),("Kapotakshi Singh","+91 6665598594","[email protected]","Bhilwara","Rajasthan","971140"),("Kanan Khan","+91 2724386909","[email protected]","Salem","Tamil Nadu","287199"),("Japesh Raj","+91 9771071422","[email protected]","Tenali","Andhra Pradesh","365484"),("Shaswati Singh","+91 4615758562","[email protected]","Vejalpur","Gujarat","914892"),("Suvarnmala Ismail","+91 5437208937","[email protected]","Delhi","Delhi","607355"),("Bharadwaj Jain","+91 7022710810","[email protected]","Rampur","Uttar Pradesh","674963"),("Hemadri Raj","+91 5556575307","[email protected]","Bikaner","Rajasthan","878837"),("Nirmala Ismail","+91 3825180620","[email protected]","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!