To disallow NULL values in any of the columns, add NOT NULL to the definition of each one. : Column « Table Index « SQL / MySQL

1.	Aggregate Functions
2.	Backup Load
3.	Command MySQL
4.	Cursor
5.	Data Type
6.	Database
7.	Date Time
8.	Engine
9.	Event
10.	Flow Control
11.	FullText Search
12.	Function
13.	Geometric
14.	I18N
15.	Insert Delete Update
16.	Join
17.	Key
18.	Math
19.	Procedure Function
20.	Regular Expression
21.	Select Clause
22.	String
23.	Table Index
24.	Transaction
25.	Trigger
26.	User Permission
27.	View
28.	Where Clause
29.	XML

SQL / MySQL » Table Index » Column

To disallow NULL values in any of the columns, add NOT NULL to the definition of each one.

       

mysql>

mysql> CREATE TABLE people

    -> (

    ->     id         INT UNSIGNED NOT NULL,

    ->     first_name CHAR(30) NOT NULL,

    ->     last_name  CHAR(30) NOT NULL

    -> );

Query OK, 0 rows affected (0.00 sec)



mysql>

mysql> drop table people;

Query OK, 0 rows affected (0.00 sec)



mysql>

Related examples in the same category

1.	Important Column Attributes and Options
2.	Drop a column
3.	Chage column name
4.	Change column definition
5.	Change column data length
6.	Change column data type
7.	change column type and sequence in table
8.	Modify a column
9.	Adding a Column
10.	Changing a Column Definition
11.	Renaming a Table
12.	Dropping a Column
13.	Syntax for Adding a Column
14.	Returns detailed information about all columns of the table tablename
15.	Exchanging Rows and Columns
16.	To copy only some of the columns, name the ones you want in the SELECT part of the statement.
17.	To create columns in a different order than that in which they appear in the source table
18.	Get information only for the co_2 column, you can't use this query:
19.	The -e option specifies the query to execute, and -N tells MySQL not to write the row of column names that normally precedes query output.
20.	Copying Only Selected Columns from a Table
21.	Specifying Which Columns to Display
22.	Giving Names to Output Columns
23.	Aliases can be applied to any result set column, not just those that come from tables
24.	Combining Columns to Construct Composite Values
25.	Put the comparison expression in the output column list, perhaps including the values that you're comparing
26.	Refer to the additional output column by position
27.	Take everything but the rightmost two columns
28.	Dropping, Adding, or Repositioning a Column
29.	To indicate a column at a specific position within the table, either use FIRST to make it the first column, or
30.	Changing a Column Definition or Name
31.	After the CHANGE keyword, you name the column you want to change, then specify the new definition, which inclu
32.	Changing a Column's Default Value
33.	Information only about a single column, use a LIKE clause that matches the column name
34.	-d option specifies a field delimiter of : and the -f option indicates that you want to cut column one and all
35.	Add a sequence column named id to the table
36.	Give each table a short alias and refer to table columns using the aliases:
37.	To exclude them, provide a column output list that names specifically only those columns
38.	To produce additional columns showing the total and average values of the books for each author in the author
39.	CREATE TABLE statement provides an example of a TEXT column named DescriptionDoc
40.	Create the Catalog table and includes two NOT NULL columns
41.	Reference a column
42.	Add and drop columns
43.	Giving Columns a New Heading with AS
44.	Alias column with spaces
45.	Insert data without column names
46.	Column definition with modifiers
47.	Sort by column name
48.	Sort more than one columns
49.	Get the descriptive data of the columns belonging to the PLAYERS table
50.	A table contains only one column.
51.	A column definition may include options to define the column data more precisely.
52.	More complex tables have multiple columns
53.	Adding and Dropping Columns
54.	Modifying Existing Columns
55.	Change the LastName column from CHAR(30) to CHAR(40) without renaming the column
56.	Column Types
57.	NULL Values and Column Definitions
58.	Use single quote with char type column
59.	Column alias with underscore
60.	Using Case clause to show meaningful value for column
61.	Select all columns from a table inside another database
62.	Concatenate columns
63.	Using qulified column name
64.	Compare two columns together
65.	Compare two columns and yield two values
66.	Column sequence in insert statemenet
67.	Change column type and settings during table copying
68.	Enlarge column during table copying
69.	Set column to use default value
70.	Get default value from a column
71.	Table column with comments
72.	Check table column settings
73.	Unique modifier for column definition
74.	Indicate unique after column definition
75.	Check column value
76.	Set type column

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.