1.0.2 • Published 3 years ago
mysqluse_q v1.0.2
Mysql
Add
insert into FileName (name) values ('value');
Inquiry
select distinct * from FilName where name='' order by limit 0,1
from -- inquiry
where -- restricted condition
order by -- Sort The default ascending,DESC stands for descending order
limit -- Show the number of
Modify
UPDATE FileName set name ='' where id = 0;
set --modify data
where -- restricted condition
Delete
DELETE FROM FileName where id = 0;
FROM --Delete
where -- restricted condition
Sybase
TotalInt
SELECT count(*) as total FROM FileName;
All the query
SELECT * FROM FileName;
fuzzy query
SELECT * FROM FileName WHERE name LIKE '%s%';
Multiconditional query
SELECT * FROM FileName WHERE name LIKE '%s' AND id = 0;