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;