| NatureTM | you mean for remote desktop logins? |
| craigbass1976 | is there a way to select and then insert the data into another table all in one go? What's the process called? |
| seekwill | !m craigbass1976 insert select |
| the_wench | craigbass1976 see http://dev.mysql.com/doc/refman/5.0/en/insert-select.html |
| craigbass1976 | Yep, I jsut foudn it. DIdn't realize it was a Doh! thing. :) |
| Chris8494 | hmm - I found a log file under mysql data folder, but I cannot read it |
| Marupa | Could someone please explain further upon what jwl007's attempt to explain to me? |
| craigbass1976 | Marupa, were you in bash alst night? |
| Marupa | yeah. |
| craigbass1976 | Ok, thought you looked familiar |
| Marupa | hehe |
| craigbass1976 | It was the capital M that gave you away... |
| theacolyte | I may be riding the shortbus here but, I'm working on installing the reqs for Groundwork, and it says you have to install MySQL-shared-pro.. I've never heard of that package, have you? |
| Chris8494 | Marupa - if I understand what you are trying to do, it seems like you are trying to do a short-cut version of what I do |
| Marupa | I dunno what you're trying to do, so dunno. |
| Chris8494 | I get a row, load the values into the vars, output the vars, then get the next row, in a loop on the query |
| Marupa | yep exactly what I want to do. And I _know_ there's a way to shortcut it. |
| Chris8494 | well, good luck with that ;-) I opersonally think that the long way is more readable, thus more maintainable -o yo |
| yo | hi people, I have a simple question. |
| Chris8494 | or rather, yo yo ;-) |
| Marupa | eh. I just make 'readable' via comments :3 |
| THC4k | so just a quick question, is there a *fast* way to get the number of rows in a database? |
| snoyes | SELECT COUNT(*) FROM table; is fast for MyISAM. |
| Chris8494 | select count(1) from <table> |
| yo | hehe, how can I INSERT into a field "password" with MD5? |
| Chris8494 | count(1) will not bother reading the columns ;-) |
| THC4k | doh i totally forgot about count -.- thanks guys |
| snoyes | INSERT INTO table SET password = MD5('something'); |
| yo | ohh, thanks so I can UPDATE it the same way? |
| Chris8494 | snoyes - that's good - gonna have to make a note of that one... |
| yo | Thanks snoyes cya later guys |
| seekwill | snoyes: I wonder if you leave out the WHERE, will people blindly follow... haha nevermind My eyes must be hurting if I'm reading INSERT as UPDATE |