mySQL Force Not Null using Query or phpMyAdmin

Question

Im using XAMP with mySQL and phpMyAdmin.

I cant seem to work out how to set a column to NOT NULL in php my admin..

How do i do this?

Is there a quick way to set all columns not to be null in mySQL?

I havve tried: ALTER TABLE flights CHANGE FlightID NOT NULL;

Thanks

Mike Brant · Accepted Answer · 2013-04-24 19:41:08Z

2

You just need to issue an ALTER TABLE statement like this:

ALTER TABLE table_name
MODIFY column_name [data type] NOT NULL,
MODIFY column_name_2 [data type] NOT NULL,
...
MODIFY column_name_x [data type] NOT NULL

Note that [data type] here is of course the data type of your column (i.e. VARCHAR(255) or whatever)

Just list all the columns you want to modify in this single statement.

answered Apr 24, 2013 at 19:41

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Lemex Over a year ago

Do you need to specify the datatype?

Lemex Over a year ago

I get this 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 ''flights' MODIFY 'FlightID' int(6) NOT NULL, MODIFY 'AircraftID' int(6) NOT ' at line 1"

Mike Brant Over a year ago

@Lmc Yes you need to specify the data type

Mike Brant Over a year ago

@LmC Don't use single quotes around your database object names (table name, column names). You should use backticks.

Lemex Over a year ago

Ahhh sorry! Ill give it a try

Collectives™ on Stack Overflow

mySQL Force Not Null using Query or phpMyAdmin

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related