SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE `test_table` ( `id` int(11) NOT NULL, `item_name` varchar(225) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8; -- -- Dumping data for table `test_table` -- INSERT INTO `test_table` (`id`, `item_name`) VALUES (1, 'EX CADA '), (2, 'EX CADA '); -- -- Indexes for dumped tables -- -- -- Indexes for table `test_table` -- ALTER TABLE `test_table` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `test_table` -- ALTER TABLE `test_table` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 3; COMMIT;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear