· 11 years ago · May 29, 2015, 06:40 AM
1DROP TABLE mytable;
2CREATE TABLE mytable(
3 FIELD1 VARCHAR(4) NOT NULL PRIMARY KEY
4, FIELD2 VARCHAR(33)
5, FIELD3 VARCHAR(6)
6, FIELD4 VARCHAR(7)
7, FIELD5 VARCHAR(12)
8, FIELD6 VARCHAR(34)
9, FIELD7 VARCHAR(1)
10, FIELD8 VARCHAR(1)
11, FIELD9 VARCHAR(1)
12, FIELD10 VARCHAR(1)
13);
14INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('Vote','Name','Gender','Roll_no','phone','email','','','','');
15INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Sambhana Mani Naga Venkata Kalyan','M','811405','8019890385','smnvkalyan@gmail. com','','','','');
16INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','G.Shravya','F','811420','8985344059','gshravyagoud05@gmail.com','','','','');
17INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Prasad Patil','M','811443','7387901034','patilprasad263@gmail.com','','','','');
18INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','neha bagla','F','811445','9441361131','nehadivyabagla4@gmail.com','','','','');
19INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Akshay Gangavalli','M','811475','9550228547','akshaygangavalli@gmail.com','','','','');
20INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','b.sandeep naik','M','821325','9666228574','sandeepnaik1511@gmail.com','','','','');
21INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Akhil kumar Mengani','M','821404','7893298890','777akhilkumar@gmail.com','','','','');
22INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','gajanand bairwa','M','821406','8143684820','gajanandkundara123@gmail.com','','','','');
23INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','chidara sai naga vamshi','M','821407','9966754799','vamshi.vamu@gmail.com','','','','');
24INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','dasari vyshnavi','F','821416','9949554778','dasarivyshu@gmail.com','','','','');
25INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','akshay garg','M','821424','7032225550','akshaygarg834@gmail.com','','','','');
26INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Saikiran','M','821433','8897030345','saikirangogurla22@gmail.com','','','','');
27INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Kunapaneni Siddhartha','M','821435','9010031318','Kunapanenisiddhartha@gmail.com','','','','');
28INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Aditya Tayade','M','821437','8308415206','smtayade2021997 @gmail.com','','','','');
29INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','K.Ranjitha','F','821453','9553070304','ranjithakosgi,@gmail.com','','','','');
30INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','C C Srikanth','M','821471','7674955233','chellaboina.srikanth3@gmail.com','','','','');
31INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Spandan Roy','M','821474','9874186251','spandan_roy_2007@yahoo.co.in','','','','');
32INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Vivek Kammula','M','821475','8297201296','vivekkammula@yahoo.com','','','','');
33INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','chetan baghel','M','831406','8109726327','gajanandkundara123@gmail.com','','','','');
34INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','shivanagi manjunath guralingappa','M','831414','8143679675','smanjunathg@gmail.com','','','','');
35INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','ramajogi yogitha sumana','F','831432','9573163312','yogitha.rahul@gmail.com','','','','');
36INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','NADEEM GAUHAR','M','831439','8686203005','nadeem.gauhar11@gmail.com','','','','');
37INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','SOMA RANJITH','M','841405','9959018640','ranjithsoma1@gmail.com','','','','');
38INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Rohit','M','841425','8978918868','kovelarohith@gmail.com','','','','');
39INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','pulugu sarathchendra manikyam','M','841431','9985811902','sarathpulugu@gmail.com','','','','');
40INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','sravya chinthakindi','F','841438','8019918645','shravs.ammulu@gmail.com','','','','');
41INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','B.paparao','M','841453','7306825802','paparao.bhukya2@gmail.com','','','','');
42INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Vinay Gedam','M','841455','8805564007','gedamvinay@gmail.com','','','','');
43INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','A.uma prasanna','F','841474','9912229790','athikprasanna.uma@gmail.com','','','','');
44INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Swarali joshi','F','841476','9701834250','swarali_anagha@yahoo.co.in','','','','');
45INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Sanshray Kumar Dewangan','M','851401','8143684606','sanshraydewangan1@gmail.com','','','','');
46INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','S.Abhilash','M','851406','7674911383','abhilashsivva@gmail.com','','','','');
47INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','B.Rashmi','F','851413','8121689155','badinapuramrashmi@gmail.com','','','','');
48INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Kranthi Kiran GV','M','851420','7032403482','kranthi.gv@gmail.com','','','','');
49INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Ravuri Sri Harsha Aditya','M','851422','7842717109','shannuharsha@gmail.com','','','','');
50INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','naveen indoria','M','851430','9024066075','naveenindoria1103@gmail.com','','','','');
51INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','MAYANK DHAWARIYA','M','851443','8801686343','mayankdhawariya50@gmail.com','','','','');
52INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Ankur saini','M','851445','7032222144','sainiankur55@gmail.com','','','','');
53INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Laxmi Kaushik Reddy Mukkamalla','M','851452','9502681959','ml.Kaushik.reddy@gmail.com','','','','');
54INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','C.Akshaya','F','861417','73 86 398369','akshayasmile8@gmail.com','','','','');
55INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','saurabh rao','M','861426','8081697665','me.saurabhrao11@gmail.com','','','','');
56INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Joyen Avinash Soren','M','861443','8143607955','avinashsoren14@gmail.com','','','','');
57INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','kamlesh sharma','M','861449','9032251671','kamleshsharma538@gmail.com','','','','');
58INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Naresh Malviya','M','861459','8106478456','nmalviya1929@gmail.com','','','','');
59INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Rahul Guin','M','861473','9.18897E+11','rahul_guin@yahoo.com','','','','');
60INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Arbaaz Shaik','M','861474','9.17032E+11','arbaazx21@gmail.com','','','','');
61INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Pothineni Nitin','M','861477','9.18985E+11','nitinpothineni@gmail.com','','','','');
62INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','VAMSIKRISHNA KANAGALA','M','911404','8143679680','vamsikrishna.kvnss@gmail.com','','','','');
63INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','NIKHIL REDDY KUNTA','M','911405','9966379389','kunta.nike.n@gmail.com','','','','');
64INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','kamreddy ankusha','F','911409','7382782987','k.ankusha@gmail.com','','','','');
65INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Rahul Kumar','M','911427','7073065369','rahul30355235@gmail.com','','','','');
66INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','ankush mangal','M','911428','814369862','ankushmangal686@gmail.com','','','','');
67INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Rohan Gupta','M','911432','8374658353','rohangpt169@gmail.com','','','','');
68INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Anshul Goyal','M','911443','9701834645','anshul.goyal7@gmail.com','','','','');
69INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Gautham Rajsimha Pulipati','M','921405','9391396499','Pulipatirajsimha@gmail.com','','','','');
70INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Harshavardhan reddy baddam','M','921410','9490621714','baddamharsha33@gmail.com','','','','');
71INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','ISHAN SHARMA','M','921431','8374074830','sharmaishan409@gmail.com','','','','');
72INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Bhukya Ashok','M','921437','8185066922','ashokbhukya2108@gmail.com','','','','');
73INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Dubasi Akhil','M','921448','9866054833','rajendraprasad.dubasi1@GMAIL.COM','','','','');
74INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Sai kumar','M','921472','9550214580','srsaikumarreddy@gmail.com','','','','');
75INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Nikitha Nuthi','F','931401','7075010215','nikithanuthi@gmail.com','','','','');
76INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','pankaj kumar chaurasia','M','931405','8374650678','pk84ya22@gmail.com','','','','');
77INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Sashi bhushan rana','M','931421','7032295559','ranasb2012@gmail.com','','','','');
78INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Eravathri Saisuchendhra','M','931440','8008427449','saisuchendhra@gmail.com','','','','');
79INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','K Shashank Reddy','M','931474','8897219663','shashank10kasala10@gmail.com','','','','');
80INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Mulkur Samson','M','941407','8688809296','mulkursamson@gmail.com','','','','');
81INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','rishabh tiwari','M','941420','8418979148','rishabhtiwari277@gmail.com','','','','');
82INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','A.Teja kumar','M','941426','9959320713','ateja463@gmail. com','','','','');
83INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','ARKOPRABHO DUTTA','M','941446','9908822104','arkodutta21@gmail.com','','','','');
84INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Vineeth Kumar Bhende','M','941477','9701607926','bhendevineethkumar@gmail.com','','','','');
85INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Abhijay','M','951407','8446311508','abhijaypagare10@gmail.com','','','','');
86INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Gajam Venu Gopal','M','951412','7386909116','venugopalgajam@gmail.com','','','','');
87INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','ADITYA SINGH','M','951419','9989070412','singh.bittu96@gmail.com','','','','');
88INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','nishu bansal','F','951428','9949794100','bansal19nishu@gmail.com','','','','');
89INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Appoose M D','M','951435','8186945589','4pp0053@gmail.com','','','','');
90INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('x','Y.PRISCILLA �CHRISTY','F','951439','7893214886','priscilla.christy.146@facebook.com','','','','');
91INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','PANKAJ KUMAR GUPTA','M','951443','9912619878','pankajgupta062@gmail.com','','','','');
92INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','kiran konduru','M','961401','9502348047','kiran.kumar.00796@gmail.com','','','','');
93INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','T.Udaykiran reddy','M','961431','8463944773','nallapatis969@gmail.com','','','','');
94INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','SUMIT SHARMA','M','961475','9963602934','sumitfunky123@gmail','','','','');
95INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','Nadarajah Praveen','M','961479','7893056015','n.praveen.rc@gmail.com','','','','');
96INSERT INTO mytable(FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('','','','','','','','','','');