更新值:UPDATE tig_users SET account_status = 1 WHERE ID < 3;
设置默认值:
ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT default_value;
插入新行 INSERT INTO products (product_no, name, price) VALUES (1, 'Cheese', 9.99);
更新值:UPDATE tig_users SET account_status = 1 WHERE ID < 3;
设置默认值:
ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT default_value;
插入新行 INSERT INTO products (product_no, name, price) VALUES (1, 'Cheese', 9.99);