Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,201,654 members, 7,979,212 topics. Date: Friday, 18 October 2024 at 11:46 PM |
Nairaland Forum / Science/Technology / Computers / Help On Mysql Database (730 Views)
Learn Php/mysql The Wordpress Way!!! / Mysql / Training Videos On HTLM5, Joomla, Autocad, Cisco, Microsoft, PHP/MYSQL And More! (2) (3) (4)
(1) (Reply)
Help On Mysql Database by 8inchplus(m): 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. |
(1) (Reply)
Photoshop & Firework Setup ? / D-link Trainning / Vista Uultimate
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 8 |