Re: How to delete millions of record in a loop

[pandu hondu]

I don't know what is the issue here

use mydb
delimiter //
SELECT 'Comment';
delimiter;



Database changed
+---------+
| Comment |
+---------+
| Comment |
+---------+
1 row in set (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter' at line 1


When I change ' to ` Then it does not print , have a look here

Database changed
ERROR 1054 (42S22): Unknown column 'Comment' in 'field list'

What is the problem?