統(tǒng)計數(shù)量（去重）
SELECT COUNT(DISTINCT common_name) FROM drug;load file
> load data local infile 'file_path' into table test_table
> FIELDS TERMINATED BY '\t<FIELDS TERMINATED>\t'
> ENCLOSED BY ” ESCAPED BY ”
> LINES TERMINATED BY '\n<LINES TERMINATED>\n'
> (field1出皇，field2，field3，field4，field5，field6);
若數(shù)據(jù)中有反斜杠，需要指定 ESCAPED BY ”
- mysql對json的支持
- SELECT json_extract(obj, '$.name') FROM
table_nameWHEREfield1=0 and json_extract(json_field, '$.name') is not null; - update
table_namesetjson_field= json_set(json_field, '$.country', '德國', '$.name', '乳糖') whereid= 12505031;
