Problem With Solutions

Something Different In Linux

Home » Posts tagged 'Mysql Commands'

Mysql Commands

Posted by Rishikesh Vispute Categories: Linux Commands, mysql

To login (from unix shell) use -h only if needed. # [mysql dir]mysql  -u username -p Create a database on the sql server. mysql> create database [databasename]; List all databases on the sql server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the db. mysql> show  [ Read More ]

Optimized by SEO Ultimate