#mysql - Mon 2 Apr 2007 between 01:02 and 01:45

NY Lost Funds



trhaynesLoRez: Would you mind explaining that real quick? Why "1" in the count() ?
And will that give me distinct artists or should I put a "distinct" in there, too?
LoReztrhaynes: distinct, yes. 1 is an optimization that keeps it from pulling record data.
trhayneshow does it know what you count?
*what to count
whatever it's grouped by?
LoRezyes
trhaynesLoRez: Thank you so much. Do you know of any good tutorials that teach these kind of more advanced MySQL things
?
LoReznot really off hand, I've gotten most of my stuff from experience
trhaynesLike I know you can do a lot of really cool stuff just with SELECT statements using the advanced functions
LoRez: Cool. Did you hear about the netflix MySQL challenge thing?
LoRezyeah
nikinhy again.... i ame trying now to use the mysql-query browser, but if i press backspace, the program dies with Gtk-ERROR **: Char offset 2 is off the end of the line
sgsaxcan anybody help me with alter view syntax?
_RainMkr_sgsax: DROP the view and recreate it.
psynapticI'm on os x and I need an ssh client to login to a remote server and interact with mysql.. does anyone know a good os x ssh client?
sgsaxeven if all I want to do is modify the definer?
_RainMkr_psynaptic: It comes with ssh
psynapticI can use bash?
_RainMkr_sgsax: Ah, that I think you do, but I always just drop and recreate
psynaptic: yes
sgsaxI'm just the admin, one of my users has a broken definer value
psynapticthanks I'll look for a tutorials
tutorial
the_wenchMySQL Tutorial: http://www.mysql.com/doc/en/Tutorial.html SQL Tutorial: http://www.sqlcourse.com
psynaptichehe
sgsaxright now, I'm editing the raw .frm files, but I'm sure there's a better way
and I thought alter view was it, but I can't seem to get the syntax right
chadmaynardsgsax: at least the manual page is really indepth and explains everything </sarcasm>
sgsaxexactly :)
here's what I've tried: alter view blah definer='user'@'host';
and: alter view definer='user'@'host' blah;
Guest59471logical question, lets say i have a search select * from table where field='A', and it pulls up 1000 results, I limit the results to 100 when I display it to people. now I have a field where id=555 and i want to modify the limit x,x of my query to show that perticular field, either first or last or in there somewhere. anyone recommend any logical methods to do this?
sgsaxand: alter definer='user'@'host' view blah;
chadmaynardGuest59471: if you modify the search string or whatever you'll have to go back to the beginning i suppose. To 'refine' results i suppose you use a temp table? I'm not sure though... never done it. May be a better method
doolsGuest59471: you'd need to include OR id=555 in your clause
Guest59471dools, that doesn't maintain the search order
basically this is the age old forum - thread - post question
you want to view a post in a random section of a thread

Page: 1 8 15 22 29 36 43 50 57 64 71 

IrcArchive

NY Lost Funds