SQL基础

如图1所示，关联多张表删除数据

删除b FROM tb_qy_yp_folder a，tb_qy_yp_file b

WHERE b.folder_id = a.id AND b.id ='1';

2，关联多张表更新数据

UPDATE tb_qy_yp_folder a，tb_qy_yp_file b
SET b.file_name =' 
file'WHERE b.folder_id = a.id AND b.id ='1';

3，修改字段类型

ALTER TABLE tb_question_info MODIFY`type` varchar（2）DEFAULT NULL COMMENT'问卷类型';

4，增加字段

ALTER TABLE tb_question_info ADD'type` varchar（2）DEFAULT NULL COMMENT'问卷类型';

5，增加索引

ALTER TABLE tb_question_info ADD INDEX`idx_questioninfo_type`（`questionnaire_id`，`type`）USING BTREE;

6，删除索引（索引只能删了再建）

DROP INDEX`idx_questioninf_type` ON tb_question_info;

7，查看表结构

DESC tb_question_info;

8、len函数

SELECT COUNT(1) FROM a WHERE LENGTH(name) > 30;