MySQL Command 常见命令

 

 

/* Load data from txt file */
LOAD DATA LOCAL INFILE "D:/data.txt" INTO TABLE tname;


/* Load .sql command file */
SOURCE D:/mysql.sql;


/* Change passowrd */
UPDATE mysql.user SET password = PASSWORD('123456') WHERE User = 'root';


/* Show current database */
SELECT DATABASE();


/* Show current user */
SELECT USER();


/* Create the database */
CREATE DATABASE dbname;


/* Choose the database */
USE dbname;


/* Delete the database */
DROP dbname;


/* Show the tables */
SHOW TABLES;


/* Describe the table */
DESCRIBE tname;


/* Create the table */
CREATE TABLE tname (id INT, name VARCHAR(30));


/* Delete the table */
DROP TABLE tname;


/* Delete the date in table */
TRUNCATE TABLE tname;


/* Insert the table */
INSERT INTO tname VALUES (1, 'hello');


/* Search the table */
SELECT id, name FROM tname WHERE id = 1 ORDER BY DESC;


/* Update the table */
UPDATE tname SET name = 'world' WHERE id = 1;


/* Display the table */
SELECT * FROM tname;

 

More Information Check:

http://blog.csdn.net/ithomer/article/details/5131863

 

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值