MySql
Description
MySql is an excellent database by T.C.X. DataKonsultAB as free software. It is a true multi-user, multi-threaded SQL database server.
Capability
MySQL since 1996 in an environment with more than 40 databases containing 10,000 tables, of which more than 500 tables have more than 7 million rows. This is about 100 gigabytes of mission-critical data.
Limitations
- It is not free for re-distribution.
- It requires a person with system administration knowledge for one time installation.
- It provides (requires) a person with DBA knowledge to setup accounts for users.
- It does not handle Unicode (UTF-8) characters correctly 100%.
Due to these limitations, MySql is replaced by other Database engine in 2008.
Escape characters for INSERT/UPDATE SQL
Character Number | Escape Character | Notes
|
---|
13 | \\\r | carriage return
|
34 | \\\" | double quote
|
39 | \\\' | single quote
|
9 | \t | tab
|
92 | \\\\ | back slash
|
References
Please refer to
MySql Web site.
Notes