码农复制# create a database: CREATEDATABASE menagerie; # create a tablein the database: USE menagerie; CREATETABLE pet (nameVARCHAR(20)); # connectto the databasein app and issue insert: INSERTINTO pet (name) VALUES (Friar Tuck); # add a column: ALTERTABLE pet ADD type VARCHAR(20)); # update existing record: UPDATE pet SET type = catWHEREname = Friar Tuck 1.2.3.4.5.6.7.8.9.10.
喜欢
讨厌