MySQL

Today learn how to use Java to manipulate the database, tutorial video There are two methods, one is JDBC-ODBC Bridge connection, one is the direct use of JDBC. I chose the latter.But not as simple as the tutorial, the tutorial uses SQL Server 2000,

In other words, I built a database called AC in MySQL, but I can't find its storage location, how is the database stored in MySQL, and is there a log file and data file like SQL Server?MySQL database on the system is in the form of a folder, you

--Single field indexCREATE INDEXLast_name_index - onemployee_tbl (last_name); Query OK,0Rows Affected (0.06sec)--Unique indexCREATE UNIQUE INDEXLast_name_unique_index - onemployee_tbl (last_name); ERROR1062(23000): Duplicate Entry'GLASS' for Key '

Using the root user Perform: Grant Select,insert,update,delete on projects.* to ' test ' @ ' percent ' identified by ' test '; Results: ERROR 1044 (42000): Access denied for user ' root ' @ '% ' to database ' XXXXX ' Workaround: User MySQL; SELECT *

MySQL Master-slave configurationConfigure to prepare the database to be configured for master-slave synchronization, the master-slave server must have the same databaseFirst, configure the MySQL master server[[email protected] ~]# vim /etc/my.cnf....

1. Load DriverString drivername= "Com.mysql.jdbc.Driver"; Database-driven Classpathtry{Class.forName (drivername); Create a driverSystem.out.println ("Create driver success!") ");}catch (ClassNotFoundException e) {E.printstacktrace ();}2. Define

MySQL indexes and keys(Different indexes have different functions, different constraints, different rules of use)Pros: For a table, an index is like a book's directory that can speed up queriesCons: Occupy physical storage space (index information

The InnoDB engine differs from the MyISAM engine. MyISAM InnoDB row-level lock non-object security things security full-text indexing full-text

The name of MySQL master-slave replication is actually: Copy data from one server to another server and execute it again. One server is treated as a primary server (master) and one or more servers as a Slave server (SLave) during the replication

First learn about the one or twoOne, (create user under MySQL and give permission) root user Create SQL statement of Yong UserCREATE USER ' yong ' @ ' localhost ' identified by ' yong2022 ';GRANT USAGE on *. * to ' yong ' @ ' localhost '

1, after decompression, in mysql the directory found my-default.ini , and copied namedmy.ini2, set the character set encoding, add the following lines of code, this configuration must be set in the new configuration file my.ini , otherwise it will

Always in the leak out of the bug, only to find that they do not know the depth of knowledge. There are two table structures drop table if EXISTS A; CREATE TABLE A ( ID int (1) not NULL, PRIMARY KEY (ID)) Engine=myisam DEFAULT Charset=utf8;

Transferred from: http://imysql.com/2015/05/24/mysql-optimization-reference-1.shtmlThis article has compiled some common methods of MySQL optimization, to do a simple summary sharing, to help those who do not have full-time MySQL DBA to do basic

Com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:Column ' goodsname ' cannot be nullThis error is the error that occurred when I encapsulated the page.private void Addgoods (HttpServletRequest request,httpservletresponse response)

MySQL Horizontal Split (Reading Notes)1. Introduction to horizontal split In general, a simple horizontal split mainly refers to distributing a table with extremely ordinary access to multiple tables according to certain rules of a field. Each table

(1) Positioning of SQL Performance problems during mysql OptimizationOverview When we face a problem, we first discover the problem and then solve the problem. This article mainly addresses how to locate the problem. Solution 1. Use show status to

MySQL Query OptimizationThere are many things to optimize database queries. The basic principles are as follows: reduce the disk I/O count that occurs during database queries. Use indexes to avoid full table traversal and scan to reduce the amount

MySQL regularly deletes tables. For a log table with more than 0.8 billion entries, the log table created 30 days ago must be automatically deleted after automatic table sharding. However, these log tables are only removed from the Master, and Slave

Mysql database connection and addition, deletion, modification, and query Java code implementation (Statement Version) Database: create table t1(id int primary key not null auto_increment,name varchar(32),password varchar(32));insert into

Describes the Transaction Features in MySQL and MySQL transaction features. A transaction is a continuous set of database operations, as if it is a single unit of work. In other words, it will never be a complete transaction, unless each individual