Help On Mysql Database - Computers - Nairaland
Nairaland Forum › Science/Technology › Computers › Help On Mysql Database (788 Views)
1 Reply
| Help On Mysql Database by 8inchplus(op): 4:54pm On Jul 17, 2007 |
please does anybody who has indept knowlege on oracle and mysql tell me how add check constraints to the database? thanks |
| Re: Help On Mysql Database by buddie(m): 3:29pm On Oct 08, 2007 |
Browse google for that pally |
| Re: Help On Mysql Database by Tini(m): 11:15pm On Oct 08, 2007 |
It depends,u add a check constraint to a table.either at the time of creation of the table or after creation.u can do that with enterprise manager.edit the table add the constraint.or see an example in sql. ALTER TABLE employees ADD CONSTRAINT validate_hire_date CHECK (hire_date > TO_DATE('15-Apr-1999','DD-Mon-YYYY')); ---Get an e-book to help u. |
Learn Php/mysql The Wordpress Way!!! • Mysql • Training Videos On HTLM5, Joomla, Autocad, Cisco, Microsoft, PHP/MYSQL And More! • 2 • 3 • 4
Go Ahead • In Dire Need Of A Laptop Screen. • Vsat Equipment For Sale