How to create a database table

m
m
Line 33: Line 33:
 
You can choose the following attributes:
 
You can choose the following attributes:
  
'''''BINARY''''' - the field collation will be binary, e.g. ''utf8_bin'';
+
'''''BINARY''''' - the field collation will be binary, e.g. ''utf8_bin'';
  
'''''UNSIGNED''''' -  the database table field will have positive or 0 numeric  
+
'''''UNSIGNED''''' -  the database table field will have positive or 0 numeric values;
values;
+
  
'''''UNSIGNED ZEROFILL''''' - the field will have positive or 0 numeric values  
+
'''''UNSIGNED ZEROFILL''''' - the field will have positive or 0 numeric values and leading zeros will be added to a number;
and leading zeros will be added to a number;
+
  
'''''ON UPDATE CURRENT_TIMESTAMP''''' - the current timestamp is the default  
+
'''''ON UPDATE CURRENT_TIMESTAMP''''' - the current timestamp is the default value for the data type field, and is automatically updated;
value for the data type field, and is automatically updated;
+
  
 
* '''Null'''
 
* '''Null'''

Revision as of 07:57, 18 November 2011

rss feed for my website