🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

Till now, we understood MySQL, SQL, and Data Types. Now it’s time to move from theory → practical. Let’s actually write some MySQL commands step by step 👇 🔹 Create Database A database is simply a container that holds your tables and data. CREATE DATABASE company ; 👉 This creates a new database named company. 👉 Output: Query OK, 1 row affected 🔹 Use Database Before performing any operations, we need to select the database we want to work with. USE company ; 👉 This tells MySQL to use the company database for all upcoming operations. 👉 Output: Database changed 🔹 Create Table A table stores data in rows and columns. CREATE TABLE emp ( empno CHAR ( 4 ), ename VARCHAR ( 25 ), sal FLOAT , city VARCHAR ( 15 ), dob DATE ); 👉 This creates a table emp with employee details 👉 Output: Query OK, 0 rows affected 🔹 Show Tables This command is used to check all tables in the current database. SHOW TABLES ; 👉 This displays all tables inside the selected database. 👉 Output: + ----------------+ | Tables_i