MySQL

In mysql, alter is used to modify the data table structure. This is the same as the mssql method. Next I will introduce several instances of modifying data tables using alter. Use the alter command in mysql to edit the table structure. Modify Table

When I used freebsd for the first time, the result was that after the various passwords were configured, I could not remember the root password of mysql. Now I have folded it back and found a way to crack the mysql password, this requires the root

The storage location of the mysql database is stored in the C directory by default. It is usually stored in the db in linux, but we can modify the storage location of the mysql database files at any time, next, I will introduce the modification

The GROUP_CONCAT () function can be called a connection field in mysql. However, when we use the GROUP_CONCAT () function, we find that this function is not that simple. Next we will introduce the usage of GROUP_CONCAT. Syntax: The Code is

I used to talk a lot about various methods for regular backup of mysql databases. Today I will introduce a super simple instance script for mysql backing up databases every day in linux. So far, none of MYSQL is always normal. Backup is king. The

Yesterday, due to power loss in the data center, a large scale in the mysql database was inaccessible or in use. Later, I checked that I could use the mysql myisamchk command to fix the problem. Next I will introduce it. Posted on December 31,200 9

This article briefly introduces some common commands for MySQL to move and rename data tables. What should I do if I want to migrate the MySQL Table to another database, rename the Table, and change the names of the two tables? How to migrate and

I opened the website early this morning and found that the dynamic page showed the ERROR 1040: Too connector connections prompt. This is not the reason for Too many connections. I don't have a few IP addresses in my blog every day, how can this

Today, I want to create a program to query data for one day, one week, and one month. I will summarize and share these SQL date query statements. My date First, we get the date format as follows: 2009-2-12, 2009-3-3, or 2009-10-12. We can use this

To allow mysql to be remotely connected and used, we need to simply enable the mysql remote connection permission. Below I will introduce several solutions for MYSQL remote connection. You need to create a remote account in MYSQL on the server. By

MySQL-Front is a mysql database management tool that can effectively manage mysql databases. Next I will introduce how to back up and restore MySQL databases using mysql-Front. 1. Back up the database After the MySQL database is created, we need to

Today, I suddenly found that php + mysql on my server could not be opened, and the log showed Can \'t open shared library \ 'udf. dll \ 'error. Restart mysql + apache. Error Message Event Type: ErrorEvent Source: MySQLEvent Type: NoneEvent ID:

In general, we can choose to set mysql encoding during installation, but it is not as convenient as windows in liunx. Next I will introduce how to modify mysql encoding in liunx. # Vi/etc/my. cnf Open my. cnf and modify the encoding. Vi/etc/my.

Performance Optimization in mysql databases has always been a hot topic. Next I will introduce how to avoid temporary tables and improve the performance of your SQL statements by 100 times.[Symptom]A slow query occurred in the online mysql database.

In mysql, null includes not null and if null or. I will introduce the precautions and usage of null in mysql. I hope it will be helpful to you. Select null = 0, NULL = 12345, NULL <> 12345, NULL + 12345, NULL | 'abc', NULL = NULL, NULL <> NULL, null

When we use SQL statements to perform a query operation, we may find that the queried data results are sorted unordered. To better observe the query results in a data table, developers or users often need to sort the queried data, which requires the

1 Preface Because the company's MySQL is built on the server, in order to avoid direct changes to the server, I chose to remotely Export and Import MySQL Data. 　　 Let's take a look at it. Because the two tables alarmdata_h and mirror R under

If the MySQL database uses the varchar (or char) type at a certain time, it is convenient for the system to use it, instead of converting the time type to adapt to different database versions, to convert the retrieved field to a time type, perform

In SQL statements, subqueries must be placed in parentheses. When executing a subquery, The subquery results are first queried, then, the results returned by the subquery are used as the query conditions for the outer query. Subqueries can be

Jquery + php + mysql second-level linkage example with the database. This is a second-level linkage menu of the city that uses juqery to interact with php in real time. In the past, we used js to present the second-level linkage menu, now let's use