Hi All,
I have one table namely app_users with fields(username ,password,emai, phno,address) and one more table add_users with fields (uname,name,phn o,email,status) .
If email address is already exists in app_users table,then i should make the status column in app_users as"available"ot herwise "notavailab le".
here uname is foreign key for username,which is primary key in the table "app_users"...
suma2006
Last Activity: Oct 6 '07, 06:26 AM
Joined: Sep 12 '07
Location:
-
suma2006 started a topic Setting the value of a field depending on whether the value exists in another tablein MySQLSetting the value of a field depending on whether the value exists in another table
-
how can i make one column as primary key?
Hi All,
Here i have one table.what i need to do this is make one column as primary key.
How can i achieve that?
Thanking you,
Regards,
Suma -
Thank you very much! i am new to DB.
How can i add primary key constraint to the existing column?
Regards,
suma -
suma2006 started a topic how to make the newly added column as foreign keyto its parent table in mysql?in MySQLhow to make the newly added column as foreign keyto its parent table in mysql?
Hi All,
I have one table for that i want to add one more column and making that column as foreign key to some other table.How can i do that?can any one give the syntax?
here i know the syntax for adding a column:[code=mysql]
ALTER TABLE <table_name> ADD COLUMN <column_name> <datatype>[/code]
Regards,
Suma
No activity results to display
Leave a comment: