MySQL Practical tips

1. 1: Import data from TXT into the database table, command:
2. Load Data local infile ' d:\\ file name . txt ' into table name fields terminated by ' \ t ';

2: After inserting data query display garbled, Solution: set character set_results=utf-8;  3: Multi-table multiple foreign key data querySELECT * from Userinfo,usertype,usercert where Userinfo.certid=usercert.certid and userinfo.typeid= Usertype.typeid limit?,?;SELECT * from Userinfo,usertype,usercert where Userinfo.certid=usercert.certid and userinfo.typeid= Usertype.typeid and userinfo.userid=140950223 and password=55555 limit?,?;

MySQL Practical tips