Advanced MySQL Commands with Examples Advanced MySQL Commands with Examples 1. DISTINCT Clause To remove duplicate rows based on a column, you can use the DISTINCT keyword: SELECT DISTINCT age FROM students; 2. BETWEEN Operator To filter rows within a certain range, you can use the BETWEEN operator: SELECT * FROM students WHERE age BETWEEN …
Creating and Inserting Data into a MySQL Table Creating a MySQL Table Before inserting data, you’ll need to create a table to hold it. Here’s how to create a table named students. SQL Query for Creating a Table: CREATE TABLE students (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50), age INT, email VARCHAR(50)); Inserting …
MySQL Data Types with Examples Numeric Data Types Numeric Data TypesIn MySQL, numeric data types are used to store numeric values. They can be categorized into exact numeric types, like INTEGER, and approximate numeric types, like FLOAT. Data Type Description Example INT A normal-size integer that can be signed or unsigned. INT(11) FLOAT A floating-point …
Basic MySQL Commands with Examples Basic MySQL Commands with Examples 1. Connecting to a Database To connect to a MySQL database, use the following command: mysql -u username -p 2. Show Databases To show the list of all available databases: SHOW DATABASES; 3. Use a Database To use a specific database: USE database_name; 4. Create …
