database with your name, and create a table student that contains three fields (Id,name,age)' Enter MySQL ' [[[emailprotected] ~]#/usr/local/mysql/bin/mysql-uroot-penter password:welcome to the MySQL monitor. Commands End With; or \g.your MySQL connection ID is 7Server version:5.7.22 mysql Community Server (GPL) Copyright (c) #, 2018, Oracle and /or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their r
You can view the following commands:
# Lsb_release-LSB version: core-3.1-ia32: core-3.1-noarch: graphics-3.1-ia32: graphics-3.1-noarchDistributor ID: centosDescription: centos release 5.4 (final)Release: 5.4Codename: Final
This command applies to all Linux releases, including RedHat, Suse, and Debian.
Root @ mymail ~ # UnameLinuxRoot @ mymail ~ # Uname-R2.6.18-164. EL5
The following two methods apply to
To create a test table:MariaDB [music]>CREATE TABLE summary (ID int,info char);Query OK, 0 rows affected (0.05 sec)MariaDB [music]>show tables;+-----------------+| Tables_in_music |+-----------------+| Summary || Test |+-----------------+2 rows in Set (0.00 sec)Insert test data:MariaDB [music]>INSERT INTO summary values (1, ' Eric Gao is a Oracle DBA ');Query OK, 1 row Affected (0.00
the INSERT permission. For each account, create user creates a new record in the Mysql.user table with no permissions. If the account already exists, an error occurs. Using the optional identified by clause, you can specify a password for the account. The user value and password are given the same method as the GRANT statement. In particular, to specify a password in plain text, you need to ignore the password keyword. To specify the password as a mixed value returned by the password () functio
Send e-mail demofont-size:15px; width:411px; " >e-mail address:CC to:Message Subject:Message content:To add an attachment:onclick= "Btn_sendemail_click"/>Back-End Code:protected void Btn_sendemail_click (object sender, EventArgs e){Declaring a Mail objectMailMessage mymail = new MailMessage ();Sender AddressAs yourself, enter your own mailbox hereMyMail. from = new MailAddress ("[email protected]");Recipient addressMyMail. To.add (New MailAddress (Tb_
application.5 Utility Class 5.1URLURLs and Urlbulider are the two classes in the system (note: not System.Net) namespace that are used to represent URIs. The UriBuilder class allows you to construct a URL by taking a given string as part of a URL.Uri url = new Uri ("http://www.ithome.com");5.2 IP address and DNS name. NET class Ipadress classes and iphostentry for IP addresses6 lower-level protocols
The underlying class for sockets is used to manage connections, WebRequest, TcpClient a
, tab, and vertical tab, equivalent to [\ f \ n \ r \ t \ v]
\ S any non-blank character, equivalent to [^ \ f \ n \ r \ t \ v]
. Any character other than line feed and carriage return is equivalent to [^ \ n \ r]
The same letter is case-insensitive.Hexadecimal and octal characters
It is also feasible to use hexadecimal or octal characters in regular expressions. The matching characters are the characters corresponding to the converted decimal value in ASCII.
Var reAt =/\ x40/; // The hexadec
Vim/VI Practical Skills
1. Import files
: R [file name] # import to the currently edited File
For example, R/etc/inittab
The upper part of the file is the/etc/services file, and the lower part is the/etc/inittab file.
2. Run the command [do not exit VI]
:! [Command]
:! Ls-L/home/hadoop
Extended-import the command execution result to the currently edited file!
: R! Date
3. Define shortcuts
: Map [shortcut key] [trigger command]
E.g.: Map ^ p I #
: Map ^ o 0x # Delete the first character o
Tags: United table query tar one inner ref l database name order by new# # MySQL Database# # # Knowledge Points:1. Single-table query2. Sub-query3. Linked Table Query4. BusinessBefore we make a query, we need to build the relational table and insert some data into the data table. Prepare for the query operation.##### Five creation of a relational table:"MySQL#创建并进入数据库:mysql> CREATE DATABASE ' info ';Query OK, 1 row Affected (0.00 sec)mysql> use ' info
behind%s/old/new/g Full Text replace the specified string 1n1,n2s/old/new/g Replace the character in a certain range old into new, (g means global, replace all not confirm, change to C to confirm) Save Exit Command:wq Save and exit· ZZ Save exit:q! Do not save exit:w save plus filename means Save AsIV. Application Skills:r file names are imported into the currently edited file:! command to execute Linux commands in vim mode:map shortcut key definition commands: Map ^p (ctrl+v+p) i#Continuous li
Command Execution result:: R! CommandFor example:: R file Name: R/etc/issue imports content from/etc/issue to the cursor location.:! Which command view command path: R! Date imports the current time at the cursor locationdefine shortcut keys:map Shortcut Trigger commandFor example:define a shortcut key comment line: Map ^p (ctrl + V + P) i#Delete a comment: Map ^b 0xContinuous Line comments:: Set Nu: n1,n2s/^/#/g (^ Indicates the beginning of the line)Delete a comment: n1,n2s/#//g (delete all l
Component Services, and then perform step ⑴ to completely uninstall the component.
6. DLL component storage location and permission settings
⑴. All we need to do is copy the compiled DLL file and the other files don't have to be processed.
⑵. To put a DLL outside of a Web site, such as the System32 directory, to prevent being downloaded
⑶. DLL's file rights are set to system read, Internet users traverse folders/Run files
⑷. DLL removes all permissions in IIS, such as read, script voluntary
Mysqlusetest1; ReadingtableinformationforcompletionoftableandcolumnnamesYoucanturnoffthisfeaturetogetaquickerstartupwith-ADatabasechangedmysql
mysql> use test1;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> set session sql_mode="ANSI";Query OK, 0 rows affected (0.01 sec)mysql> create table t (d datetime);Query OK, 0 rows affected (0.03
You can check it later.
I,MySQLGet current date and time
Now (): Obtain the current date + time (date + time) function:
Mysql> select now ();
+ --------------------- +
| Now () |
+ --------------------- +
| 10:26:23 |
+ --------------------- +
1 row in SET (0.00 Sec)
The same functions include current_timestamp () and localtime (), but now () is the easiest to remember. Therefore, we recommend that you use them.
Sysdate ():
(0.00 sec)
mysql> CREATE DATABASE Db11;
Query OK, 1 rowaffected (0.01 sec)
mysql> CREATE DATABASE db12;
Query OK, 1 rowaffected (0.00 sec) 6.5: Set the user's corresponding logical library
Modify Server.xml to add the logical library for the test user:
If not added, the user will be able to access the logical library of Mycat with an error:
mysql> use UserDB;
E
Label:InnoDB How to implement a row lockInnoDB row locks are implemented by locking the index entries on the index, which is different from Oracle, which is achieved by locking the corresponding data rows in the data block. InnoDB This type of row lock implementation is characterized by the fact that InnoDB uses row-level locks only if the data is retrieved by index criteria, otherwise INNODB will use a table lock! In practice, it is important to pay special attention to this feature of the Inno
lock, other sessions can be updated, where Session1 and Session2 represent two simultaneous sessions. Each row in the table represents the health of two sessions at the same time.
Mysql> CREATE TABLE t16 (ID int (one), name varchar (), age int (3));
Query OK, 0 rows affected (0.31 sec)
mysql> desc t16;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+--
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.