| pepsiaddict | maybe find DISTINCT column? |
| snoyes | Arepie: If BIT_LENGTH returns a non-0, it's not empty. pepsiaddict: without providing some explicit order, there's no guarantee of results. |
| jorvis | when importing a large SQL file via 'source' from the mysql shell I keep getting packet size errors. I don't have control over the server instance, so I can't increase it there. Can I make the 'source' command use smaller packets? |
| pepsiaddict | hm |
| kidk | snoyes: Sorry by the way, I got called away on the phone earlier but your 'ignore' thing worked. Cheers. |
| snoyes | groovy |
| tASE | what would be a select to select `index` where `last_ip` between `ipstart` and `ipend`, but index and last_ip are in a diff table than `ipstart` and `ipend` ? $char TRIX wrong chan |
| snoyes | SELECT index FROM tablea JOIN tableb ON tablea.last_ip BETWEEN tableb.ipstart AND tableb.ipend; |
| tASE | thanks yay works gvood |
| Arepie | $sql = 'SELECT BIT_LENGTH( image ) FROM category WHERE id = '.$_GET['id']; it doesnt work |
| the_wench | hits Arepie with a return value, "FIND A NEW CAREER" |
| snoyes | doesn't work |
| the_wench | Doesn't work is not a helpful statement. Was there an error? Unexpected results? Does it sit on the couch all day eating all your cheetos and ignoring the classifieds? Be specific! |
| Arepie | as i tried the output of the $sql.. and tried it manually.. it works.. there's no error.. owhh perhaps is does hold on |
| brickbrite | i was going to vote for the cheetoes option |
| Arepie | it get this as the output: Resource id #7 |
| testmania | is there a way to recover data if i deleted the data in a table? |
| snoyes | Arepie: You need to use the appropriate mysql_fetch_* function. |
| Karamon | Would this be the correct syntax for a UNIQUE clause -- SELECT * FROM `foo` WHERE `id` = 'bar' AND UNIQUE `ip` -- if not what would be the best way to do this? |
| seekwill | There is no UNIQUE clause |
| snoyes | SELECT DISTINCT * FROM `foo` WHERE `id` = 'bar'; would work. |
| seekwill | Could work. |
| Karamon | Well, I should have been more clear, let me pastebin my current query so my question is a little clearer |
| seekwill | :) |
| liri | would anyone volunteer to give a hand in constructing some sql queries for a freeradius application I'm working on? |
| seekwill | Too bad we don't support pastebins anymore |
| Karamon | Can I use a different one? |
| snoyes | of course |
| Karamon | Why did you guys get rid of yours? |
| snoyes | spammers pastebin |