MySQL: Question and Answer
We've added this category to include some of our general MySQL questions from viewers.
Advertisements
MySQL Basics
MySQL Advanced
- Alter Table
- AUTO_INCREMENT
- Change Password
- Comments in SQL
- Create Table
- Create Table As
- Create User
- Data Types
- Declare Variables
- Drop Table
- Drop User
- Find Users
- Find Users Logged In
- Functions
- Grant/Revoke Privileges
- Indexes
- Literals
- Primary Key
- Procedures
- Rename User
- Show Grants
- Unique Constraints
- Views
MySQL Triggers
String Functions
Numeric/Math Functions
Date/Time Functions
- ADDDATE
- ADDTIME
- CURDATE
- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURTIME
- DATE
- DATE_ADD
- DATE_FORMAT
- DATE_SUB
- DATEDIFF
- DAY
- DAYNAME
- DAYOFMONTH
- DAYOFWEEK
- DAYOFYEAR
- EXTRACT
- FROM_DAYS
- HOUR
- LAST_DAY
- LOCALTIME
- LOCALTIMESTAMP
- MAKEDATE
- MAKETIME
- MICROSECOND
- MINUTE
- MONTH
- MONTHNAME
- NOW
- PERIOD_ADD
- PERIOD_DIFF
- QUARTER
- SEC_TO_TIME
- SECOND
- STR_TO_DATE
- SUBDATE
- SUBTIME
- SYSDATE
- TIME
- TIME_FORMAT
- TIME_TO_SEC
- TIMEDIFF
- TIMESTAMP
- TO_DAYS
- WEEK
- WEEKDAY
- WEEKOFYEAR
- YEAR
- YEARWEEK
Advanced Functions