MySQL是一種廣泛使用的關系型數據庫管理系統。在MySQL中,課程名通常使用英文表示。以下是MySQL中課程名的英文列表:
ADDDATE() -- add a date ADDTIME() -- add a time CONVERT_TZ() -- convert from one time zone to another CURDATE() -- return the current date CURRENT_DATE(), CURRENT_DATE -- return the current date CURRENT_TIME(), CURRENT_TIME -- return the current time CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP -- return the current date and time CURTIME() -- return the current time DATE() -- extract the date part of a date or datetime expression DATE_ADD() -- add time values (intervals) to a date value DATE_FORMAT() -- format a date or datetime value DATE_SUB() -- subtract a time value (interval) from a date DATEDIFF() -- calculate the difference between two dates DAY() -- extract the day of the month from a date DAYNAME() -- return the name of the weekday (Monday, Tuesday, etc.) given a date DAYOFMONTH() -- return the day of the month for a given date DAYOFWEEK() -- return the weekday index of the argument DAYOFYEAR() -- return the day of the year for a given date EXTRACT() -- extract a part of a date or time FROM_DAYS() -- convert a day number to a date FROM_UNIXTIME() -- convert a Unix timestamp to a date HOUR() -- extract the hour LAST_DAY() -- return the last day of the month for the argument LOCALTIME(), LOCALTIME -- Synonym for NOW() LOCALTIMESTAMP, LOCALTIMESTAMP() -- Synonym for NOW() MAKEDATE() -- create a date from the year and day of year MAKETIME() -- create a time from the hour, minute, second arguments MICROSECOND() -- return the microseconds from a date or time MINUTE() -- extract the minutes from a date MONTH() -- extract the month from a date MONTHNAME() -- return the name of the month for a given date NOW() -- return the current date and time PERIOD_ADD() -- add a period to a year-month value. PERIOD_DIFF() -- return the difference between two periods QUARTER() -- return the quarter of the year for a date argument SECOND() -- extract the seconds SEC_TO_TIME() -- convert seconds to 'HH:MM:SS' format STR_TO_DATE() -- convert a string to a date SUBDATE() -- equal to DATE_SUB() SUBTIME() -- subtract times (time subtraction) SYSDATE() -- return the time at which the function executes TIME() -- extract the time portion of a date or time TIMEDIFF() -- subtract time TIMESTAMP() -- With a single argument, this function returns the date or datetime expression; with two arguments, the sum of the arguments. TO_DAYS() -- convert a date to a day number UNIX_TIMESTAMP() -- return a Unix timestamp UTC_DATE() -- return the current UTC date UTC_TIME() -- return the current UTC time UTC_TIMESTAMP() -- return the current UTC date and time WEEK() -- return the week number WEEKDAY() -- return the weekday index of the argument WEEKOFYEAR() -- return the calendar week of the date (1-53) YEAR() -- extract the year YEARWEEK() -- return the year and week
下一篇電路圖動畫效果css3