- Home
- All Courses
- IT & Software
- Server Side
- Learn MySQL
Learn MySQL
Quality education for everyone, everywhere at Your pace online
- 0 (Registered)
-
(0 Reviews)
Curriculum
- 10 Sections
- 193 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Introduction to MySQLMySQL is a widely used relational database management system (RDBMS). MySQL is free and open-source. MySQL is ideal for both small and large applications.2
- MySQL SQLSQL is the standard language for dealing with Relational Databases. SQL is used to insert, search, update, and delete database records.33
- 1.1MySQL SQL
- 1.2MySQL SELECT Statement
- 1.3MySQL WHERE Clause
- 1.4MySQL AND, OR and NOT Operators
- 1.5MySQL ORDER BY Keyword
- 1.6MySQL INSERT INTO Statement
- 1.7MySQL NULL Values
- 1.8MySQL UPDATE Statement
- 1.9MySQL DELETE Statement
- 1.10MySQL LIMIT Clause
- 1.11MySQL MIN() and MAX() Functions
- 1.12MySQL COUNT(), AVG() and SUM() Functions
- 1.13MySQL LIKE Operator
- 1.14MySQL Wildcards
- 1.15MySQL IN Operator
- 1.16MySQL BETWEEN Operator
- 1.17MySQL Aliases
- 1.18MySQL Joins
- 1.19MySQL INNER JOIN Keyword
- 1.20MySQL LEFT JOIN Keyword
- 1.21MySQL RIGHT JOIN Keyword
- 1.22MySQL CROSS JOIN Keyword
- 1.23MySQL Self Join
- 1.24MySQL UNION Operator
- 1.25MySQL GROUP BY Statement
- 1.26MySQL HAVING Clause
- 1.27MySQL EXISTS Operator
- 1.28MySQL ANY and ALL Operators
- 1.29MySQL INSERT INTO SELECT Statement
- 1.30MySQL CASE Statement
- 1.31MySQL NULL Functions
- 1.32MySQL Comments
- 1.33MySQL Operators
- MySQL DatabaseThe MySQL CREATE DATABASE Statement The CREATE DATABASE statement is used to create a new SQL database. Syntax CREATE DATABASE databasename;15
- 1.1MySQL CREATE DATABASE Statement
- 1.2MySQL DROP DATABASE Statement
- 1.3MySQL CREATE TABLE Statement
- 1.4MySQL DROP TABLE Statement
- 1.5MySQL ALTER TABLE Statement
- 1.6MySQL Constraints
- 1.7MySQL NOT NULL Constraint
- 1.8MySQL UNIQUE Constraint
- 1.9MySQL PRIMARY KEY Constraint
- 1.10MySQL FOREIGN KEY Constraint
- 1.11MySQL CHECK Constraint
- 1.12MySQL DEFAULT Constraint
- 1.13MySQL CREATE INDEX Statement
- 1.14MySQL AUTO INCREMENT Field
- 1.15MySQL Working With Dates
- MySQL ViewsMySQL Views1
- MySQL ReferencesMySQL References2
- MySQL Functions - String FunctionsMySQL has many built-in functions. This reference contains string, numeric, date, and some advanced functions in MySQ33
- 1.1MySQL ASCII() Function
- 1.2MySQL CHAR_LENGTH() Function
- 1.3MySQL CHARACTER_LENGTH() Function
- 1.4MySQL CONCAT() Function
- 1.5MySQL CONCAT_WS() Function
- 1.6MySQL FIELD() Function
- 1.7MySQL FIND_IN_SET() Function
- 1.8MySQL FORMAT() Function
- 1.9MySQL INSERT() Function
- 1.10MySQL INSTR() Function
- 1.11MySQL LCASE() Function
- 1.12MySQL LEFT() Function
- 1.13MySQL LENGTH() Function
- 1.14MySQL LOCATE() Function
- 1.15MySQL LOWER() Function
- 1.16MySQL LPAD() Function
- 1.17MySQL LTRIM() Function
- 1.18MySQL MID() Function
- 1.19MySQL POSITION() Function
- 1.20MySQL REPEAT() Function
- 1.21MySQL REPLACE() Function
- 1.22MySQL REVERSE() Function
- 1.23MySQL RIGHT() Function
- 1.24MySQL RPAD() Function
- 1.25MySQL RTRIM() Function
- 1.26MySQL SPACE() Function
- 1.27MySQL STRCMP() Function
- 1.28MySQL SUBSTR() Function
- 1.29MySQL SUBSTRING() Function
- 1.30MySQL SUBSTRING_INDEX() Function
- 1.31MySQL TRIM() Function
- 1.32MySQL UCASE() Function
- 1.33MySQL UPPER() Function
- MySQL Functions - Numeric FunctionsNumeric Functions36
- 1.1MySQL ABS() Function
- 1.2MySQL ACOS() Function
- 1.3MySQL ASIN() Function
- 1.4MySQL ATAN() Function
- 1.5MySQL ATAN2() Function
- 1.6MySQL AVG() Function
- 1.7MySQL CEIL() Function
- 1.8MySQL CEILING() Function
- 1.9MySQL COS() Function
- 1.10MySQL COT() Function
- 1.11MySQL COUNT() Function
- 1.12MySQL DEGREES() Function
- 1.13MySQL DIV Function
- 1.14MySQL EXP() Function
- 1.15MySQL FLOOR() Function
- 1.16MySQL GREATEST() Function
- 1.17MySQL LEAST() Function
- 1.18MySQL LN() Function
- 1.19MySQL LOG() Function
- 1.20MySQL LOG10() Function
- 1.21MySQL LOG2() Function
- 1.22MySQL MAX() Function
- 1.23MySQL MIN() Function
- 1.24MySQL MOD() Function
- 1.25MySQL PI() Function
- 1.26MySQL POW() Function
- 1.27MySQL POWER() Function
- 1.28MySQL RADIANS() Function
- 1.29MySQL RAND() Function
- 1.30MySQL ROUND() Function
- 1.31MySQL SIGN() Function
- 1.32MySQL SIN() Function
- 1.33MySQL SQRT() Function
- 1.34MySQL SUM() Function
- 1.35MySQL TAN() Function
- 1.36MySQL TRUNCATE() Function
- MySQL Functions - Date Functions50
- 1.1MySQL ADDDATE() Function
- 1.2MySQL ADDTIME() Function
- 1.3MySQL CURDATE() Function
- 1.4MySQL CURRENT_DATE() Function
- 1.5MySQL CURRENT_TIME() Function
- 1.6MySQL CURRENT_TIMESTAMP() Function
- 1.7MySQL CURTIME() Function
- 1.8MySQL DATE() Function
- 1.9MySQL DATEDIFF() Function
- 1.10MySQL DATE_ADD() Function
- 1.11MySQL DATE_FORMAT() Function
- 1.12MySQL DATE_SUB() Function
- 1.13MySQL DAY() Function
- 1.14MySQL DAYNAME() Function
- 1.15MySQL DAYOFMONTH() Function
- 1.16MySQL DAYOFWEEK() Function
- 1.17MySQL DAYOFYEAR() Function
- 1.18MySQL EXTRACT() Function
- 1.19MySQL FROM_DAYS() Function
- 1.20MySQL HOUR() Function
- 1.21MySQL LAST_DAY() Function
- 1.22MySQL LOCALTIME() Function
- 1.23MySQL LOCALTIMESTAMP() Function
- 1.24MySQL MAKEDATE() Function
- 1.25MySQL MAKETIME() Function
- 1.26MySQL MICROSECOND() Function
- 1.27MySQL MINUTE() Function
- 1.28MySQL MONTH() Function
- 1.29MySQL MONTHNAME() Function
- 1.30MySQL NOW() Function
- 1.31MySQL PERIOD_ADD() Function
- 1.32MySQL PERIOD_DIFF() Function
- 1.33MySQL QUARTER() Function
- 1.34MySQL SECOND() Function
- 1.35MySQL SEC_TO_TIME() Function
- 1.36MySQL STR_TO_DATE() Function
- 1.37MySQL SUBDATE() Function
- 1.38MySQL SUBTIME() Function
- 1.39MySQL SYSDATE() Function
- 1.40MySQL TIME() Function
- 1.41MySQL TIME_FORMAT() Function
- 1.42MySQL TIME_TO_SEC() Function
- 1.43MySQL TIMEDIFF() Function
- 1.44MySQL TIMESTAMP() Function
- 1.45MySQL TO_DAYS() Function
- 1.46MySQL WEEK() Function
- 1.47MySQL WEEKDAY() Function
- 1.48MySQL WEEKOFYEAR() Function
- 1.49MySQL YEAR() Function
- 1.50MySQL YEARWEEK() Function
- MySQL Functions - Advanced Functions19
- 1.1MySQL BIN() Function
- 1.2MySQL BINARY Function
- 1.3MySQL CASE Function
- 1.4MySQL CAST() Function
- 1.5MySQL COALESCE() Function
- 1.6MySQL CONNECTION_ID() Function
- 1.7MySQL CONV() Function
- 1.8MySQL CONVERT() Function
- 1.9MySQL CURRENT_USER() Function
- 1.10MySQL DATABASE() Function
- 1.11MySQL IF() Function
- 1.12MySQL IFNULL() Function
- 1.13MySQL ISNULL() Function
- 1.14MySQL LAST_INSERT_ID() Function
- 1.15MySQL NULLIF() Function
- 1.16MySQL SESSION_USER() Function
- 1.17MySQL SYSTEM_USER() Function
- 1.18MySQL USER() Function
- 1.19MySQL VERSION() Function
- MySQL ExamplesMySQL Examples2
MySQL Examples
Prev