MySQL Queries for Beginner – Quick Start
Please read below MySQL specific queries for reference. These are just quick start queries. Connect to server (another way to connect to server from command prompt)
|
1 |
mysql -h localhost -u root -p |
List all the databases running in server
|
1 |
show databases; |
Creating new database
|
1 |
create database mydb; |
Select database to work on
|
1 |
use mydb; |
List all the tables from selected database
|
1 |
show tables; |
Create new […]