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: 'SELECT * FROM tbl LIMIT 1,5
Unsigned
What does it mean declaring a table unsigned? An example is a s below: id smallint unsigned not null auto_increment
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? -- http://ngBot.com | http://wap.ngBot.com Nigeria's #1 website directory.
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 instance, if i run a full text search of "foo bar" against a table like the simulated one below: title | Comment + row a | bar bar bar row b | foo bar row a will be relevated against row b probably coz bar occurs thrice. how can i fine tune the search so that it relevates according to the precense of keywords.
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 empty result even if there is a result in the url and/or title column. how can i get around tis? - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com - Yahoo! DSL Something to write home about. Just $16.99/mo. or less
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: the script and the txt file movies.txt reside on the same directory. runnign the page, i get the error: The used command is not allowed with this MySQL version my mysql version is 4.2.2 what could be wrong? by the way, i'v tried changing the movies file path to a full path but still doesnt change things. - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com - Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
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: the script and the txt file movies.txt reside on the same directory. runnign the page, i get the error: The used command is not allowed with this MySQL version my mysql version is 4.2.2 what could be wrong? by the way, i'v tried changing the movies file path to a full path but still doesnt change things. - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com - Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
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.
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.
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 Rekindle the Rivalries. Sign up for Fantasy Football
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 __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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 selected statement for an index table? - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com - Do you Yahoo!? Yahoo! Small Business - Try our new resources site!
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 selected statement for an index table? - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com - Do you Yahoo!? Yahoo! Small Business - Try our new resources site!
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 - Do you Yahoo!? Yahoo! Small Business - Try our new resources site!