MySQL Tutorial Information Functions 26 codes

  1. Home
  2. MySQL Tutorial
  3. Information Functions
1 BENCHMARK(count,expr) executes the expression expr repeatedly count times
2 CHARSET(str)
3 Check MySQL version in function
4 COERCIBILITY(str) returns the collation coercibility value of the string argument
5 COLLATION(str) returns the collation of the string argument
6 CONNECTION_ID() returns the connection ID (thread ID) for the connection
7 CURRENT_USER() returns the username and hostname This account determines your access privileges
8 DATABASE() returns the default (current) database name
9 FOUND_ROWS()
10 In the absence of the SQL_CALC_FOUND_ROWS option, FOUND_ROWS() returns the number of rows in the result set
11 Information Functions
12 LAST_INSERT_ID() returns the first automatically generated value set for an AUTO_INCREMENT column
13 LAST_INSERT_ID(expr)
14 ROW_COUNT() returns the number of rows updated, inserted, or deleted by the preceding statement
15 Save returning value from FOUND_ROWS() to a variable
16 SCHEMA() is a synonym for DATABASE()
17 SELECT CHARSET(CONVERT(abc USING utf8))
18 SELECT CHARSET(USER())
19 SELECT COERCIBILITY(abc)
20 SELECT COERCIBILITY(USER())
21 SELECT COLLATION(_utf8abc)
22 SESSION_USER() is a synonym for USER()
23 SYSTEM_USER() is a synonym for USER()
24 To extract only the username part
25 USER() returns the current MySQL username and hostname
26 VERSION() returns a string that indicates the MySQL server version