So, anyone know why this fails? I'm making a exact copy of the
structure of a table and then putting a known good entry into it and
then trying to copy it back. At worst, it should give a duplicate key
error. But instead it gives a "Column count" error.

Query OK, 0 rows affected (0.17 sec)

1;
Query OK, 1 rows affected (0.17 sec)

Column count doesn't match value count at row 1

Thanks much to anyone that can advise.

-> ;
+---------------------+---------------------+------+-----
+---------------------+----------------+
| Field | Type | Null | Key |
Default...

This is what I want:

SELECT acol1 from aTable
WHERE (acol0='x' and acol1='jack')
OR (acol0='x' and acol1='jill')
OR (acol0='x') limit 1;

That is, I want 'jack' if he meets the second criterion, 'jill'
if he fails but she doesn't, and if they're both out I'll take
anyone who does meet it.

The above select doesn't care about my priorities and just picks the
first acol0 that satisfies any of the OR's.

What do I want to write?

thanks, --thelma

I'm using mysql v 5.0.51. The database is on my host server at ipower.com.
I cannot get UPDATE write to the database.
I know it's something is my code - I'm a total novice to databases in
general. I've opened the database within the same .php file, I display data
just fine. Can't update from the code, though. Using the same user, I AM
able to update using the host's online phpmyadmin. So, can you help me with
my code? Here it is:
I open the db and table with this,

$host = "host_name";
$db = "dbEvents";
$user = "dbAdmin";
$password = "secret";
"mysql_connect ($host, $user, $password) or die ("Cant open the db because:
" . mysql_error() );
mysql_select_db ($db);
$query = mysql_db_query($db, "SELECT * FROM announcementsTable order by
idx"); $record = mysql_fetch_array($query);"

I can read all the records and their fields.

I build a table of each record where I edit the record in a (very
abbreviated) form: "title" is a field name, it's data is assigned to
"TitleName".
"while ($results = mysql_fetch_array($query)) {
...

I am having to recreate some apps after the ones I created several years
ago were destroyed. One (common) problem was creating a new record in a
related table if one doesn't already exist to update. I don't remember
how I was doing it before, but in researching I came across INSERT ...
ON DUPLICATE KEY UPDATE and REPLACE. They both seem to be able to do
what I need. Am I wrong? Can anyone tell me the difference?

Hi Experts,

New to MySQL,

I have a txt file that has all the information to build a new database
in MySQL code that works, but i only want to create the database if it
doesn't exist, (part of a bigger problem)

i can see i need to use CREATE DATABASE and the IF NOT EXIST commands,
but i can't see any literature on importing the text file for the
schema i want.

Can anyone help with this?

Cheers

Mike

Within CentOS-5.2 Linux we have installed mysql-5.0.45.7.elf and
mysql-server-5.0.45.7.elf.

What gui frontends are available to build and populate databases and to
design the gui query forms to get information back out as desired, please?

I am looking at moving some old database systems to MySQL and I am
currently working on data loading using mysqlinport.

I have an issue with dates as all the data that is coming my way has
dates in DD/MM/YYYY. the load routines look to only accept it in
YYYY/MM/DD.

Is there anyway of telling the routines to use the European date format?

Would be nice if it could display dates in the format as well.

I did find a variable called "data_format" in the online documentation,
however, it said that it was no-longer used.

THanks.

Don

I am building an app for a restaurant. The restaurant has multiple
menus. When the user comes to a page for a specific menu I need to
pull all item data from multiple database tables. There are multiple
categories of items, each item falls under a category. Some categories
have items that fall into sub categories.

I posted my database tables and a basic sample of the output below. I
know how to do this and it is easy if I create one huge table, but due
to the amount of data I am working with I need to make sure that this
is put together as efficiently as possible.

Is it possible to combine all of this into one SQL statement? Can
anyone offer a better way to make this work? Any thoughts would be
greatly appreciated. Thanks in advance.

I have three tables:

I have a user account with privilege:

GRANT USAGE ON `edgar`.`edgar` TO 'downside'@'localhost' WITH GRANT OPTION

How do I revoke this specific privilege?

I've tried, as database root,

REVOKE ALL PRIVILEGES on edgar.edgar FROM downside@localhost;

and the command is accepted, but SHOW GRANTS still shows the grant above.

I tried

REVOKE USAGE on edgar.edgar FROM downside@localhost;

which is also accepted, but has no visible effect.

I finally had to do

REVOKE ALL PRIVILEGES, GRANT OPTION FROM downside@localhost;

which also revoked other stuff I didn't want to revoke.

GRANT and REVOKE are supposed to be symmetrical, but they don't quite seem to be.

John Nagle

Is it possible to pick up information from a MySQL database using a
macro in Excel?

Don