raydona Posted May 5, 2011 Share Posted May 5, 2011 Hi, I'm using phpMyAdmin (PHP Version 5.3.4) to create tables in a database. I'm a bit confused about Null and Default fields. I know Null is if someone doesn't want to insert a value. If this is ticked then a Default value has to be given (in which case it must be wrong to say: cat_id INTEGER NOT NULL DEFAULT 0,). For type INT would the Default be As defined: 0 and for VARCHAR As defined: ' ' or would one simply insert NULL? I'd be grateful for all help. Link to comment https://forums.phpfreaks.com/topic/235559-null-and-default-fields-in-mysql/ Share on other sites More sharing options...
fugix Posted May 5, 2011 Share Posted May 5, 2011 for default values..i normally use null unless i want to assign a default value to the field. Link to comment https://forums.phpfreaks.com/topic/235559-null-and-default-fields-in-mysql/#findComment-1210682 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.