Way of declaring variables?

Got the snippet from the mysql website: select @last := last_insert_id() i av the hunch that is to assign the variable 'last' to the last_insert_id(). Im i right? is placing @ before a word mysql's way of declaring variables? what's the work of the colon preceeding the equal sign? --

Unsigned

What does it mean declaring a table unsigned? An example is a s below: id smallint unsigned not null auto_increment

on select statements

what is the difference between this: SET @a=1; PREPARE STMT FROM 'SELECT * FROM tbl LIMIT ?';EXECUTE STMT USING @a; and this: 'SELECT * FROM tbl LIMIT 1 And then this: SET @skip=1; SET @numrows=5; PREPARE STMT FROM 'SELECT * FROM tbl LIMIT ?, ?'; EXECUTE STMT USING @skip, @numrows; and this:

Fultext search issues

Using the full text function to run a search stunt on a table. all seem working fine except im looking for ways to fine tune the table relevance. i found out that the function relevates a row higer by the number of keywords found in it and not by if all keywords is present in the row... for

Alter table

one of my table columns is unique. i mean cant av duplicate contents. How do i remove this?

Getting execute time

How do I get the time it took a sql statement to execute?

full text table query issues

using the a sql statement like ds: select *, match(url, title, comment) against ('movies') as score from dir where match(url, title, comment) against ('movies') where dir is a fulltext table of url, titlke and comment i however found out that if the comment column is empty it will return an

load data infile

i'm having a problem with the load data infile command...i'm actually running the script from a php script that goes this way: ?php mysql_connect(localhost, $user, $pass); mysql_select_db(ng); $sql = load data local infile 'movies.txt' into table dir fields terminated by '|'; if($res =

load data infile

i'm having a problem with the load data infile command...i'm actually running the script from a php script that goes this way: ?php mysql_connect(localhost, $user, $pass); mysql_select_db(ng); $sql = load data local infile 'movies.txt' into table dir fields terminated by '|'; if($res =

Talking Limit

Talking limit, does it limit the search result after ordering according to relevancy and the likes, or before? thanks - Click here to donate to the Hurricane Katrina relief effort.

Talking Limit

Talking limit (in select query), does it limit the search result after ordering according to relevancy and the likes, or before? thanks - Click here to donate to the Hurricane Katrina relief effort.

Concorrent users

Hi all, just want to know if there is a specific number of concorent users dat can query from a mysql databasee at d same time. - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com - Yahoo! Sports

SQL_BIG_RESULT

learnt SQL_BIG_RESULT in the select syntax builds a temporary table on the result (if I'm right). What will the Select statement to access such temporary table look like? - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com

Index table query structure

If for example I have a table with the 3 columns: name,age,sex I build an index table on the column 'name'. how can i get result of the other rows (i.e age and) from the main table if i 'select' a name from the main table? In short, what is the structure(or should i say syntax?) of a

Index table query structure

If for example I have a table with the 3 columns: name,age,sex I build an index table on the column 'name'. how can i get result of the other rows (i.e age and) from the main table if i 'select' a name from the main table? In short, what is the structure(or should i say syntax?) of a

table types

hi list, im a newbie around here. i'v gone through some parts of the mysql documentation. however, i'd like to know the meaning of spatial, clustered and unique table types. or is it column types? - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com