How to delete data from a Table

[deepak19]

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.

Thanks,
Deepak

[NCP]

Hi @deepak19,

Please check the post.

How can I delete all the documents in a doctype using terminal?

Hi @oip_p, Make sure, first take a backup. Example: If you want to delete all records from the ToDo doctype using the terminal, then apply it. bench --site your-sitename.com mariadb TRUNCATE `tabToDo`; Your all record will remove. Then reload and check it. Thank You!

TRUNCATE `tabPrice List`;

Thank You!

[deepak19]

@NCP

TRUNCATE tabPrice List;

Thank you very much Nihantra. This worked.

[Yogeshwaran]

@NCP After Truncate the table, How do I set the naming_series from starting of 1?

[NCP]

Hi @Yogeshwaran,

Go to the Document Naming Settings and Update Series Counter according to the doctype.

[Yogeshwaran]

@NCP Thank you for reply, It’s working fine, but I had given a naming_series to the doctype field means what should I do? Please help me…

[NCP]

same step, that i provieded.

[Yogeshwaran]

@NCP Thank You, Now it’s working fine…