https://codingchoice.com/learn/ 2026-05-03T10:42:27+00:00 https://codingchoice.com/learn/ https://codingchoice.com/learn/_media/logo.png text/html 2025-02-13T03:03:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://codingchoice.com/learn/mysql/advanced_sql_queries?rev=1739415811&do=diff Advanced SQL Queries Filtering Data with WHERE SELECT * FROM users WHERE email = 'john@example.com'; Filters records based on the given condition. Using Logical Operators SELECT * FROM users WHERE email = 'john@example.com' AND name = 'John Doe'; text/html 2025-02-13T03:10:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://codingchoice.com/learn/mysql/backups_and_restorations?rev=1739416246&do=diff Backups and Restorations Backing Up a Database mysqldump -u root -p my_database > backup.sql This command creates a backup of my_database. Restoring a Database mysql -u root -p my_database < backup.sql Restores the database from backup.sql. text/html 2025-02-13T03:05:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://codingchoice.com/learn/mysql/indexing_and_optimization?rev=1739415937&do=diff Indexing and Optimization Creating Indexes CREATE INDEX idx_email ON users(email); Improves search performance on the email column. Optimizing Queries * Use indexes on frequently searched columns. * Avoid using SELECT *; specify required columns. text/html 2025-02-13T02:50:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://codingchoice.com/learn/mysql/introduction?rev=1739415025&do=diff Introduction to MySQL What is MySQL? MySQL is an open-source relational database management system (RDBMS) that enables users to store, manage, and retrieve data efficiently. It is widely used for web applications and is a core component of the LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. MySQL supports structured query language (SQL) for managing relational databases, providing powerful and flexible database management solutions. text/html 2025-02-13T02:53:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://codingchoice.com/learn/mysql/mysql_basics?rev=1739415235&do=diff MySQL Basics Connecting to MySQL To connect to MySQL, use the following command: mysql -u username -p Enter the password when prompted. Creating a Database CREATE DATABASE my_database; This command creates a new database named my_database. text/html 2025-02-13T03:09:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://codingchoice.com/learn/mysql/mysql_security?rev=1739416173&do=diff MySQL Security Creating a New User CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; Creates a new MySQL user. Granting Permissions GRANT ALL PRIVILEGES ON my_database.* TO 'newuser'@'localhost'; FLUSH PRIVILEGES; Grants full privileges on my_database to newuser. text/html 2025-02-13T03:12:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://codingchoice.com/learn/mysql/sidebar?rev=1739416370&do=diff * Introduction * MySQL Basics * Advanced SQL Queries * Indexing and Optimization * Stored Procedures and Triggers * MySQL Security * Backups and Restorations * Transactions and Concurrency text/html 2025-02-13T03:07:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://codingchoice.com/learn/mysql/stored_procedures_and_triggers?rev=1739416043&do=diff Stored Procedures and Triggers Creating a Stored Procedure DELIMITER // CREATE PROCEDURE GetUser(IN userId INT) BEGIN SELECT * FROM users WHERE id = userId; END // DELIMITER ; This procedure retrieves user details based on userId. Creating a Trigger text/html 2025-02-13T03:12:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://codingchoice.com/learn/mysql/transactions_and_concurrency?rev=1739416331&do=diff Transactions and Concurrency Control Using Transactions START TRANSACTION; UPDATE accounts SET balance = balance - 100 WHERE id = 1; UPDATE accounts SET balance = balance + 100 WHERE id = 2; COMMIT; Ensures atomicity of multiple related updates.