#mysql - Sun 20 May 2007 between 00:06 and 01:59

kestasif I run a SELECT query that has a LIMIT on it
is there any way to find out how many rows *would* have been returned if I hadn't put the LIMIT on?
KevinOmanhow do I set a password on a database
fastfingerusing phpmyadmin is easy way
shabbs!m KevinOman grant sy
the_wenchKevinOman see http://dev.mysql.com/doc/refman/5.0/en/grant.html
shabbsKevinOman: you don't set a password on a database, you give users access as you see fit
wyvvHi. I've got a table with a CompletionDate datetime column. and a series of TaskID's in it. I need to order by the minimum dates but still group by the task ids, and select all the rows rather than just grouping.
I've tried this
select * from actions order by TaskId IN(SELECT TaskID FROM actions group by TaskID order by min(CompletionDate))
it doesn't seem to really do the job though.
jbalint!m wyvv order by
the_wenchwyvv see http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
wyvvhm so hard to explain
tanker2003i am trying to recover data off a drive, i can see the data files, how can i back up the sql db's?
is it possible?
shabbstanker2003: if you're looking at actual .myd, myi etc files you need to have a running sql server to extract the data from it
tanker2003k thanks
using lik phpmyadmin export the tables?
shabbsor mysqldump
god, some people are impatient
jbalintANSWER ME
jbalintas i expected
perljunkieI have a table and I want to delete all rows past 2000, how do I do that with a query ?
shabbsdelete from table where id > 2000; though I'd run the same where clause with a select and see if it's what you want deleted
perljunkieshabbs: the id is quite random
I delete records out constantly
KevinOmanif I set a password for mysql, is that setting a password for all my databases or do I need to set a password for each database
hax_you set a password for each user
and grant the users access to whatever databases or tables or whatever
KevinOmanhax_: so if im setting up a phpbb forum and it asks for the database name and the password, I use mysql password
hax_KevinOman: there is no 'mysql password'
KevinOman: you create a mysql user, that has access to the database you want, and you give that user a password
KevinOmanhmm ok
shabbsperljunkie: it doesn't matter what order they're in. if you want everything over 2000 to go, you use WHERE yourfield > 2000 (I assumed you were using the id earlier)
perljunkieshabbs: There might be 1600 records between 1 and 2000. that is the problem with that

Page: 2 9 16 23