sql常用语法
SELECT * FROM R107 WHERE SHIPPING_SN IN (
'9B40500001200099',
'9B40500001200015')
UPDATE SET SHIPPING_SN=SERIAL_NUMBER,备注多久修改的 REWORK_NO='20210506' R107 WHERE SHIPPING_SN IN (
'9B40500001200099',
'9B40500001200015')
删除所有数据保存当前月数据
DELETE FROM tabel
WHERE 时间日期变量< DATE_SUB(NOW(),INTERVAL 1 MONTH)
时间查询
SELECT * FROM tabel
WHERE Date >'2021-10-20 10:00:19' AND DATE<'2021-10-20 10:00:40'
LIMIT 8
删除数据库
truncate table savedata
//Mysql数据插入数据库方法
LOAD DATA LOCAL INFILE "D:/123.txt" INTO --地址
TABLE SFC.`users` FIELDS TERMINATED BY ',';
(MODEL_NAME,对应字段);
SQL 中的 TRIM 函数是用来移除掉一个字串中的字头或字尾。最常见的用途是移除字首或字尾的空白。这个函数在不同的资料库中有不同的名称:
- MySQL: TRIM( ), RTRIM( ), LTRIM( )
- Oracle: RTRIM( ), LTRIM( )
- SQL Server: RTRIM( ), LTRIM( )
BETWEEN 操作符实例
下面的 SQL 语句选取 alexa 介于 1 和 20 之间的所有网站:
实例
WHERE alexa BETWEEN 1 AND 20;
执行输出结果:
/*获取数据库名称*/
SELECT table_name FROM information_schema.tables
WHERE table_schema = 'sfc' /*数据库名称*/
AND table_type = 'base table'
获取日志信息
SELECT *
FROM sys.Fn_dblog(NULL, NULL)
where allocunitname like'MOItemTask'and operation in('LOP_INSERT_ROWS','LOP_DELETE_ROWS')
SELECT *
FROM sys.fn_dblog
(NULL, NULL)
WHERE [Begin time] > '2022/04/25 10:10:00:000' and [Begin time] < '2022/04/25 10:20:00:000'
and [Transaction Name] = 'UPDATE';