MySQLerror121 & amp; error150 _mysql

Source: Internet
Author: User
MySQLerror121amp; amp; error150 analysis bitsCN.com
Today, the external keywords are used for writing Database Scripts. two types of errors are encountered during the runtime: 121 and 150. I found a solution on Google. They are explained as follows:
Error 121: this is an error where the names of external keywords are repeated. the names of external keywords cannot be repeated even in different tables. Error 150 contains three types of errors: 1. the types of foreign keys and referenced foreign keys are different. for example, integer and double2. the column to be referenced cannot be found. 3. the character encoding of the table is different from that of lilee84bitsCN.com.

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.