INSERT INTO test (code1) VALUES (NULL)

I believe if column code1 is PRIMARY or UNIQUE then there can be only one row where it is NULL

the biggest difference is an unsigned number cannot be negative (just as stated above)

but the benefit of usign an unsigned number is that you can have a greater range of positive numbers.
...

well there are many things you need to tell us first, what language you plan on using the integrate the database with is a biggie, eg: PHP, ASP, JSP, CFM, etc...

you also need to figure out ALL...

ok so I have two tables, and I believe I need an outer join

lets say these are them: CREATE TABLE t1 (
xid INT PRIMARY,
data1 VARCHAR(50) );

CREATE TABLE t2 (
xid INT...

you might also want to put LIMIT 5 on there at the very end to just retrieve the last 5 results

you need to create a table, ie this would be an example:

CREATE TABLE email_list (
email VARCHAR(75) NOT NULL,
name VARCHAR(75) NOT NULL,
PRIMARY KEY(email)
);

then...

is there a way to INSERT AND SELECT unique_id at the same time? or does it have to be done as two seperate queries

i want to generate a unique primary key, something similar to the auto increment feature, but i do not want it to be auto increment.

The reasoning for this is: this table will have rows deleted by...

this is way beyond the scope of mysql, you should be looking into jsp, php or asp depending on your sever type

your answer will probably be use some sort of cookies and/or sessions

<input type="text" name="field1" value="" />
<input type="text" name="field2" value="" />
<input type="text" name="field3" value="" />

perhaps you are not logged in with the correct username/password combination

if you do have a correct user name/password then...
maybe the one you have doesn't have access to SELECT statments on...

you first need to connect to the database first, place the following anywhere before anyof your database queries


$db = mysql_connect("localhost", $user, $pass) or die ("could not establish a...

We would need more information... try closing the session and creating a new one (or if you use cookies renew them with the new information)

yes but I was hoping for an effecient way to do this! I have almost 300 tables in 1 database so as you can see that really wounldn't be an ideal search method as check table would be much quicker...

is there a way to check the exsistance of a table? I want something similar to this:
SELECT COUNT(*) FROM table1

but for a table (in a given database), not rows within a table

I know of...