big5 stored as latin1 and want utf

2006-10-23 Thread Dan Jacobson
In the manual we see If you have non-`latin1' data stored in a 4.0 `latin1' table and want to convert the table column definitions to reflect the actual character set of the data, use the instructions in *Note Charset-conversion::. But what about e.g., users who have big5 data sorted as lati

warn before mentioning deprecated material

2006-10-23 Thread Dan Jacobson
In the manual we see: * Columns selected for output can be referred to in `ORDER BY' and `GROUP BY' clauses using column names, column aliases, or column positions. Column positions are integers and begin with 1: mysql> SELECT college, region, seed FROM tournament

mention regular accounts' setup before superusers'

2006-10-20 Thread Dan Jacobson
As its first example of creating accounts, the manual says After connecting to the server as `root', you can add new accounts. The following statements use `GRANT' to set up four new accounts: mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDENTIFIED BY