Programming FlashCards - Learn Coding Concepts

Date Comparison

In MySQL, you can compare date values using comparison operators. This allows you to filter records based on date criteria, such as finding records created after a certain date.

MySQL

Date Functions

MySQL provides various functions to manipulate date and time values. Functions like CURDATE(), NOW(), and DATE_ADD() allow you to retrieve and modify date values easily.

MySQL

TEXT Type

The TEXT type in MySQL is used to store long strings of text. Unlike VARCHAR, it can hold up to 65,535 characters but does not require a length specification. It's suitable for storing larger text data like articles or descriptions.

MySQL

VARCHAR Type

The VARCHAR type in MySQL is used to store variable-length strings. It is efficient for storing text data where the length can vary significantly, allowing for the saving of storage space.

MySQL

External Code Exec

Learn how to execute external scripts with MySQL using the `sys_exec` function. This allows for integration of MySQL with system commands, enhancing database functionality through external processing.

MySQL

Stored Procedures

Stored procedures in MySQL allow you to execute a set of SQL statements as a single unit. They can accept parameters and can be used to encapsulate complex logic, making it easier to manage and reuse code.

MySQL

MySQL INSERT IGNORE

Prevent duplicate key errors during insertion by silently skipping rows that would cause unique constraint violations.

MySQL

MySQL Bulk Insert

Efficiently insert multiple rows into a MySQL table using a single INSERT statement, reducing database overhead and improving performance.

MySQL

MySQL Export Command

Use mysqldump to export entire database or specific tables to a SQL file for backup or migration purposes

MySQL

MySQL Data Export

Export table data to a CSV file using SELECT ... INTO OUTFILE, allowing flexible file output with custom delimiters and line terminators.

MySQL

MySQL CTE Basics

Common Table Expressions (CTEs) allow you to create named temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, DELETE, or MERGE statement.

MySQL

MySQL Common Table Expressions

CTEs provide a way to write auxiliary statements for complex queries, improving readability and allowing recursive queries with a WITH clause.

MySQL

MySQL Common Table Expression

A CTE provides a way to write auxiliary statements for complex queries, improving readability and allowing recursive queries with a WITH clause.

MySQL

MySQL Temporary Tables

Temporary tables in MySQL are session-specific tables that exist only for the duration of a session and are automatically dropped when the session ends.

MySQL

MySQL Indexing

Learn how database indexes improve query performance by creating a data structure that allows faster data retrieval without scanning entire tables.

MySQL

MySQL Indexes

Indexes improve query performance by creating a data structure that allows faster data retrieval, reducing the need to scan entire tables for specific records.

MySQL

MySQL JOIN Types

Understand different types of JOIN operations in MySQL to combine rows from two or more tables based on a related column between them.

MySQL

MySQL Prepared Statements

Prepared statements help prevent SQL injection and improve performance by precompiling SQL queries with parameter placeholders.

MySQL

MySQL Subquery

A subquery is a nested query within another SQL query, allowing complex data retrieval by using the result of an inner query as a condition for the outer query.

MySQL

MySQL Window Functions

Learn how to use window functions to perform calculations across a set of table rows that are related to the current row

Previous Page 1 of 1 Next

Filter by Technology

Date Comparison

Date Functions

TEXT Type

VARCHAR Type

External Code Exec

Stored Procedures

MySQL INSERT IGNORE

MySQL Bulk Insert

MySQL Export Command

MySQL Data Export

MySQL CTE Basics

MySQL Common Table Expressions

MySQL Common Table Expression

MySQL Temporary Tables

MySQL Indexing

MySQL Indexes

MySQL JOIN Types

MySQL Prepared Statements

MySQL Subquery

MySQL Window Functions