db2 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

; --nullSELECT * from Studentinfo where stuage is null;SELECT * from Studentinfo where stuage are NOT null; --between and includes boundaries equivalent to >= and Select S.stuname as name, s.stuage+5 as age from Studentinfo s where s.stuage between and 20 --inSELECT * from Studentinfo where stuname in (' XY ', ' WJ ');SELECT * from Studentinfo where stuname not in (' xy ', ' WJ '); --Fuzzy query like%,% represents multiple charactersSELECT * from Studentinfo where stuname like ' X-percent ' --

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

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

=" 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

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

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

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,

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