How to delete a column from a row inside a table? (mysql)

Linear Mode

Mauzen
High-roller

Posts: 4,878
Threads: 85
Joined: Jun 2007
Reputation: 0

09.11.2014, 01:08

The DELETE statement does not accept single fields. It is meant to delete whole rows only, as it already says in the first paragraph of the documentation: http://dev.mysql.com/doc/refman/5.0/en/delete.html

If you want to reset/remove the value of a single field you should just use UPDATE to set it to NULL

Find

« Next Oldest | Next Newest »

Messages In This Thread

How to delete a column from a row inside a table? (mysql) - by Capua - 09.11.2014, 00:33

Re: How to delete a column from a row inside a table? (mysql) - by Eth - 09.11.2014, 00:36

Re: How to delete a column from a row inside a table? (mysql) - by Eth - 09.11.2014, 00:46

Re: How to delete a column from a row inside a table? (mysql) - by Capua - 09.11.2014, 00:50

Re: How to delete a column from a row inside a table? (mysql) - by Eth - 09.11.2014, 00:58

Re: How to delete a column from a row inside a table? (mysql) - by Mauzen - 09.11.2014, 01:08

Re: How to delete a column from a row inside a table? (mysql) - by Capua - 09.11.2014, 01:50

Re: How to delete a column from a row inside a table? (mysql) - by LaPiMoNsTeR - 09.11.2014, 03:27

Re: How to delete a column from a row inside a table? (mysql) - by Eth - 09.11.2014, 09:29

Re: How to delete a column from a row inside a table? (mysql) - by Eth - 09.11.2014, 09:46

View a Printable Version

Forum Jump:

Users browsing this thread: 1 Guest(s)

Login
Username:
Password:	Lost Password?
	Remember me