SQLize Online / PHPize Online

A A A
Share   Donate   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; SELECT TRIM(item_name) item_name FROM test_table GROUP BY item_name ;
Stuck with a problem? Need help? Ask professionals on our Telegram channel!
Join the channel
Your quersion is posted.
Join our Telegram channel and get answers.
Send
Copy