MySQL vs SQLite 清空資料表 語法

MySQL vs SQLite 清空資料表 語法

MySQL vs SQLite 清空資料表 語法




MySQL:        TRUNCATE tablename;


SQLite:       DELETE FROM tablename;

 

One thought on “MySQL vs SQLite 清空資料表 語法

  1. SQLite POS系統 常用語法:

    DELETE FROM order_data;
    DELETE FROM order_content_data;
    DELETE FROM order_payment_data;

    DELETE FROM upload_data;

發表迴響

你的電子郵件位址並不會被公開。 必要欄位標記為 *