InnoDB: default from 5.5 & later, with transaction support, ACID compliant, row-level locking, crash-recovery & multi-version concurrency control, foreign-key referential integrity constraint
MyISAM: fast, no transaction, table-level locking
Memory: fastest, no transaction, table-level locking
CSV:
http://dev.mysql.com/doc/
http://dev.mysql.com/doc/refman/5.5/en/index.html
https://help.ubuntu.com/12.04/serverguide/mysql.html
sudo apt-get install mysql-server mysql-client libmysql-java
Ubuntu mysql packages includes mysql-client and mysql-server that can be installed separately (so if one only wants server or client).
MySQL Workbench - a graphic tool for database modeling, administration and queuing
libmysql-jave : JDBC driver
After install, no password is given to root
Try: mysql --user root
root@usvr:/etc/bacula# netstat -tap |grep mysql
tcp 0 0 localhost:mysql *:* LISTEN 5677/mysqld
Launch client: mysql --user=root --password=password
Show / Select Databases: show databases; use xxx_database;
SQL Statement Syntax: http://dev.mysql.com/doc/refman/5.5/en/sql-syntax.html
Data Dictionary: http://dev.mysql.com/doc/refman/5.5/en/information-schema.html