3 回答

TA貢獻(xiàn)1777條經(jīng)驗(yàn) 獲得超10個(gè)贊
SELECT * FROM persons WHERE "first_Name" = 'xyz';
'xyz'

TA貢獻(xiàn)1876條經(jīng)驗(yàn) 獲得超5個(gè)贊
關(guān)鍵字和未引號(hào)標(biāo)識(shí)符不區(qū)分大小寫(xiě)。因此: UPDATE MY_TABLE SET A = 5;
可以等效地寫(xiě)成: uPDaTE my_TabLE SeT a = 5;
UPDATE "my_table" SET "a" = 5; // equivalent to the above examples

TA貢獻(xiàn)1784條經(jīng)驗(yàn) 獲得超2個(gè)贊
添加回答
舉報(bào)