mysql--Basic Statement Operations

Select is used to query a table or execute a function, and show queries the statement that created the table or other resource | Connection Database mysql-uroot-p Password | Show database version select version (); View all databases show databases;| Create database Python_new_info Charset=utf8; | View the statement that created the database show create databases python_new_info; | View the database that is currently in use Select Database (); | Using database use Python_new_info; | Delete database drop db python_new_info; | View sorted list Data select * from tables/g

mysql--Basic Statement Operations