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).