Validations

2003-03-30 Thread warm-fusion
Hi, I'm a newbie to MySQL, and I'm wondering whether there is any way to set validations on acceptable field values when using the 'create table()' etc. statements? I've performed a (most cursory) search of the documentation, but that didn't turn up anything useful. Any suggestions? Many thanks

'delete' syntax

2003-03-31 Thread warm-fusion
Hi, I'm just wondering what the right syntax for using the delete statement is? I'm trying to write a simple garbage collection/deletion query similar to the queries below. delete from 'item' where 'quantity_of_item_in_stock' <= 10; (the above version of the query pops up a Java-applet alert as