python - Clear SQL database -


i want remove entered data sql database. using python handle of sql statements program - did not make backup of clean database, , want clear records , reset primary ids etc without affecting structure of database ready ship code.

i using python , sqlitestudio.

thanks.

in sqlitestudio's sql editor execute command:

delete table_name; 

if have multiple tables command is:

delete table_name_1, table_name_2,...; 

instead of table_name put name of table(s).


Popular posts from this blog