unique and null values

back to my unique constraint again :) i asked on irc but couldnt get anything out of them so i came here. got a unique constraint with serveral columsn like so.. UNIQUE (col1,col2,col3) id like to have col2 and col3 to use null values but it doesnt seem to like this. Is there a way i can use co

unique and null values

back to my unique constraint again :) i asked on irc but couldnt get anything out of them so i came here. got a unique constraint with serveral columsn like so.. UNIQUE (col1,col2,col3) id like to have col2 and col3 to use null values but it doesnt seem to like this. Is there a way i can use co

unique and primary constraints

hi sql ppls, if i set a field as a primary key, does it automatically make sure its unique or should i declare a UNIQUE constraint as well? or will primary do the job by itself. thanks - Josh [EMAIL PROTECTED] - Before pos

sql to .php

hey, i have some sql to create the tables for my small database in a text file at home i can use sql batch mode to runt he sql commands from this text file. id like to take this sql code and run it on the mysql server at my free webhost, but i dont think i can connect to their mysql server with