简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

Mysql常用命令行操作总结_MySQL

WBOY
Release： 2016-06-01 13:32:16
Original
1073 people have browsed it

bitsCN.com

Mysql常用命令行操作总结

 

1.导入某个sql文件到数据库：

用source命令，必须先登录到mysql控制台

mysql -u -p use xxxDatabase;source  /test.sql
Copy after login

2. 导出数据库表结构到sql文件

mysqldump -u root -p -d DBName >  dbName.sql
Copy after login

如果只想导出某个数据库表，则在数据库名字后面 加上表名字，多个以空格分开

3. 修改 Mysql 密码

mysqladmin -u 用户名 -p 旧密码 password 新密码
Copy after login

4. 连接Mysql 数据库

 mysql -h 主机地址 -u 用户名 -p  用户密码
Copy after login

5. 创建数据库，新建表，

  create database 库名;   create table 表名
Copy after login

6. 删除库，删除表 

drop database 库名;     drop table 表名
Copy after login

7. 表中记录清空

   delete from 表名;
Copy after login

 


bitsCN.com
Related labels：
mysql source console Database Table
source：php.cn
Previous article：mysql中DATETIME、DATE和TIMESTAMP的区别_MySQL Next article：Windows下RMySQL的安装和使用_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to list data in a section by ID using while loop in PHP? I have a mysql table with these columns: series_id, series_color, product_name In the outp...
From 2023-11-17 20:03:03
0
1
290
How to make table cell values ​​hyperlinked in Dash? (Using Plotly, Dash, Pandas, etc.) I want to set the cell value under the "JobLink" column as a hyperlink. When I c...
From 2023-11-17 18:47:10
0
1
283
Best way to preload route data before accessing the route. Before rendering the page for a given route, I want to first get the necessary data synchr...
From 2023-11-17 14:54:42
0
2
379
New title: New script does not correctly display strange character encoding of stored data I'm trying to rewrite an old website. It is in Persian and uses Persian/Arabic characters....
From 2023-11-17 10:51:01
0
2
273
Nuxt.js SSG (Static Site Generator) Get API Data When building a project using a static site generator, I understand that documentation cre...
From 2023-11-16 21:36:07
0
1
176
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！