MySQL Command 常见命令

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;