1. When developing a database project, you should first design, including which tables, every item in the table, which is the key, database Engine type, and more. After the database is designed, the program implemented around the established database.
2. The object of the pointer type is preferably initialized to NULL, such as "mysql *", and so on.
3. "Char * string =" this is a char string. "" After the first value is defined, it will be dangerous, especially after he is added, such as functions such as "strcat". This will likely lead to a pointer.
4. When using the MySQL C API, the pointer is passed between several functions, or the reference to the pointer should be taken to distinguish.
5. When operating the MySQL, do not believe that any data from the client is confirmed, such as the sensitive characters in the data, for example, using the function mysql_real_escape_string (). Self-processing. Otherwise, it will lead to malicious users, such as SQL INJECTION. http://www.unixwiz.net/techtips/sql-injection.html
