Re: newbie needs help

2006-07-21 Thread Mark Maunder
While this is offtopic, just a side note: You probably want to store your images on disk with the filename in the database rather than the actual image binary data in the db. Filesystems are very good at storing and retreiving chunks of binary. Databases do it because... well... I'm not really su

Re: newbie needs help

2006-07-21 Thread Kay C. Tien
At 04:22 PM 7/21/2006 Friday, Scott Haneda wrote: > I'm going throught some tutorial about uploading and displaying > images files. But the display script isn't working. Here's what I have: I think you may want to bring this to a php based list, not a mysql one. Yes, it's cross-posted. I j

Re: newbie needs help

2006-07-21 Thread Scott Haneda
> I'm going throught some tutorial about uploading and displaying > images files. But the display script isn't working. Here's what I have: I think you may want to bring this to a php based list, not a mysql one. -- - Scott Haneda

RE: newbie needs help: can I "order by" before "grouping"?

2003-08-06 Thread Kevin Fries
I don't know of any way to sort before the grouping. That would be peculiar, since the GROUP will be eliminating potentially many of those rows. In your case, a simple solution should be: select jobnum, min(milestone), min(shipdate) from jobs group by jobnum order by 2, 3; I've always found it

Re: Newbie needs help - RESOLVED

2003-07-11 Thread Chris McCue
I opened mysql.sql in BBEdit and ran the Zap Gremlins command, and there were 3+ Gremlins in front of every field name on that line. Upon removal of the gremlins, it reads the file fine. Weird, no? On Friday, July 11, 2003, at 09:32 AM, Chris McCue wrote: I am trying to automate importing fres

Re: newbie needs help please

2001-07-23 Thread Paul DuBois
At 11:07 PM -0500 7/23/01, Kit Kerbel wrote: >Is the foreign key functional is the newest version of Mysql? If so, how does Not according to the MySQL manual: http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html >it work. Also, how would I go about synchronizing an auto_increment >field fr

Re: newbie needs help setting paswords

2001-05-05 Thread Rene Tegel
On Sat, 5 May 2001 14:11:24 -0700 "Daniel Goldin \(E-mail\)" <[EMAIL PROTECTED]> wrote: > I'bve been following SAM'S TEACH YOURSELF MYSQL and hit a glitch. Whenn I do > what I'm told to do create passwords here's what happens > > prompt> insert into user (host, user, password) values('localhost'

Re: newbie needs help setting paswords

2001-05-05 Thread Thalis A. Kalfigopoulos
On Sat, 5 May 2001, Daniel Goldin (E-mail) wrote: > I'bve been following SAM'S TEACH YOURSELF MYSQL and hit a glitch. Whenn I do > what I'm told to do create passwords here's what happens > > prompt> insert into user (host, user, password) values('localhost', 'myname' > password('testpass'); >