Re: Another Rank Amateur Question

2003-01-21 Thread Sean Burlington
Stephen Tiano wrote: The manual I was able to download, I now notice, is for version 4.0.3-beta of MySQL. So that's the official tutorial I'm working. That and Kevin Yank's Building a Database-Driven Web Site Using PHP and MySQL--a '10-week course' that I also was able to download. Problem has

Re: What is the best known practice for insertion...?

2003-01-20 Thread Sean Burlington
Daevid Vincent wrote: This may be useful to you: http://www.mysql.com/doc/en/REPLACE.html replace works very nicley and is IMO a good extension to standard SQL another way that may be suitable is to delete first and then insert (this may erase data if you are not inserting all columns) ---

Re: Potential Customer - Technical Questions

2003-01-20 Thread Sean Burlington
Hi, you might want to ask the sales people some of these questions, this is a users mailing list ... Question 4: What are the appropriate fees associated with purchasing mySQL as a programming company who would use mySQL as its database in its applications. Mysql is available under two li

Re: UPDATE 1 Column from merging 2 or more others

2002-12-11 Thread Sean Burlington
Andrew Kuebler wrote: If Column1 has a value of "John" And Column2 has a value of "Doe" How would I write an UPDATE query to SET Column3 to "John Doe" without selecting the information and reposting it to the data through an UPDATE for each and every record? I've tried: UPDATE $table SET Column