Basic Introduction to MySQL (1 ):
1. MySQL versions earlier than MySQL 4 can be managed using an official management tool, similar to MSSQL's "query analyzer"
You can download it at http://dev.mysql.com/downloads/administrator/1.0.html.
MySQL 4 and later versions have more powerful management tools, MySQL Administrator and MySQL Query Browser, which can be downloaded at http://dev.mysql.com.
2. To connect to MySql data in the. net environment, you must install MySql ctor/Net provided by MySQL to connect to MySql DATA. Install MySql and reference it in the program! · MySql.. Data. dll
Reference
// Using MySql. Data;
// Using MySql. Data. MySqlClient;
Microsoft is
// Using System. Data;
// Using System. Data. SqlClient;
3. garbled characters are displayed in Chinese.
Add a sentence to the My. ini (winnt \) file.
Default-charactor-set = gb2312
Restart the service and then insert data.
Note: mySQL 4 and later versions are in the program installation directory (for example, c: \ mysql.
4. backup and recovery tables
Select * from t_user into outfile 'C: \ mysqlbackup \ t_user_20050725.dat'
Load Tata infile 'C: \ mySqlBackup \ t_user_20050725.dat 'into table t_user