Differences between MySQL

1. this can be run in SQL Server, but in MySQL, this is the wrong string strsql = "select [f_id], [f_username], [f_content], [issecret], [f_time], [f_vidio_id] from [vidios]. [DBO]. [t_comment] Where f_states = '1 '";

2. MySQL implements the top Function
MySQL does not have the top keyword, but can use limit to achieve the top function, and can get the record between the N-M, the syntax is as follows

Select * from Table limit n, m

3. in MySQL, passing parameters and @ are all question marks.
String strsql = "select * From t_vidio where f_states =? F_states limit 0, "+ topcount. tostring ();
Mysqlconnection con = dB. getconnection ();
Mysqlcommand cmd = new mysqlcommand ();
Cmd. Parameters. Add ("? F_states ", mysqldbtype. int32). value = 1;

These problems have caused me to get tired for several hours.