...

Database Managment - MySql

Back to Course

Lesson Description


Lession - #1273 SQL Syntax

Syntax(sentence structure >
.
All the SQL statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW and every one of the statements end with a semicolon (;>
. The main highlight be noted here is that SQL is case insensetive, and that implies SELECT and select have same meaning in SQL proclamations.



The MYSQL CREATE DATABASE statement is used to create a new SQL database.Default MYSQL Port 3306 is the default port for the exemplary MySQL convention ( port >
, which is utilized by the mysql client, MySQL Connectors, and utilities, for example, mysqldump is mysql backup command and mysqlpump.

Let's see an example


-- MYSQl  Table creation
CREATE TABLE EMPLOYEE (
  empId INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  dept TEXT NOT NULL
>
;

-- insert
INSERT INTO EMPLOYEE VALUES (0001, 'Clark', 'Sales'>
;
INSERT INTO EMPLOYEE VALUES (0002, 'Dave', 'Accounting'>
;
INSERT INTO EMPLOYEE VALUES (0003, 'Ava', 'Sales'>
;

-- fetch 
SELECT * FROM EMPLOYEE WHERE dept = 'Sales';

Output


Try it here
The mysql foreign key is utilized to connect at least one than one table together.
mysql basic Commands like mysql query commands,mysql unique constraint,mysql explain query,mysql login command,mysql json data type,mysql insert multiple rows mysql kill process mysql keywords Mysql query command