CPukgYzq

1Export contents of SQLite table and import it in php myAdmin table
2CREATE TABLE StateDeathTax_V2 (Sequence Integer DEFAULT TEXT,Question,Alabama,Alaska,Arizona,Arkansas,California,Colorado,Connecticut,Delaware,"District of Columbia" TEXT DEFAULT NULL,Florida,Georgia,Hawaii,Idaho,Illinois,Indiana,Iowa,Kansas,Kentucky,Louisiana,Maine,Maryland,Massachusetts,Michigan,Minnesota,Mississippi,Missouri,Montana,Nebraska,Nevada,"New Hampshire" TEXT DEFAULT NULL,"New Jersey" TEXT DEFAULT NULL,"New Mexico" TEXT,"New York" TEXT DEFAULT NULL,"North Carolina" TEXT DEFAULT NULL,"North Dakota" TEXT DEFAULT NULL,Ohio,Oklahoma,Oregon,Pennsylvania,"Rhode Island" TEXT DEFAULT NULL,"South Carolina" TEXT,"South Dakota" TEXT DEFAULT NULL,Tennessee,Texas,Utah,Vermont,Virginia,Washington,"West Virginia" TEXT DEFAULT NULL,Wisconsin,Wyoming)
3	
4SQL query:
5
6CREATE TABLE IF NOT EXISTS `roster`.`TABLE 4` (`Sequence` int(1), `Question` varchar(56), `Alabama` varchar(66), `Alaska` varchar(68), `Arizona` varchar(196), `Arkansas` varchar(114), `California` varchar(78), `Colorado` varchar(83), `Connecticut` varchar(463), `Delaware` varchar(295), `District of Columbia` varchar(392), `Florida` varchar(92), `Georgia` varchar(66), `Hawaii` varchar(274), `Idaho` varchar(107), `Illinois` varchar(626), `Indiana` varchar(253), `Iowa` varchar(337), `Kansas` varchar(153), `Kentucky` varchar(216), `Louisiana` varchar(96), `Maine` varchar(1029), `Maryland` varchar(358), `Massachusetts` varchar(867), `Michigan` varchar(76), `Minnesota` varchar(470), `Mississippi` varchar(64), `Missouri` varchar(77), `Montana` varchar(79), `Nebraska` varchar(151), `Nevada` varchar(79), `New Hampshire` varchar(69), `New Jersey` varchar(775), `New Mexico` varchar(17), `New York` varchar(747), `North Carolina` varchar(73), `North Dakota` varchar(1366), `Ohio` varchar(509), `Okla[...]
7
8MySQL said: Documentation
9#1060 - Duplicate column name 'NULL'