数据库可以关联不同的表单,从而实现数据快速互通;
增删改查
1.INSERT INTO table_name ( field1, field2,...fieldN ) VALUES( value1, value2,...valueN );
INSERT INTO table_name (name,age,sex ) VALUES(“ 张三”,20,‘男’ );
2.DELETE FROM runoob_tbl WHERE runoob_id =3;
3.UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause]
4.SELECT column_name,column_name FROM table_name [WHERE Clause] [LIMIT N][ OFFSET M]
1.增
第一种方法:
添加 field1就像包工头,像一个带队
表索引 + 值 就叫 添加
INSERT INTO table_name ( field1, field2,...fieldN ) VALUES( value1, value2,...valueN );
INSERT INTO table_name (name,age,sex ) VALUES(“ 张三”,20,‘男’ );
INSERT INTO table_name (name,age,sex ) VALUES(“ 张四”,21,‘男’ );
如果数据是字符型ÿ