Common MySql commands and basic mysql commands
Common MySQL database commands
1. MySQL Common commands
Create database name; create a database
Use databasename; select database
Drop database name directly deletes the database, no reminder
Show tables; displays tables
Descri
Basic but practical: Summary of common LNMP commands and common lnmp commands
1. modify directory permissions[Root @ localhost ~] # Chmod 777/home/user Note: only set the permission of the/home/user directory to rwxrwxrwx.[Root @ localhost ~] # Chmod-R 777/home/user Note: Set the permissions of the entire/home/user directory and its files and subdirectories to rw
redirectionStandard input: Code 0, using Standard output: Code 1, using > or >>Standard error Output: Code 2, using 2> or 2>>1>: Output the correct data to the specified file or device in an overriding way1>>: Output the correct data to the specified file or device in an additive way2>: outputting the wrong data to the specified file or device in an overridden manner2>>: The incorrect data is output to the specified file or device in an additive way4. The judgment basis of the command execution
Mysql build and basic commands, mysql build commands
I. mysql setup process
Install mysql on ubuntu
1. sudo apt-get install mysql-server
2. sudo apt-get install mysql-client
3. sudo apt-get install libmysqlclient-dev
2. Basic commands-Logon, logout, addition of databases,
1. Format description"[email protected] Simon" $"[Email protected] ~" $Both of these methods represent the same. Simon is the specified user, localhost is the computer name, if not set to localhost by default. Simon, ~ refers to the directory where you are currently located.Terminal: Command interpreter, simulation shell2, the user's switchsu[options] [user]such as: Su-rootThe example uses the SU command to change a normal user to the root user and use the option "-" to carry the root environmen
Basic Linux commands and Linux commands
Compression and decompression commands
Compression: tar-zcvf appName.tar.gz. date appFileName (for example, tar-zcvf rc.tar.gz. 0513 rc)
Decompress: tar-xvf tarFile
Tar command details:
Tar package compression;-c archive file,-x compressed file,-z gzip co
I. Linux basic management commands and Linux management commands
1. Shutdown and restart command
(1) shutdown command: shutdown [Option] Time
Option:-c. Cancel the previous shutdown command.
-H Shutdown
-R restart
Example: shutdown-h now # shut down immediately, root User
+ 10 # shutdown in 10 minutes
# Define the absolute restart time
(2) Other shutdown
Linux entry (1)-Basic commands and linux entry commands
This series of Linux beginners are the basic content I have summarized on the basis of "laruence's Linux private house dish", mainly to record my learning process, but also to facilitate your brief understanding.
Linux Distribution is Ubuntu rather than CentOS rec
MySQL database basic commands (favorites), mysql commands
I sorted out the basic mysql commands and shared them.
# Start, stop, and restart MySql service mysql start | stop | restart/etc/init. d/mysql restart | start | restart # connect to MySQL database mysql-h127.0.0.1-u
Linux basic commands (2) commands on disk space, linux disk spaceDisk Space commands
Command
Function
Mount
Mount a File System
Umount
Detach a mounted file system
Df
Check the disk space of each hard disk partition and mounted file system
Du
Show file directo
Improve readability of information in kilobytes, MB, GB
-S
Only the sum of each file size is listed
-X
Only compute files that belong to the same file system
2.5 fsck CommandThe function of the fsck command is to check and repair the Linux file system, which is best used when no one or no partition hangs up, in fact, each boot system will do a check to see if there is a bad track or data loss phenomenon. Usage:fsck (-option) partition name
, which is a very dangerous option
-V
Verbose: Show the progress of a file's movement
MV T.txt document moves the file T.txt to the directory document.1.9 RM CommandThe RM command is used to delete files.
Options
Description
-I.
Interactive: Prompt to confirm deletion
-F
Force: Replace interactive mode without prompting to confirm deletion
-V
Verbose: Show file deletion progress
Android Sqlite basic commands and androidsqlite commands
To view the database, you must first find the db file. If you copy the file to a computer, you can view it in many ways. on your mobile phone, you can use commands to view it directly and conveniently.
First, you need to find the database location. Generally, t
Summary of basic MySQL commands and common commands bitsCN.com
Start: net start mysql;Enter: mysql-u root-p/mysql-h localhost-u root-p databaseName;List databases: show databases;Select database: use databaseName;List tables: show tables;Show columns from tableName;Create a database: source fileName.txt;Matching character: Wildcard _ can be used to represent any
Five steps to master the basic development and usage commands of Git, and five steps to master git commandsStep 1: set global variables:
git config --global user.name "gang.li"git config --global user.email "ligang@ptthink.com"Step 2: Initialize the repository and push it to the remote repository (if this step is performed for the first push, otherwise skip this step ):
/* Create a project folder and initia
Summary of common linux commands and parameters (basic) and common linux commands
1. user's home directory (~) In linux, users all have their own home directories. you can place your own configuration files and other things. pwd: list the current directory. optional parameter-P: when the current directory is a link directory, the real path is displayed. ls: List
Linux basic commands and linux commandsLs command
Pwd: display the current directory touch 11.txt: Create a txt file named 11 mkdir laowang under the current directory: Create a folder named laowang ls-a-l-h in the current directory: it is equivalent to ls-alh.-a is used to display all files in the current directory, including hidden files.-l is displayed as a list, -h is the size of the displayed file auto
(source) target (destination)[email protected] ~]# CP [options] Source1 source2 source3 .... directory
Parameters used with the CP:
-A: As-pdr means, please refer to the following instructions for PDR. (common)-D: If the source file is the attribute of the link file, the link file property is copied instead of the file itself;-I: If the target file (destination) already exists, the action will be asked (commonly used) when overwriting-P: Copy the past along with the properties of
Ipcclean removes internal and isolated signal sharing signs from the stopped PostgreSQL Server
Pg_ctl start, stop, and restart the postgresql service (for example, pg_ctl start starts the postgresql service, which is the same as service PostgreSQL start)
Pg_controldata displays the internal control information of the postgresql service
Postgres PostgreSQL single-user database service
Postmaster PostgreSQL multi-user database service
4. Psql is the most important client program. To e
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.