March 18, 2003 8:02 AM
Subject: [MySQL] InnoDB - Updating a parent table won't update the child
table
> Hi all,
> I created 2 tables in MySQl with the following statements
> ==
> CREATE TABLE employees (
> emp_id INT
Hi all,
I created 2 tables in MySQl with the following statements
==
CREATE TABLE employees (
emp_id INT NOT NULL AUTO_INCREMENT,
emp_last_name TINYTEXT NOT NULL,
emp_first_name TINYTEXT NOT NULL,
emp_nick_name TINYTEXT
Hi,
> The table sitesats won't update and shows no errors! (even though there are
> two instances of echo(mysql_error()))
>
>
>
> if (!isset($areview)) {
> echo("You must review the site"); } else {
> if (!isset($apositive)) {
> echo("You must review the site"); } else {
> if (!isset($anegati
Will the update statement work under the mysql prompt?
- Original Message -
From: "Vladimir Kravtsov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2001 8:39
Subject: Table won't update
The table sitesats won't update and shows n
Here are some ideas for an improved debugging methodology.
First, take the query that you think should be working, substitute in
hard-coded values, and test it through the mysql command-line
client interface.
So, for example, run the "update sitesats set..." query and use
hard-coded values for $
The table sitesats won't update and shows no errors! (even though there are two
instances of echo(mysql_error()))
Any ideas?