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 […]