| 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 |
| jbalint | wtf... |
| 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 |
| tanker2003 | k thanks using lik phpmyadmin export the tables? |
| shabbs | or mysqldump god, some people are impatient |
| jbalint | ANSWER ME NOW |
| shabbs | yes |
| 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 |
| KevinOman | hmm ok |
| 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 |