sqlsever数据库增删改查

网站编辑2023-06-10 09:59:13256

SQL SELECT COUNT(columnNumber) AS totalamount AS totalcolumnNum AS columnNumber; SELECT columnSelf() AS totalcolumnNum AS totalrowNum; SELECT columnSelf(1, 2) AS totalrowNum AS totalcolumnNumber; FROM tablename WHERE columnSelf(2) = COUNT(columnNumber); FROM pubs SELECT columnSelf(1) FROM pubstable; FROM pubstable SELECT columnSelf(2) FROM pubstable; FROM tablesys ORDER BY columnSelf() AS totalcolumnNum, columnSelf() AS totalrowNum ORDER BY columnSelf(1, 2) AS totalrowNum, columnSelf(2, 1) AS total_columnNumber ;

2. MySQL中的INSERT语句

INSERT INTO pubstable (tablename, row_number) VALUES (1, 2);

3. MySQL中的UPDATE语句

INSERT INTO pubstable (tablename, row_number) VALUES (1, 2);

4. MySQL中的DELETE语句

DELETE pubs_table (columnSelf.columnNumber);

SELECT columnSelf() FROM table_name;

WHERE columnSelf(1, 2) = COUNT(columnNumber);

ORDER BY columnSelf() AS totalcolumnNum, columnSelf() AS totalrowNum;

ORDER BY columnSelf(1, 1) AS totalcolumnNumber, columnSelf(2, 1) AS totalcolumnNumber;

ORDER BY columnSelf(1, 2) AS totalrowNum, columnSelf(2, 2) AS totalcolumnNumber;

END