Hello Neil,
On 8/24/2013 5:21 AM, Neil Tompkins wrote:
I have the following four MySQL tables
Region
RegionId
City
CityId
RegionId
Hotel
HotelId
CityId
HotelRegion
HotelId
RegionId
I'm struggling to write a UPDATE statement to update the City table's
RegionId field from data in the HotelReg
I have the following four MySQL tables
Region
RegionId
City
CityId
RegionId
Hotel
HotelId
CityId
HotelRegion
HotelId
RegionId
I'm struggling to write a UPDATE statement to update the City table's
RegionId field from data in the HotelRegion table.
Basically how can I update the City table with
t.com/products/mascon
> -Original Message-
> From: "Luciano Pulvirenti" <[EMAIL PROTECTED]>
> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> CC:
> Subject: Serious error in update Mysql 4.1.7
> Sent: Fri, 03 Dec 2004 08:18:05 GMT
> Receive
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> This tells the recipient's email client that your message is
> a reply, not a new message, despite your efforts to change the subject and
> recipients. Many email clients use that header to decide which thread a
me
On Wednesday 06 October 2004 02:10 pm, Scott Hamm wrote:
> Like I said before it "seems" to group by "threads". Therefore, it is
> close enough.
Right! thats why Microsoft thrives. Because as long as it appears to work, its
all good.. :)
Jeff
pgpAXe4d5h6QD.pgp
Description: PGP signature
Hey folks.
Apparently I need to say it again: this discussion is off-topic for this
mailing list. Please either let it die or take the discussion off-list.
Thanks.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
Like I said before it "seems" to group by "threads". Therefore, it is close
enough.
-Original Message-
From: Michael Satterwhite [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 3:05 PM
To: [EMAIL PROTECTED]
Subject: Re: update MySQL
-BEGIN PGP SIGN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 05 October 2004 14:39, Scott Hamm wrote:
> Jeff,
>
> If you sort it by conversation topic, then it will seem to group by
> "threads".
> I'm running Outlook 2000.
Not the same thing. Threading uses the "In-reply-to" header. Messages wi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 05 October 2004 14:23, David Brodbeck wrote:
> Well, that's nice...
>
> I just don't see what difference it makes. As far as I can see, the
> outcome is identical either way...
If the recipients email program threads messages, it makes a b
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 05 October 2004 15:18, Ed Lazor wrote:
> Also, back to my original question, what are you seeing that denotes the
> difference between whether I reply or create a new message when starting a
> new topic? After all, I took care of changing
> Ed,
>
> When you *reply* to a message, most mail clients (including yours) add a
> header
> like this:
>
>In-Reply-To: <[EMAIL PROTECTED]>
>
> That stuff in between the < and > is the message-id of the replied-to
> message.
>
> This tells the recipient's email client that your message is
Ed Lazor wrote:
-Original Message-
Actually its proper email etticate.. look it up if you don't believe me..
That sounds like a copout. Could present formal references to back this up?
I'm trying to substantiate your claims, but a Google search failed to bring
up anything relevant when s
Outlook 2003 here and its working just like Scott's (Converation, Subject,
etc.).
> -Original Message-
> If you sort it by conversation topic, then it will seem to group by
> "threads".
> I'm running Outlook 2000.
>
> Cause your doesnt support threads.. Outlook was the only one I k
> -Original Message-
> Actually its proper email etticate.. look it up if you don't believe me..
That sounds like a copout. Could present formal references to back this up?
I'm trying to substantiate your claims, but a Google search failed to bring
up anything relevant when searching wit
Hi.
This discussion is very off-topic for this list. Please take the
discussion of how to use your email client off-list.
Thanks.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tuesday 05 October 2004 02:39 pm, Scott Hamm wrote:
> If you sort it by conversation topic, then it will seem to group by
> "threads".
> I'm running Outlook 2000.
Seem.. Thats the key word.. Its not true threading support..
These are not there for looks..
References:
<[EMAIL PROTECTED]>
I
Jeff,
If you sort it by conversation topic, then it will seem to group by
"threads".
I'm running Outlook 2000.
Scott
-Original Message-
From: Jeff Smelser [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 05, 2004 3:36 PM
To: [EMAIL PROTECTED]
Subject: Re: up
On Tuesday 05 October 2004 02:23 pm, David Brodbeck wrote:
>
> Well, that's nice...
Hmm
> I just don't see what difference it makes. As far as I can see, the
> outcome is identical either way...
Cause your doesnt support threads.. Outlook was the only one I knew off that
did not.
Jeff
pgp1r
> -Original Message-
> From: Jeff Smelser [mailto:[EMAIL PROTECTED]
> On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote:
>
> > Saves having to retype the list address, or look it up. I
> don't see what
> > difference it makes...
>
> Click on the email, on mine, it brings up a n
On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote:
> Saves having to retype the list address, or look it up. I don't see what
> difference it makes...
Click on the email, on mine, it brings up a nice to empty message with the
email address..
Jeff
pgp50O9uZVT4t.pgp
Description: PGP si
On Tuesday 05 October 2004 01:55 pm, you wrote:
> We're not perfectionist like you. :)
Actually its proper email etticate.. look it up if you don't believe me..
Jeff
pgpjB48FEXyL0.pgp
Description: PGP signature
> -Original Message-
> From: Jeff Smelser [mailto:[EMAIL PROTECTED]
> Whats the deal and this list? No one can ever just hit new
> message, they
> always hit reply and put a new subject in..
Saves having to retype the list address, or look it up. I don't see what
difference it makes...
We're not perfectionist like you. :)
> -Original Message-
> From: Jeff Smelser [SMTP:[EMAIL PROTECTED]
> Sent: Tuesday, October 05, 2004 2:23 PM
> To: [EMAIL PROTECTED]
> Subject: Re: update MySQL
>
> On Tuesday 05 October 2004 01:14 pm, Ed Lazor wrote:
You're close. I hit reply to all, typed in a new subject, and then modified
the To field by removing all but the [EMAIL PROTECTED] address.
Come to think of it, I'm hitting reply on this message as well.
What difference are you seeing that makes this significant?
-Ed
> -Original Message--
On Tuesday 05 October 2004 01:14 pm, Ed Lazor wrote:
> Does anything need to be done to my data while upgrading the server from
> 3.23 to 4.0.21?
Whats the deal and this list? No one can ever just hit new message, they
always hit reply and put a new subject in..
Geez.. This list is horrible with
Does anything need to be done to my data while upgrading the server from
3.23 to 4.0.21?
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I currently update MySQL rows using phpMyAdmin.
For example, dropping the following into the
phpMyAdmin GUI:
UPDATE mysql_db SET publish = 1 WHERE Date =
'Sunday, August 15, 2004 21:04:32'
Since I get the update info in an e-mail send
whenever the form is submitted, I'd like to t
I'd like to modify the email send I presently get
from the Perl script when a new record is
submitted from the form to contain an email link
which if I click on it, will update MySQL.
Anybody know how that might best be done and if
so, can you please advise?
Many thanks in advance,
Cc: [EMAIL PROTECTED]
Subject: Cannot Update MYSQL Database
I'm running this code with no errors but it's not inserting the string
into the database ?
public void addInfo( String referer )
throws SQLException, Exception {
if (con != nul
I'm running this code with no errors but it's not inserting the string
into the database ?
public void addInfo( String referer )
throws SQLException, Exception {
if (con != null) {
try{
PreparedStatement updateInfo;
updateInfo =
On Friday 20 December 2002 22:08, John Chang wrote:
> I e-mailed the list but haven't received a response. I have win2k w/
> 3.23.53 and need to update it to 54. Is there a patch or do I have to do a
> reinstall or install on top of it?
You can just install 3.23.54 over 3.23.53, but backup of t
I e-mailed the list but haven't received a response. I have win2k w/
3.23.53 and need to update it to 54. Is there a patch or do I have to do a
reinstall or install on top of it?
mysql
-
Before posting, please check:
http://
Can anyone confirm that it is *not* possible to pass a list to the Python
MySQLdb module in UPDATE operations? In other words, this kind of thing
works:
self.dbh.execute("INSERT INTO Foo (blah, blorg,snork) VALUES
(%s,%s,%s)",myList)
... But this kind doesn't appear to work for me:
self.dbh.ex
Hi,
didn't really understand what you are asking.. Can you please be more
specific? What exactly you are asking?
Gurhan
-Original Message-
From: Valerie Brooks [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 5:28 PM
To: [EMAIL PROTECTED]
Subject: update mysql database vi
Hi,
I'm using php form to update mysql database, the form has several drop down
menus to choose from. What would the best way of updating information in the
database, update, as a function? Any help will be greatly appericated.
T
If you compiled it did you use --with-mysql?
On February 28, 2002 01:30 pm, you wrote:
> I just reinstalled the latest version of php on my system and after doing
> so the pages that existed within the site no longer allow records to be
> updated in MySQL, records that updated fine before. Any i
Hi.
That's too few information to say anything concrete. Do you get any
error message? If not, please look how to enable error messages in PHP
(or change your script to log them). Then post the error message you
get.
Bye,
Benjamin.
On Thu, Feb 28, 2002 at 02:30:20PM -0500, [EMAIL PROT
Which PHP version did you update to? I have noticed in PHP 4.1.1 is
more anal about syntax
-Original Message-
From: Vernon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 1:30 PM
To: php-list; MySQL-list
Subject: After php udate, php pages no longer update MySQL database
[mailto:[EMAIL PROTECTED]]
Sent: 28 February 2002 19:30
To: php-list; MySQL-list
Subject: After php udate, php pages no longer update MySQL database
I just reinstalled the latest version of php on my system and after doing
so the pages that existed within the site no longer allow records to be
I just reinstalled the latest version of php on my system and after doing
so the pages that existed within the site no longer allow records to be
updated in MySQL, records that updated fine before. Any ideas why or how
to fix?
Thanks
-
I get this error when trying to update a record using ASP recordsets.
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
/Web_local/admin/xt_save.asp, line 39
What is rea
> Question is there something wrong with this syntax when using the MYSQL
> Update command in PHP , where I change the record by users editing the
> fields on a web form then those are extracted to update a record in a
> table.
> Here's what I have tried I don't get any syntax errors with either
> $query1 = "UPDATE Qusers SET $field_str WHERE UserName='$username'";
> $result2 = mysql_query($query1);
It should be:
update Qusers set field_name='$field_str' where username='$username'";
-
Before posting, please check:
ht
Question is there something wrong with this syntax when using the MYSQL
Update command in PHP , where I change the record by users editing the
fields on a web form then those are extracted to update a record in a
table.
Here's what I have tried I don't get any syntax errors with either of
these
At 09.42 11/06/01 +0200, Francesco Marchioni wrote:
>Hi all,
>I'd like to update my version of Mysql on linux.
>How can I do it so that I don't have two copies of mysql on my machine ?
>Do I have to clean up the folder "mysql" and then install the new version
>under it?
I suggest you to dump all
Hi all,
I'd like to update my version of Mysql on linux.
How can I do it so that I don't have two copies of mysql on my machine ?
Do I have to clean up the folder "mysql" and then install the new version under it?
And what should I download -the source code or the binaries- in order to
update th
46 matches
Mail list logo
