KW Online Tools Zone
Knowledge Walls
View All Tools Home
KW CSV to MYSQL Converter
CSV
Paste your CSV
TableName
Delimiter
Clear
MYSQL
Generated mysql query will come here.
Clear
refno,title,author,year,price 1001,CPP,MILTON,2008,456 1002,JAVA,Gilson,2002,456 1003,Adobe Flex,Johnson,2010,566 1004,General Knowledge,Sinson,2007,465 1005,Actionscript,Gilto,2008,480
CREATE TABLE `books` (`refno` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `title` VARCHAR(500) NOT NULL, `author` VARCHAR(500) NOT NULL, `year` VARCHAR(500) NOT NULL, `price` VARCHAR(500) NOT NULL); INSERT INTO books(refno,title,author,year,price) VALUES(1001,"CPP","MILTON","2008","456"); INSERT INTO books(refno,title,author,year,price) VALUES(1002,"JAVA","Gilson","2002","456"); INSERT INTO books(refno,title,author,year,price) VALUES(1003,"Adobe Flex","Johnson","2010","566"); INSERT INTO books(refno,title,author,year,price) VALUES(1004,"General Knowledge","Sinson","2007","465"); INSERT INTO books(refno,title,author,year,price) VALUES(1005,"Actionscript","Gilto","2008","480");
Copyright © 2021 Knowledge walls, All rights reserved
Copyright © 2021 Knowledge walls, All rights reserved