The use of MySQL functions

SELECT left (name,1) from a;//intercepts the first character

Select POSITION ('. ') In name) The from a;//index is returned. In the position of the string

Select Left (name,position ('. ') In name), from a;//intercept the number on the left

SELECT now ();//Display time

Show table status where Name= ' a '//view table

Rename Table A to c;//change name

Truncate C; Clears the table, the primary key self-increment ID is initialized to 0

Show tables//Display table name

The use of MySQL functions