...

Database Managment - MySql

Back to Course

Lesson Description


Lession - #1268 SQL Introduction


How to start Mysql


Step 0:: Create a catalog to keep every one of your works. ...
Step 1:: Download and MySQL Install. ...
Step 3:: Start the "MySQL Server" ...
Step 4:: Start a "Customer" ...
Step 5:: Change the Password for the Superuser "root" ...
Step 6:: Create a New User.
Step 7:: Create a new Database, a new Table in the Database, Insert Records, Query and Update

MySQL version mysql 2,mysql 5.6,mysql 5.7,mysql 7,8.0 to MySQL 8.0. 21,mysql 9.Default mysql hostname is localhost and mysql root password.

Let's see an example



-- create
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
mysql books mysql documentation mysql notes pdf mysql notesMysql Booksmysql history with mysql basic commands and mysql architecture