facebook twitter youtube
Replication Query Optimization DB Tuning Server Load and Query Locking Linux Download Interview Questions Basic DB Commands Mysql
Basic DB Commands
in Basic DB Commands - 05 Dec, 2013
by Zafar Malik - no comments

DB Schema Related Commands # Database Creation: MySQL> CREATE DATABASE TEST_DB; — Where TEST_DB is my database name. # Table Creation (under TEST_DB): MySQL> USE TEST_DB; MySQL> CREATE TABLE TEST_TABLE(cust_id int, cust_name varchar(50), cust_address varchar(100)); # Table creation (Including all possible options related with table creation like primary key, index, unique index, relation ship etc.) […]