分享程序员开发的那些事...
更新时间：2022-08-21 22:30:02
慢慢来，慢慢来。。
增：
INSERT INTO person (person_id, fname, lname, gender, birth_date) VALUES (null, 'William', 'Turner', 'M', '1972-05-27');
INSERT INTO person (person_id, fname, lname, gender, birth_date, street, city, state, country, postal_code) VALUES (null, 'Susan', 'Smith', 'F', '1975-11-02', '23 Maple St.', 'Arlington', 'VA', 'USA', '20220');
删：
DELETE FROM person WHERE person_id = 2;
改：
ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;
UPDATE person SET street = '1225 Tremont St.', city = 'Boston', state = 'MA', country = 'USA', postal_code = '02138' WHERE person_id = 1;
查：
SELECT person_id, fname, lname, birth_date from person WHERE lname = 'Turner';