How to delete data from a Table

Hello Everyone,

I am trying to delete data from the table “tabPrice List” but I am getting syntax error:

MariaDB [bitnami_erpnext]> SHOW TABLES LIKE ‘tabPrice List’;
| Tables_in_bitnami_erpnext (tabPrice List) |
| tabPrice List |
1 row in set (0.002 sec)

MariaDB [bitnami_erpnext]> DELETE FROM ‘tabPrice List’;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘‘tabPrice List’’ at line 1

Please suggest the correct command to perform the above mentioned operation.


Hi @deepak19,

Please check the post.

TRUNCATE `tabPrice List`;

Thank You!

1 Like

Thank you very much Nihantra. This worked.