MariaDB (or MYSQL) Commands



To Create a DB
To Create DB_Name
create database [DB_Name];

To See all the DB
To See all the DB in Server
show databases;

To Delete a DB
To Delete a DB_Name
drop database [DB_Name];

To Switch to a DB
To Switch to DB_Name
use [DB_Name];

To See Tables
To See all the Tables in the DB
show tables;

To Create a Table
To Create a Table with Field_Name_01 & Field_Name_02 & Field_Name_03 & Field_Name_04

CREATE TABLE `[Table_Name]` (
    `Field_Name_01` int(11) NOT NULL,
    `Field_Name_02` char(10) DEFAULT NULL,
    `Field_Name_03` char(20) DEFAULT NULL,
    `Field_Name_04` char(80) DEFAULT NULL,
    `Field_Name_05` char(20) DEFAULT NULL,
    PRIMARY KEY (`Field_Name_01`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

To Delete a Table
drop table [Table_Name];

To Show selected Records sorted
To Show Records sorted in an Field_Name_01 where Field_Name_02 is'XXXXXX' to'Y'
SELECT [Fild_Name_01], [Fild_Name_02] FROM [Table_Name] where [Field_Name_02] = 'XXXXXX' ORDER BY [Fild_Name_01];
To Show all Record in Table_Name_01 & Fild_Name_03 in Table_Name_02 with Table_Name_01.Fild_Name_01=Table_Name_02.Fild_Name_02'
SELECT [Table_Name_01].*, [Table_Name_02].[Fild_Name_03]
FROM [Table_Name_01] JOIN [Table_Name_02]
ON [Table_Name_01].[Fild_Name_01] = [Table_Name_02].[Fild_Name_02];

To Update Records
To Update Field_Name_01 of Record where Field_Name_02 is'XXXXXX' to'Y'
UPDATE [Table_Name] SET [Field_Name_01] = 'Y' where [Field_Name_02] = 'XXXXXX';

To Insert new Records
To Insert new Record with Field_Name_01 and Field_Name_02'
INSERT INTO [Table_Name] (Field_Name_01,Field_Name_02)
VALUES('X_001', 'Y_001'),
('X_002', 'Y_002'),
('X_003', 'Y_003');

To Delete Records
To Delete Records with Field_Name_01 = 'X'
DELETE FROM [Table_Name] WHERE Field_Name_01 = 'X'

To Insert Field
To Insert Field_Name in Table_Name
ALTER TABLE [Table_Name] ADD [Field_Name] [Field_Type]

To Delete Field
To Delete Field_Name in Table_Name
ALTER TABLE [Table_Name] DROP [Field_Name]

To Modify Field Name
To Modify Field Name from Field_Name_01 to Field_Name_02
ALTER TABLE [Table_Name] CHANGE [Field_Name_01] [Field_Name_02]

To Modify Field Type
To Modify Field Type to Field_Type
ALTER TABLE [Table_Name] MODIFY [Field_Name] [Field_Type]