MySQL database use

---restore content starts---

2. C # operation of the MySQL database stored procedure, URL
3. The
4. DATEDIFF () function returns the number of days between two dates.

     syntax DateDiff (DATE1,DATE2) date1 and Date2 parameters are valid dates or dates /  time expression. Note: Only the date part of the value participates in the calculation. Example  1   Use the following SELECT statement: Select DATEDIFF (   " 2008-12-30   ' ,  '  2008-12-29   '  

6. MySQL is not supported by select ... into syntax, using INSERT INTO ... Select instead of the same usage, let's take a look here. The new table exists and does not exist in two cases, using different statements. URL:

    1   select  * from   Old_talbe; This method will copy all the contents of old_table, in this way it is necessary to note that new_table Old_table primary key,extra,auto_ Increment and other properties, you need to manually add, see the following modification table is the field properties. Copy only table structure to new table # The first method, similar to the above, except that the data record is empty, giving a false condition to create table new_table  Span style= "COLOR: #0000ff" >select  * from  old_table where  1  =2  ; # The second method of CREATE table new_table like old_table;  

    

8. Differences between SQL Server and MySQL conversion and the same table as MySQL and SQL Server update operations (subqueries are not supported in MySQL)
10. SQL Server and MySQL cursor learning

    Declaring the cursor's simplest cursor declaration: DECLARE < cursor name >cursor for<select statement> forselect from Addsalary so I declare a cursor on the table addsalary MyCursor

12. WinForm custom Control Instances WinForm interface effects source code

---restore content ends---

MySQL database use