MySQL 1136 error

The number of fields does not match, the table gods that needs to be inserted is not two fields, and the data you insert now (that is, the result of select) is two columns, and the system does not know how to insert data.

To modify the method, the first is to modify the select statement so that the number of fields selected is the same as the number of fields in the table. The second is to list the fields you only insert at the end of the insert table.

The number of columns in the goods table is greater than the number of columns displayed in the select statement that follows.

I had the same mistake and it took me a long time to figure it out. The online solution has been tried, but none of them really work. In the end, it was summed up and finally solved.

Workaround: Add tmpdir = d:.

Problem solving. 2. Later, I compared with and found that there was no data directory, and a lot of data files were stored. When you were originally debugging a version, remember that the log report always had a non-existent message. (I thought these files would be generated automatically.)

Later, copy the entire mysql folder in this version to the same directory in the version. Problem solving.

1. First, right-click [Manage] on the computer.

2. In the computer management interface, find [System Tools] - > Time Viewer] - >Windows Log] - > Applications]. Click Applications.

3. Click [Application] on the right side to find the latest MySQL error message. Double-click to view the problem based on the latest error message prompts. As can be seen from the information on the figure, port 3306 is occupied this time.

4. As long as you find the real reason, it will be easy to solve, this time I am due to the installation of phpwamp, that is, php integrated development environment, resulting in port occupation, just stop mysql in phpwamp.

5. Then restart MySQL.

1. MySQL error 1067 needs to reset the file to solve the problem. First, go to the mysql installation directory and delete it, and then copy it as:

2. Next, double-click to open the new one, add the attributes of basedIR and datadir behind the last line of [mysqld], save it, you need to pay attention to it here, the installation path should be written to your own mysql path:

3. Finally, start the MySQL service, and MySQL can be started normally. That's it for the detailed steps to fix MySQL error 1067:

The solution to system error 1067 occurs in mysql is as follows:

1.Delete %windows%.

2.Delete the other places.

3.Copy it in the mysql installation directory as.

4.Insert :

mysqld]

Set the basedIR to the MySQL installation path basedIR=C:

datadir=c:\

5.Reboot.

c:\>net start mysql

The mysql service is starting

The MySQL service could not be started.

There was an error in the system. System error 1067 occurred.

The process terminated unexpectedly.

c:\>mysqld-nt --removeservice successfully removed.

c:\>mysqld-nt --installservice successfully installed.

c:\>net start mysql

The mysql service is starting

The MySQL service has been started successfully.

c:\>net stop mysql

The MySQL service is being stopped.

The MySQL service was successfully stopped.

After installing MySQL, change the password of the root.

net startmysql

I had a problem like this when I started with c: mysql bin mysqladmin-u root -p shutdown after using the following command

Then net start mysql will not have this error prompt!

I had the same mistake and it took me a long time to figure it out. The solutions on the Internet have been tried, and there is no blind judgment that it is really feasible. In the end, it was summed up and finally solved.

Workaround: Add tmpdir = d:.

Problem solving. 2. Later, I compared with and found that there was no data directory, and a lot of data files were stored. When the original debugged version, remember that the log report has always had a hint of the existence of the spring change of the Gods. (I thought these files would be generated automatically.)

Later, copy the entire mysql folder in this version to the same directory in the version. Problem solving.