MySQL use notes (i)

First, installationTo install with a version that is free of installation: 1. Unzip to the installation directory 2. The My-default.ini file under the Copy directory is the My.ini file 3. Modify the contents of the My.ini file as [Client] port=

Raspberry Pi Build installation MySQL

Recently started a Raspberry Pi, a whim to make a small home server, at home for the hour has been hanging. Really is very small, only slap big, to Raspberry Pi bought some accessories, shell, small fan, 2 fins, 32G SD card, HDMI line, after the

Clumsy birds have java--mysql Chinese data garbled for what???

From the beginning to knock DRP to now hibernate, Chinese data garbled all the time "accompany" in My side: Figure one: In the DRP distributor module, each time the modification area is successful, but the Chinese data read every time is "???

CentOS 6.0 Installation mysql-5.1.73 process

First, installation environmentCentos-6.0-i386-minimal.isoKernel: 2.6.32-71.el6.i686MySQL version: 5.1.73Second, installation stepsUseradd-m-s/sbin/nologin MySQLMkdir-p/app/toolscd/app/tools/wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1

MYSQL ERROR 1045 (28000): Access denied for user (using Password:yes)

After installing MySQL, some users want both local and remote access.Mysql-h Host-uroot-ppassword Error occurred:MYSQL ERROR 1045 (28000): Access denied for user (using Password:yes)This is because you do not have access to MySQL, your host is not

How Ubuntu changes the MySQL default folder Data folder

Stop MySQL Repair* Sudo/etc/init.d/mysql stop Copy of the original folder* cp-r/var/lib/mysql/home/yourname/somewhere Change permissions* sudo chmod mysql:root/home/yourname/somewhere/mysql* sudo chmod 777/home/yourname/somewhare/mysql

Mysql Group_concat () function splicing string

SELECT Group_concat (Ut.id_card ORDER by Ut.id_card DESC SEPARATOR ', ') from ' Edu_user_train ' ut where ut.id in (614,615 ) Output: 500231199108181861,371324198450304515 usage Scenario: Returns a pure numeric mate in query example: SELECT u.name

View database in MySQL

To view the currently used database, use the following commandMysql> Select Database (); #使用函数database ()Mysql> Show tables; #列头信息中可看出当前使用的db in the format: Tables_in_[db_name]mysql> status; #注意结果中的 "Current database:" InformationSee what databases

Mybatis+mysql +insert FOREIGN KEY constraint error

A scenario appears:ica_classify The primary key ica_classify_id in the table is the foreign key of the website_commodity_information tableTable structure slightlyFOREIGN KEY constraint error when inserting data into table

MySQL Transaction ISOLATION level learning

This article focuses on the differences between MySQL transaction isolation levels and some of their own feelings.I have not been able to understand the "repeatable reading" and "can be read " The difference between the two, through this practice,

MySQL cursors use No data-zero rows fetched, selected

Transferred from: http://blog.sina.com.cn/s/blog_544c72960101bvl3.htmlThis is an example of how a cursor is used.But there are a few points to note, which is why to join declare CONTINUE HANDLER for SQLSTATE ' 02000 ' SET tmpname= null;If not added,

Let MySQL support emoji emoticons

Java get to the end of the delivery of emoji expression inserted after MySQL error message, errors are as follows Java.sql.SQLException:Incorrect string value: ' \xf0\x9f\x92\x94 ' for column ' name ' at row 1 at

Linux MySQL errorcode 29

sudo aa-statusIf Mysqld is included in enforce modeWhen AppArmor blocks the writes/accesses. What are can do is edit/etc/apparmor.d/usr.sbin.mysqldnear the bottom like so: /usr/sbin/mysqld {   &NBSP, ..... /VAR/LOG/MYSQL/R,     /var/log/mysql/*

MySQL Master-Slave synchronization

1. Prepare two virtual machines a 192.168.174.132 "master" B 192.168.174.133 "from" 2.MySQL version >5.03. Common commands Show Master status;show slave status;show Procudesslist \g; You can see how many clients are currently linked to this library 4

MySQL stored procedures and functions

Lin Bingwen Evankaka Original works. Reprint please specify the source Http://blog.csdn.net/evankakaSummary: Stored procedures and functions are collections of SQL statements that are defined in the database, and then call these stored procedures

MySQL Common functions

-----------------------------String Function-------------------------------------------stitching strings, any string with null concatenation is nullSelect Concat (' AAA ', ' BBB ', ' CCC '), concat (null, ' AAA ');----Replace three characters from

MySQL Database SQL optimization--sub-query optimization

1, what is a subquery, table association query:Subquery: Refers to using a SELECT query statement in the Select or WHERE clause in the main SQL statement; Select A.name, (select B.name from B where b.id=a.id) from a where a.name lik ' a %‘Table

MySQL problem solution: Access denied for user ' root ' @ ' localhost ' (using Password:yes)

This two days when developing Web projects in MyEclipse, there was a problem connecting to the MySQL database:Access denied for user ' root ' @ ' localhost ' (using Password:yes).Find information found that the root account is not open to remote

Modify MySQL user name password and phpmysqladmin corresponding password modification

The local MySQL runtime may use the password to modify the user name:mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Enter new password ');There is no modification user ah, you mean to modify what program framework in the

MySQL Configuration SQL Assistant tips

The previous development has been using SQL Server database, prompting the plugin to use SQL Assistant, writing the kicker is quite efficient. This time the company transformation to use MySQL database, trial MySQL Workbench, MySQL Query browser and

Total Pages: 3233 1 .... 1308 1309 1310 1311 1312 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.