Learn Database Tutorial

MySQL: Commands Cheat SheetTo login (from unix shell) use -h only if needed.[mysql dir]/bin/mysql -h hostname -u root -pCreate a database on the sql server.create database [databasename];List all databases on the sql server.show databases;Switch to a database.use [db name];To see all the tables in the db.show tables;To see database’s field formats.describe...

Read More