|kestas||if 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?
|KevinOman||how do I set a password on a database|
|fastfinger||using phpmyadmin is easy way|
|shabbs||!m KevinOman grant sy|
|the_wench||KevinOman see http://dev.mysql.com/doc/refman/5.0/en/grant.html|
|shabbs||KevinOman: you don't set a password on a database, you give users access as you see fit|
|wyvv||Hi. 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_wench||wyvv see http://dev.mysql.com/doc/refman/5.0/en/alter-table.html|
|wyvv||hm so hard to explain|
|tanker2003||i 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?
|shabbs||tanker2003: if you're looking at actual .myd, myi etc files you need to have a running sql server to extract the data from it|
using lik phpmyadmin export the tables?
god, some people are impatient
|jbalint||as i expected|
|perljunkie||I have a table and I want to delete all rows past 2000, how do I do that with a query ?|
|shabbs||delete 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|
|perljunkie||shabbs: the id is quite random|
I delete records out constantly
|KevinOman||if 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
|KevinOman||hax_: 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
|shabbs||perljunkie: 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)|
|perljunkie||shabbs: There might be 1600 records between 1 and 2000. that is the problem with that|