gw basic commands

Basic MySQL commands and basic mysql commands SQL Statement Mysql version: For mysql-5.6.36 version1.1 Common commands # View database mysql> show databases; show databases like '% pres %'; # fuzzy query # View table mysql> use xzymysql> show tables; # view permissions show

Basic linux commands and basic linux commands Shutdown-h now shut down immediately Shutdown-r now restart the computer Reboot now restarts the computer Logout user logout Vi editor usage: 1) vi file name 2) Enter I to enter the command mode] 3) Enter esc to Enter command mode] 4) input: [wq indicates exit and keep q! E

Linux Security Basics: network configuration commands and linux basic configuration commands 1. ifconfig view and configure network interface information(1) set an IP addressIfconfig eth0 192.168.0.1(2) temporarily disable or enable the NICIfconfig eth0 downIfconfig eth0 up(3) set the subnet maskIfconfig eth0 netmask 255.255.255.0(4) view the status of the first

Table Space Basic Commands--Create TABLE space initialization size 10M auto grow 5M max 50MCreate tablespace Duan datafile ' F:\oracle\product\10.2.0\oradata\orcl\duan.dbf ' size 10MAutoextend on next 5M maxsize 50M;--Querying table space for address and space namesSelect File_name,tablespace_name from Dba_data_files order by file_name;--Create a multiple tablespace containing two data filesCreate tablespac

Tags: mysql basic command and use of the Mysqladmin commandMysql --user,-u --host,-H --password,-P --port --protocol --database Database,-DMySQL Batch processing mode[Email protected] ~]# Vim/test.sqlCreate DATABASE TestDB;CREATE TABLE testdb.tb1 (ID int,name CHAR (20))[[email protected] ~]# MySQLmysql> \. /test.sqlQuery OK, 1 row affected (0.09 sec)Query OK, 0 rows affected (0.29 sec)mysql> drop database TestDB; #删除Query OK, 1 row affected (0.25 sec)

JSP basic syntax, 3 Compilation commands, 7 Action commands, 9 built-in objectsI. jsp Overview JSPIs the abbreviation of java server page, which is essentially a simplified servlet and a dynamic web page technical standard. Jsp pages are embedded in java segments in HTML pages. applications developed using jsp can be used across platforms.Ii. jsp

Basic Search commands and information in Linux, and query commands in linux Searching for commands and hardware information is the most common operation for daily system management and maintenance. Next we will make a brief comparison of the Basic Search

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

=" Image025.png "alt=" Wkiom1l5qzqb2ck-aae02uch_4u103.png "/>(3)hash-d nameDeleteHashNow we will delete the cached pwd in the hash , and the name we need to enter when we delete It is the alias we found with hash-l . 650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/9D/14/wKioL1l5qzuBYp6QAAC5QHVv0zU321.png "style=" float : none; "title=" Image026.png "alt=" Wkiol1l5qzubyp6qaac5qhvv0zu321.png "/>you can see that the PWD is not in the list . then we look at the type of PWD and find that

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

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

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

-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/72/4C/ Wkiol1xglaet5wroaabthzfxcvg341.jpg "width=" 244 "height=" 111 "/> 2) Set time Timedatectl set-time 19:30:20 650) this.width=650; "title=" image "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" image "src=" h