1. String Functions a) CONCAT() Joins two or more strings together.
|
1 2 |
SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees; |
b) LENGTH() Returns the length of a string in bytes.
|
1 2 |
SELECT LENGTH(first_name) AS name_length FROM employees; |
c) UPPER() / LOWER() Converts string to uppercase or...
MySQL Functions MySQL provides a wide range of built-in functions that allow you to perform operations on data directly in SQL queries.Functions are categorized into String, Numeric, Date/Time, Aggregate, and Control Flow functions. 🔹...
MySQL Data Types In MySQL, data types define the kind of data a column can store. Choosing the correct data type is crucial for data integrity, storage efficiency, and query performance. MySQL data types...
MySQL Views A View in MySQL is a virtual table based on the result of a SELECT query.Views do not store data physically but provide a way to simplify complex queries, improve security, and...
MySQL Working with Dates MySQL provides a variety of date and time data types and functions to store, manipulate, and retrieve date and time values efficiently. Dates are often used for recording timestamps, calculating...
MySQL AUTO_INCREMENT Field The AUTO_INCREMENT attribute in MySQL is used to automatically generate a unique number for a column whenever a new row is inserted.It is commonly used for primary key columns to uniquely...
MySQL CREATE INDEX Statement The CREATE INDEX statement in MySQL is used to create an index on one or more columns of a table to speed up data retrieval.Indexes improve query performance, especially for...
MySQL DEFAULT Constraint The DEFAULT constraint in MySQL is used to assign a default value to a column when no value is provided during an INSERT operation.It ensures that columns always have meaningful values,...
MySQL CHECK Constraint The CHECK constraint in MySQL is used to ensure that the values in a column meet a specific condition.It is a way to enforce data integrity rules at the column or...
MySQL FOREIGN KEY Constraint The FOREIGN KEY constraint in MySQL is used to link two tables and enforce referential integrity.A foreign key in one table references the primary key (or a unique key) in...
