摘要:
子查询(Subquery)是指出现在其他SQL语句内的SELECT子句例如:SELECT * FROM t1 WHERE col1 = (SELECT col2 FROM t2);其中SELECT * FROM t1,称为Outer Query/Outer Statement(外层查询)SELECT... 阅读全文
摘要:
插入记录INSERT [INTO] tbl_name [(col_name,...)] {VALUES丨VALUE} ({expr丨DEFAULT},...) (...),...INSERT [INTO] tbl_name SET col_name = {expr丨DEFAULT},...说明:此方... 阅读全文