Hey how will I write a text file to setup a database with the information below



Database set-up:

Members Table:
id - int primary key auto_increment.
username - varchar 15.
password -...

varchar(32)

I have a table called "users", in the table it contain a column/ field name "reg_date" how would i run an query to say: For all the users, if their feild "reg_date" is blank put "20th December 2008"

Hi what sql query will I use to checks the "users_theme" table and finds all the user_id's which exist in this table and not the "users" table. Once I have those id's that exist in the user_theme...

Perfect! you are the best!

Yea I know that query already but I want it to show the duplicates so that i can leave on and delete the another. It is just showing me the emails and how much is duplicated

I am using mysql and I have a table called "users". how will i get it to show only rows that have duplicate emails in the "email" field. I want the emails in order. what sql query will I use?

No there is no problem. How will I go about it?

How can I create a trigger to UPDATE this for me when a new record is inserted.

I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add...

What will i put in my sql command to get that?

I did and I am having trouble doing it...Can anyone help

How to create a trigger to UPDATE this for me when a new record is inserted.

I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the...

nice...so how would i create a trigger to by default store "'http://k5live.com/thumbs/" and add thumb to it.

will this code be ran all the time to always update

Is it possible to make a column on my database that automatically copy another column on the same table string together with another url?

for example on my database "ewelby_k5" I want to create a...

I NEED HELP PLEASE PLEASE PLEASE
THE PROBLEM IS

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in...