Is this sql legal?

[Kagey]

when using mySQL, is it possible to do the following insert:

INSERT INTO address(state_id, name, email)
VALUES( (SELECT state_id FROM states WHERE abbreviation = 'WC'), 'Joe Blow', '[email protected]');

where i get the id from the "inner" querry.

is this legal or s there a better way of doing it?

oh and another thing, what is concidered to be the proper and best way to document a function and a class?

[filburt1]

MySQL 3.x doesn't support nested queries, so it's not legal. The CVS for MySQL 4 should.

[filburt1]

Originally posted by Kagey
oh and another thing, what is concidered to be the proper and best way to document a function and a class?

I used to document things Javadoc-style:

/**
 * Does stuff.
 *
 * @param somearg Used in the function for stuff.
 * @return Whatever somearg is
 */
function dostuff($somearg)
{
    return $somearg;
} 

Now, if I comment the function at all, I just do:

function dostuff($somearg)
// Returns $somearg
{
    return $somearg;
} 

Obviously there's no right or wrong way of doing it, it's your preference.

[Kagey]

thats for the imput filburt

[scoutt]

Originally posted by filburt1
MySQL 3.x doesn't support nested queries, so it's not legal. The CVS for MySQL 4 should.

better go back to reading Arien. mysql3.xx suppurts it.

http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html

[Kagey]

so my statement above would work right?

[scoutt]

should, did you try it. the worse thing that will happen is it will error out

[filburt1]

Originally posted by scoutt

better go back to reading Arien. mysql3.xx suppurts it.

http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html

Bull dude, tried this:

SELECT SQRT(SELECT 9)

Simple, but doesn't work. It hurls on the other SELECT.

[filburt1]

mysql> SELECT SQRT(SELECT 9);
ERROR 1064: You have an error in your SQL syntax near 'SELECT 9)' at line 1
mysql> SELECT SQRT('SELECT 9');
+------------------+
| SQRT('SELECT 9') |
+------------------+
|         0.000000 |
+------------------+
1 row in set (0.00 sec)

mysql> SELECT SQRT("SELECT 9");
+------------------+
| SQRT("SELECT 9") |
+------------------+
|         0.000000 |
+------------------+
1 row in set (0.00 sec)

mysql> SELECT SQRT(9);
+----------+
| SQRT(9)  |
+----------+
| 3.000000 |
+----------+
1 row in set (0.00 sec)

[scoutt]

what format is that

SELECT SQRT(SELECT 9)


select what from what. you didn't tell mysql what teh hell you are doing.

[filburt1]

Originally posted by scoutt
what format is that

SELECT SQRT(SELECT 9)


select what from what. you didn't tell mysql what teh hell you are doing.

SELECT may also be used to retrieve rows computed without reference to any table. For example:

mysql> SELECT 1 + 1;
-> 2

Still SELECT 9 works too, it outputs "9".