Monday, July 11, 2011

SQL database

25 May 2011
Basic MySQL info:

Path for my.cnf file:
ji@ji-cada:/etc/mysql$ cat my.cnf

mysql -u root -p

ID root
PS root

quit or exit to end.

Any command ends with ;

Table name is case sensitive, but column name, value in query are not case sensitive.
User name and password is case sensitive.

MySQL Query Browser

to start:

No comments: