MySQL

The Products table is as follows:1. Basic character MatchingUsing regular expressions and like, the regular expression is searched throughout the column, as long as the prod_name contains the characters that are searched, and if you do not use

Connected to the MySQL database, when inserting data, the console report:Com.mysql.jdbc.MysqlDataTruncation:Data Truncation:data too long for column ' user_name ' at row 1Error, specific information is as follows:Critical: Servlet.service () for

§1. InnoDB row locks are implemented by locking the index entries on the index, unlike Oracle, which is implemented by locking the corresponding data rows in the data block.InnoDB This type of row lock implementation is characterized by the fact

There are two types of solutions available online:The first is that each time a statement is executed, it is similar to PHP, and first executesOne sentence "Set names UTF8" or "Set names gb2312";1 New Mysqlcommand ("set names b2312", m_connection); 2

MySQL default maximum connection number is 100, add the default MySQL connection number method has twoMethod One: Enter the MySQL installation directory to open the MySQL profile my.ini (Windows) or MY.CNF (Linux environment) lookup max_connections=1

MYSQL binary log management script is used to flush the database every hour to generate new binary logs, back up binary logs to NFS, and compress and store them :#! /Bin/bash # Purpose: Manages mysql binary logs, refreshes binary logs every hour,

Mysql function split learning mysql 5. * The version does not have the split function, but it will be used in some places. Here we will simply record it: set global log_bin_trust_function_creators = 1; 1. FUNCTION func_splitStringTotal: splits the

MySQL cursor syntax Example 1. Basic Syntax: SQL code # define the cursor declare fetchSeqCursor cursor for select seqname, value from sys_sequence; # Use the cursor open fetchSeqCursor; # fetch Data fetch cursor into _ seqname, _ value; # close the

Mysql things (10) trigger 1 link: Mysql things (1) mysql Installation http://www.bkjia.com/database/201210/162314.html Mysql (2) Database Operations http://www.bkjia.com/database/201210/162315.html Mysql (3) operations on Data Tables