Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to use mysql for you. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Commonly used commands:

1. Log in to mysql-uroot-p and enter the default password toor under / / bt5.

two。 Create a database create database dataname where dataname is the name of the database you want to create

3. Delete database / table drop database dataname/tablename

4. Show all database show databases note that there are s

5 use database use dataname

6 display tables need to use show tables on the basis of 5, that is, to display all tables under dataname

7 creating a table requires the use of create table tablename () on the basis of 5

/ / the parameters in it are not remembered

8 Export database mysqldmp-uroot-p dataname > pleace

9 Import database mysql-uroot-p dataname

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.