How to remove constraints from my MySQL table?


Problem :

I want to remove constraints from my table. My query is:

ALTER TABLE `tbl_magazine_issue` 
DROP CONSTRAINT `FK_tbl_magazine_issue_mst_users`

But I got an error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint FK_tbl_magazine_issue_mst_users' at line 1



Solution :

Mysql has a special syntax for dropping foreign key constraints:

ALTER TABLE tbl_magazine_issue
  DROP FOREIGN KEY FK_tbl_magazine_issue_mst_users

Mysql Tutorials

Mysql Howto..

how can calculate the total price for 5 days (mysql ) hotel booking system

How to tune self-join table in mysql like this?

How to update many-to-many related objects with Entity framework 1 & MySQL?

How to left join another nested table?

how to use VC to operate the date in files of MYSQL

MySQL - How to update atable based on an internal ordering of the table

Compare column values from two tables and show their differences

How to display images from database mysql using php?

How to store values of select query in variables in the webservice?

how to insert time as string by time intervals into mysql database

How to analyse Wikipedia article's data base with R?

how to automatically export mysql database in phpmyadmin

MySQL: How to alter varchar(255) UNIQUE column to UNIQUE Text NOT NULL?

How can I tell which MySQL process created a temporary file and if the temporary file is still in use?

How to get an automatically incremented column value when inserting a row into a table in mysql using java?

how to display images stored in a mysql database using PHP

How to fix a MySQL syntax error when deploying a working Play application to CloudBees?

How to concat three columns if they are not blank and also do a unique in MySQL?

how to query such that a group of rows are repeated exactly using mysql

When selecting an amount of rows, how can I select a percentage of a percentage?

How to limit the MySQL Query with Ebean in Play Framework

How to count the amount of objects in a django joined table?

How to insert XML content into mysql database using PHP

How to generate a line graph based on results within a MySQL database

How to prevent duplicate usernames when people register? PHP/MySQL

How long will a MyISAM table lock by default?

Using PIP in a virtual environment, how do I install MySQL-python

How to edit multiple records in mysql using sql update

How would I transfer a large amount of data to a MySQL server in one value?

JPA Desktop APP and Remote MySQL - How To