mysql commands cheat sheet

Compiled from: http://www.tecmint.com/cheat-command-line-cheat-sheet-for-linux-users/ Avishek KumarOriginal: LCTT https://linux.cn/article-3760-1.html Translator: Su-kaiyaoA slight change in the originalWhat do you do when you're not sure what commands you're running, especially complex

cheat--gives Linux beginners and administrators an ultimate command line "cheat sheet"What do you do when you're not sure what commands you're running, especially complex commands that use a lot of options? In this case, we use the man pages to get help. There are other opti

Transferred from: http://blog.bingo929.com/cheat-sheets-for-web-develop.htmlCheat sheet This phrase if literal translation into Chinese, meaning is probably "cheat small copy" such as words, but Cheat sheet the actual meaning of the word is not a derogatory, although the Chi

IOS Application Security testing Cheat Sheet[Hide] 1 DRAFT CHEAT sheet-work in PROGRESS 2 Introduction 3 information gathering 4 Application Traffic analysis 5 Runtime Analysis 6 Insecure Data storage 7 Tools 8 related articles 9 Authors and Primary Editors Ten other cheatsheets DRAFT

Http://files.cnblogs.com/lbsx/git-cheat-sheet-large.png.zip One: Overview There are countless books on the web for Git and cheatsheet. But its editorial thinking is to explain the order. Always wanted this article cheatsheet: in daily use of git, I will encounter which uses case, what is the priority of these usage case, what should be used git command. For this idea, edit this article. The goal of this ar

First, Introduction Cheat is an interactive cheat sheet application that is distributed to Linux command line users under the GNU General Public License. It provides a display of Linux command use cases, including all of the options and short but understandable features of the command. Second, installation configuration The installation steps are as follows: Yum

Label:id=164 the MySQL database error is a very common problem due to a power outage or an abnormal shutdown. There are two ways to use MySQL's check table and Repair table SQL statement, and the other is to use the multiple myisamchk provided by MySQL to isamchk the data detection recovery tool. The former is relatively simple to use. Recommended use.1. Check table and Repair tableLog in to

Tag:ext include about window assign NBSP;NBSP;NBSP;ABC Data Sheet group common Common MySQL command Daquan One, the connection MySQL format: mysql-h host address-u user name-p user Password 1, example 1: Connect to the local MySQL. First open the DOS window, and then en

Tags: row modify values flush INF local date not text intoCommon commands 1. Displays the list of databases in the current database server: MySQL> SHOW DATABASES; 2. Establish the database: MySQL>CREATEdatabase name; 3. Set up the data sheet: MySQL> use library name;

] identified by ' 1234 ';Mysql>flush privileges; Refresh System Permissions Table2.5 Authorization test The user has some permissions for all databases:Mysql>grant Select,delete,update,create,drop on * * To test@ "%" identified by "1234";The test user has Select,delete,update,create,drop permissions on all databases.@ "%" indicates authorization for all non-local hosts, excluding localhost. (The localhost address is set to 127.0.0.1, if set to the rea

key Automatically add Default value Id Int 4 Whether Primary key Auto_increment Name Char 20 Whether Sex Int 4 Whether 0 Degree Double 16 Is Mysql> Create table MyClass (> ID int (4) NOT NULL primary key auto_increment,> Name char () NOT NULL,

Tags: other blob bit weekday base date and time type cannot be formattedMysql Notes I. BASIC DATABASE operations 1.mysql-h Localhost-u Root-p 2. At the end of each input, the wrong input \c cancel this input and start the new input. 3.auto_increment starts from 1 by default. 4. View all databases. show databases; 5. Use a database. Use dbname; 6. View the current database to say that there is a table. SHOW TABLES; Two. Basic operation of the data

Summary of common MySql commands User Logon: mysql-u username-p Password Add User: insert into mysql. user (host, user, password, select_priv ,...) value ('server name', 'username', 'Password', 'authorization ',...); Manage databases: Show database; Create database; Delete: drop database T Open Database use T Manage da

();1. Delete the students data sheet from the Student_course database:rm-f student_course/students.*2. Back up the database: (Backup database Test)mysqldump-u root-p test>c:\test.txtBackup table: (Back up the MyTable table under test database)mysqldump-u root-p Test mytable>c:\test.txtImport the backup data into the database: (Back to test database)mysql-u root-p Test3. Create temporary table: (Create temp

(); 1. Delete the students data sheet from the Student_course database:Rm-f student_course/students.* 2. Back up the database: (Backup DATABASE Test)Mysqldump-u root-p Test>c:\test.txtBackup table: (Back up the MyTable table under test database)Mysqldump-u root-p Test Mytable>c:\test.txtImport the backup data into the database: (Back to test database)Mysql-u root-p Test 3. Create temporary table: (Creat

two table primary table Tbl_order child table tbl_orderdetail the current child table Tbl_orderdetail refers to the OID column of the main table Tbl_order, the command is as follows: ALTER TABLE Tbl_orderdetail add constraint fk_oid foreign key (OID) references Tbl_order (OID); Query time: Select Now (); Query Current User: Select User (); Querying database version: Select version (); Query the database currently in use: select databases (); Third, Operation instructions 1. Delete the students