最贊回答 / x偏愛_南半球o
把 默認(rèn)值'3' 換成?'男'或者'女'或者'保密’其中一個(gè)
最贊回答 / Tracts
1、執(zhí)行命令<...code...>//下面這步好像不用也行2、將下面語(yǔ)句添加到mysql.ini中:log_bin_trust_function_creators = 1;來(lái)源:StackOverflowhttps://stackoverflow.com/questions/26015160/deterministic-no-sql-or-reads-sql-data-in-its-declaration-and-binary-logging-i
你們這樣寫試試
SELECT p.type_id,p.type_name,count(s.type_name) num FROM tdb_goods_types AS p LEFT JOIN tdb_goods_types AS s ON s.parent_id = p.type_id GROUP BY p.type_id ORDER BY p.type_id;
SELECT p.type_id,p.type_name,count(s.type_name) num FROM tdb_goods_types AS p LEFT JOIN tdb_goods_types AS s ON s.parent_id = p.type_id GROUP BY p.type_id ORDER BY p.type_id;
2020-05-21
數(shù)據(jù)插入:
若省略列名,需為每個(gè)列賦值
若沒(méi)有為記錄的某個(gè)字段賦值,則顯示NULL
若不給自增字段賦值,或?yàn)槠滟x值為NULL,或?yàn)槠滟x值為DEFAULT,都不改變其規(guī)則
若列有定義默認(rèn)約束。當(dāng)插入記錄時(shí),如果沒(méi)有為字段賦值或?yàn)槠滟x值為DEFAULT,則自動(dòng)賦予默認(rèn)值
若省略列名,需為每個(gè)列賦值
若沒(méi)有為記錄的某個(gè)字段賦值,則顯示NULL
若不給自增字段賦值,或?yàn)槠滟x值為NULL,或?yàn)槠滟x值為DEFAULT,都不改變其規(guī)則
若列有定義默認(rèn)約束。當(dāng)插入記錄時(shí),如果沒(méi)有為字段賦值或?yàn)槠滟x值為DEFAULT,則自動(dòng)賦予默認(rèn)值
2020-05-19