24 Mar MySQL Tutorial
MySQL is an open-source relational database management system. Initially released on 23rd May 1995 and runs on the following Operating Systems: Linux, Solaris, macOS, Windows, and FreeBSD. Herein, we have provided a complete MySQL Tutorial for Beginners.
The MySQL tutorial is prepared for students, engineers, and professionals. Beginning with the introduction and installation, you will learn how to create a database and tables, and how to insert records and select them. We have also included operators, clauses, and subquery lessons. With that, step-by-step text and video lessons are provided.
MySQL Video Course for Beginners
Run MySQL Online
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
-- 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'; |
No Comments