OverviewQuery statements may query multiple records, using cursors in stored procedures and functions to read the records in the query result set one by one. Some books call the cursor a cursor. The use of cursors includes declaring the cursor,
MySQL Database error log appears "the Table xxx is full", the first reaction is the hard disk space, check that the hard disk has a lot of spaceThe table ' xxx ' is fullLook at the ' xxx ' table, found that the table is a memory table, and the size
Long time Login vps, then mysql password forgot .... So, Baidu's, record a bit 1. First confirm that the server is in a secure state, that is, no one can connect to the MySQL database arbitrarily. Because the MySQL database is completely out of
1. Check the character setSHOW VARIABLES WHERE variable_name like ' character\_set\_% ' OR variable_name like ' collation% ';2. mysql Character set settings• System Variables:–character_set_server: Default internal operation character
In a production environment, it is sometimes necessary to modify the password of a copied user account, such as a lost password, or because many different replication users want to unify into a single copy account. This should be done as carefully
Www.mysql.com official websiteCommunlty Server Community Edition freeDisplay the system's own MySQL packageYum List | grep MySQLInstall MySQL:Yum install-y mysql-server MySQL mysql-develLook at the version that was pressed:Rpm-qi
1. First stop the MySQL service2. Then open a command-line window (WIN+R), and then switch to the MySQL installation directory under the bin, for example my path is:F:\mysql\mysql5.5\bin. The command is:CDF:\mysql\mysql5.5\binEnterInput:
– The structure of the table ' test '–CREATE TABLE IF not EXISTS ' test ' (' id ' int (one) not NULL auto_increment,' Name ' varchar (+) is not NULL,' Phone ' int (one) is not NULL,PRIMARY KEY (' id ')) Engine=myisam DEFAULT Charset=utf8;–– Export
[Email protected]/]# mysqldump--all-databases--user=root--password--master-data > Backupdatabase.sql #备份原数据库Enter Password:Mysqldump:Error:Binlogging on server not active #提示启动过日志[[email protected]/]# VI/ETC/MY.CNF # [mysqld] Add log-bin = mysql-bin
one: MySQL character setMySQL Character set support (Character set supports) has two types: Character set (Character set) and connection proofing (Collation). Support for character sets is refined to four levels: server, database, data table (table),
First of all, the forum's managers and some of the forum on the sidelines of the people expressed regret.Yesterday met GBK and UTF8 mutual turn problem, check a lot of data have not figured out, post questions nobody, to the management message is
One. Common MySQL command-line commands1. Start MySQL service net start MySQLStop MySQL service net stop MySQL 2. Netstat–na | findstr 3306 View the port being monitored, findstr is used to find out if there is a port in the back3. Log in to the
Introduction to the one or two binary logMySQL has different types of logs, where binaries record all modifications to the database, and if the database loses data because of improper operation or other reasons, it can be recovered by binary
Get ready:CREATE table t (x int,y int); Usage 1:Modifying a column's data classALTER TABLE t modify column y nvarchar (32); Usage 2:Add a column to a tableALTER TABLE t add column z int; Usage 3:To delete a column in a tableALTER TABLE t drop
After installing MySQL or MARIADB, we use interface management tools to manage, recommended management tools: SQLyog, Navicat for MySQL1, firewall to open 3306 port2. Authorization to remote users[Email protected] backup]# mysql-u root-pEnter
Database--a container for organizing, storing, and managing data by structureCommonly used functions, what function to use can be checked on the manual, very convenient, the main first will be some basic canMySQL function-(MySQL seems to be
Import text files to mysql database tables and insert commands to insert data to tables
1. Import a text file to a database TABLE: mysql> load data local infile 'text path 'into TABLE name; example: mysql> load data local infile 'd: /pet.txt
(5) Common mysql storage enginesOverview
?? Before mysql5.5, the default storage engine is MyISAM, and after 5.5, it is changed to InnoDB. To modify the default engine, you can modify the default-storage-engine in the configuration file. You can use
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service