I think your INSERT syntax is wrong. There is no "TABLE" in the syntax.
It has to be INSERT INTO admin VALUES .
- Shanta
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: ENCRYPT Synt
, ensure the number of columns your inserting
match the schema of the table - if not explicitly specify the columns.
Regards,
Adam
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 3:03 PM
To: [EMAIL PROTECTED]
Subject: ENCRYPT Syntax problem
Dear list:
I`m trying to insert some values into my table but I received a error
message when I type::
INSERT INTO TABLE admin VALUES ('admin',ENCRYPT('system'),15,0);
The error said:
Error 1064: You have an error in SQL syntax.
Could someone help me to clarify th
onderneming.rubriek_ID_3 = r3.rubriek_ID
WHERE 1
ORDER BY officiele_naam
LIMIT 100
#1064 - You have an error in your SQL syntax near 'ON onderneming.bedrijfsnummer =
vestiging.bedrijfsnummer
LEFT JOIN rubrieken AS' at line 3
What exactly is the cause of this error here? Could it be that mysql3 does
n
);
#
---
-Mensaje original-
De: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 07 de Octubre de 2003 13:15
Para: 'Miguel Ernesto'
CC: [EMAIL PROTECTED]
Asunto: RE: Check (expr) Syntax and/or other fields checks
Miguel:
Firs
ql.com/doc/en/InnoDB.html>
-Original Message-
From: Miguel Ernesto [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 12:57 PM
To: [EMAIL PROTECTED]
Subject: Check (expr) Syntax and/or other fields checks
Hello everyones,
Did somebody know:
First:
What kind of expr it is a
Title: Mensaje
Hello
everyones,
Did somebody know:
First:
What kind of expr it is
allowed on the check condition on: create table
syntax?
Second:
Is it posible to force
conditional FOREIGN KEY checks?
for example:
We make One table who have one UNIQUE Key and
one
to SELECT columns from several tables
> but I wish MySQL could use the following syntax:
>
> SELECT {several fields} FROM (Table1 UNION Table2 UNION Table3 .
> ) WHERE condition
>
> Currently I think MySQL only supports the following:
>
> (SELECT {several fields} F
Hi Group,
I want to use a UNION in order to SELECT columns from several tables but I wish MySQL
could use the following syntax:
SELECT {several fields} FROM (Table1 UNION Table2 UNION Table3 . ) WHERE condition
Currently I think MySQL only supports the following:
(SELECT {several fields
On Tue, Sep 30, 2003 at 09:36:46PM +0100, Seun Osewa wrote:
> Hi Jeremy,
>
> Hmmm ... I guess the meat of my suggestion is that it be made
> available on a per-transaction basis because in many applications
> some transactions are more "critical" than others. So even on
> systems where there are
- Original message ---
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Date: Tue, 30 Sep 2003 10:17:04 -0700
Subject: Re: Possible Commit Syntax Change for Improved TPS
On Tue, Sep 30, 2003 at 01:19:19PM +0100, Oluwaseun Osewa wrote:
> Hi,
>
> I have been studying the basic limi
On Tue, Sep 30, 2003 at 01:19:19PM +0100, Oluwaseun Osewa wrote:
> Hi,
>
> I have been studying the basic limitation that the number of
> committed transactions per second possible in a relational databases
> is limited by the number of writed per second of the underlying hard
> disk, since ea
Hi,
I have been studying the basic limitation that the number of
committed transactions per second possible in a relational databases
is limited by the number of writed per second of the underlying hard
disk, since each transaction requires at least the write-ahead log data
to be flushed to di
Try taking out the identifier name for the primary key (pk_foo). The
way I read the documentation, MySQL does not support identifiers or
names for primary keys although it does for other index types.
HTH
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
Fortuno, Adam wrote:
All,
I've got an InnoDb table that requires a composit key constraint. However,
I'm not certain how to word the DDL syntax.
Pretending for a sec this was SQL Server 2000 or Sybase ASE 12.5 I'd use the
following.
CREATE TABLE foo(
pri_1 INTEGER NOT NULL,
pri_2 I
All,
I've got an InnoDb table that requires a composit key constraint. However,
I'm not certain how to word the DDL syntax.
Pretending for a sec this was SQL Server 2000 or Sybase ASE 12.5 I'd use the
following.
CREATE TABLE foo(
pri_1 INTEGER NOT NULL,
pri_2 INTEGER NOT NULL,
I need help with the proper syntax of my INSERT
Statement.
I have spoken to the support staff of my RADIUS
Vendor they stated that enable to support SHA
The Coolum for password has to have the encrypted
password prefixed with {SHA} not just the hash
I need to include the literal string of {SHA
password (AES_DECRYPT)
FROM userdata blah blah blah
Something this this
Thanks
Jeff Stout
The syntax for both is the same:
AES_ENCRYPT(string,key_string)
AES_DECRYPT(string,key_string)
See:
http://www.mysql.com/doc/en/Miscellaneous_functions.html
Please note that internals is n
I have added data into MySQL server 4.0.15
INSERT INTO userdata (userid, password)
VALUES ('user', AES_ENCRYPT ("user","password")
I'm having trouble doing the decrypt
SELECT userid, password (AES_DECRYPT)
FROM userdata blah blah blah
S
Hi!
On Sep 07, Sebastian Hoffmann wrote:
> Hello,
>
> I have just updated from MySQL 3.23 to MySQL 4.0.14. My operating
> system is Mac OS X (10.2.6).
>
> I have now encountered an odd problem with some "select" statements
> which appear to work differently in the new version:
>
> I want to d
Sebastian Hoffmann <[EMAIL PROTECTED]> wrote:
>
> I have just updated from MySQL 3.23 to MySQL 4.0.14. My operating
> system is Mac OS X (10.2.6).
>
> I have now encountered an odd problem with some "select" statements
> which appear to work differently in the new version:
>
> I want to do a j
Hello,
I have just updated from MySQL 3.23 to MySQL 4.0.14. My operating
system is Mac OS X (10.2.6).
I have now encountered an odd problem with some "select" statements
which appear to work differently in the new version:
I want to do a join on two tables which are in two different
databases
Hi,
Have a look at:
http://www.mysql.com/doc/en/String_functions.html
You can find there functions to use in SELECT and WHERE clauses, like
UPPER(), LOWER(), SUBSTRING(), etc. and
http://www.mysql.com/doc/en/String_comparison_functions.html
for string comparison functions (LIKE, REGEXP, MATCH
greetings,
When I am doing a select or update statement, I was wondering if there were
functions to compare strings. IE
Select * from employee,emp2 where uppercase(employee.fname)
matches(emp2.fname*)
that is to compare two fields from two tables and see if they match
regardless of whether
one i
that I have never used this syntax to
delete from two tables simultaneously before.
I would like to know if it is meant to work, or if it is a dirty hack,
and whether it is SQL standard, ie. can I use this if I want to run my
app on Oracle? (Not that I do but I might want to sell it to people w
These are tables that I did not design (and would not have in this fashion), but I
have to make do with them
Table 1 structure:
id_num number,
descr1 varchar(30),
descr2 varchar(30),
descr3 varchr(30)
Table 2 structure
id_name varchar(15),
ext_descr varchar(30)
Table 2 is a child of table 1
Hi list:
I have the following partial result from an explain select:
| table| type | possible_keys
| key
27 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Join syntax diff 3.23 to 4.x?
>
>
> Try changing "JOIN list_states " to "INNER JOIN list_states "
>
> Looks like the earlier version didn't like your (synonymous) wording.
>
> >
Doh! You are so right. Thanks for the help. Got so used to not needing the
INNER word that I forgot all about it.
-Original Message-
From: Kevin Fries [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 1:27 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Join syntax diff
Try changing "JOIN list_states " to "INNER JOIN list_states "
Looks like the earlier version didn't like your (synonymous) wording.
> -Original Message-
> From: Jack Dare [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 14, 2003 8:35 AM
> To: [EM
Is there something about 3.23 that makes this illegal? It is fine on 4.012.
SELECT [lots of columns]
FROM new_people p LEFT JOIN new_address ad ON p.address_id = ad.id
JOIN list_states ls ON ad.state = ls.id
WHERE p.company_id = 1
Will some minor rewording help it run on both versions OK?
--
M
the server host.
- Original Message -
From: "Sigurd Urdahl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 3:26 PM
Subject: Check table wildcard syntax?
I need to do CHECK TABLE on a lot of tables (actually on all tables in
several datab
At 16:26 +0200 7/29/03, Sigurd Urdahl wrote:
I need to do CHECK TABLE on a lot of tables (actually on all tables in
several databases), and hoped to do something like
mysql> CHECK TABLE reports.*
which ddn't work. The only thing that seems to work is using
cut'n'paste (or some scritpting)
Hi!
On Jul 29, Sigurd Urdahl wrote:
> "Matthew McNicol" <[EMAIL PROTECTED]> writes:
>
> > The recommended way to quickly check all tables is:
> >
> > myisamchk --silent --fast /path/to/datadir/*/*.MYI
> > isamchk --silent /path/to/datadir/*/*.ISM
>
> I thought the recommended way was using CHEC
ally clear... perhaps
someone else will help out.
4.4.4 CHECK TABLE Syntax
CHECK TABLE works only on MyISAM and InnoDB tables. On MyISAM tables, it's
the same thing as running myisamchk --medium-check table_name on the table.
4.4.6 Using myisamchk for Table Maintenance and Crash Recovery
S
"Matthew McNicol" <[EMAIL PROTECTED]> writes:
> The recommended way to quickly check all tables is:
>
> myisamchk --silent --fast /path/to/datadir/*/*.MYI
> isamchk --silent /path/to/datadir/*/*.ISM
I thought the recommended way was using CHECK/ REPAIR TABLE from
inside mysql for the supported b
uot;Sigurd Urdahl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 3:26 PM
Subject: Check table wildcard syntax?
>
> I need to do CHECK TABLE on a lot of tables (actually on all tables in
> several databases), and hoped to do something like
&g
I need to do CHECK TABLE on a lot of tables (actually on all tables in
several databases), and hoped to do something like
mysql> CHECK TABLE reports.*
which ddn't work. The only thing that seems to work is using
cut'n'paste (or some scritpting) to get a comme seperated list. Is
there rea
--Original Message-
From: Cory Lamle [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 2:40 PM
To: MySQL LIST
Subject: SQL Syntax
Contents are Direct Alliance Corporation CONFIDENTIAL
-
How do you type check in mysql. I have a column of type varchar(20) with
both floats and strings.
At 11:40 -0700 7/22/03, Cory Lamle wrote:
Contents are Direct Alliance Corporation CONFIDENTIAL
-
How do you type check in mysql. I have a column of type varchar(20) with
both floats and strings. Is there a way to check the type?
In this case, the "type" of the column as far as MySQL is concerned
Contents are Direct Alliance Corporation CONFIDENTIAL
-
How do you type check in mysql. I have a column of type varchar(20) with
both floats and strings. Is there a way to check the type?
Example:
Select
If(is_float(col1), 'is a float', 'not a float') as
typ
_info.client_id=client_invoice.client_id) ON
(tax_zones.tax_zone=client_info.client_state) AND
(tax_zones.countries_iso_2=client_info.client_country)
I'm getting the following error: You have an error in your SQL syntax near
'(client_info RIGHT JOIN client_invoice ON client_info.client_id=client_i
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 17, 2003 9:38 PM
> To: Nick Arnett; [EMAIL PROTECTED]
Well, Paul, just knowing you were on the job inspired me and I finally
realized the dumb thing I'd done. The list I'm iterating, urls, comes from
ument (a string) into a TEXT column. I'm getting SQL syntax errors,
as though the document isn't properly escaped, even though I'm using
substitution so that MySQLdb should be taking care of that. I'm wondering
if I'm missing something terribly obvious, because this is dead-
My hair... I am ready to tear it out. I've been working with Python and the
MySQLdb module for a long time, thought I couldn't get snagged by anything,
but today I just can't seem to persuade the blasted thing to let me stick an
HTML document (a string) into a TEXT column. I'
Trevor Sather wrote:
> Hello
>
> The following query used to work when I was using an Access database,
> but now that I've moved to MySQL I get a syntax error when I try and
> run it:
>
> SELECT *, (SELECT COUNT (*)
> FROM Links
> WHERE Links.CAT_ID = Categories
Hello
The following query used to work when I was using an Access database, but
now that I've moved to MySQL I get a syntax error when I try and run it:
SELECT *, (SELECT COUNT (*)
FROM Links
WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS
LINK_COUNT FROM C
Hello All,
What syntax for MySQL should I be looking at to solve a problem like
the following:
3 Tables (oversimplified to show the problem area)
individual.id
individual.name
individual_addresses.individual_id
individual_addresses.address_id
address.id
address.street
Although the structure is
I've found the rpm.
fab a écrit :
Hi and thanx :)
I've found dbf2mysql and it should solve my prob.
However, my linux server is a production server (web + mail) and none
programmation environnement is installed on it (no gcc and so on) and i
don't want to.
So, could anyone send me the binary f
Hi and thanx :)
I've found dbf2mysql and it should solve my prob.
However, my linux server is a production server (web + mail) and none
programmation environnement is installed on it (no gcc and so on) and i
don't want to.
So, could anyone send me the binary for dbf2mysql ?
I use Red-Hat 7.3 on
1 will work.
2 will not work.
3 Use dbf2mysql. ( It should be in the downloads section on mysql.com )
fab wrote:
Hi all,
I'm quite new in mysql. Despite i've read a part of the doc, i can't
fix my prob. Here is my question:
I want to convert a DBASE IV file into mysql table:
1) Have i to convert
Hi all,
I'm quite new in mysql. Despite i've read a part of the doc, i can't fix
my prob. Here is my question:
I want to convert a DBASE IV file into mysql table:
1) Have i to convert the dbf into flat file then use the LOAD DATA
INFILE cmd ?
or
2) Can i directly use the LOAD DATA INFILE cmd w
At 16:22 +0900 6/26/03, Nils Valentin wrote:
Hi MySQL Fans ;-);
Does anybody understand what the QUICK option is doing when used with the
DELETE command ? It says in the manual "..no MERGEing of INDEX leaves during
delete".
Sorry, but I could not make any sense out of this. Could somebody please b
Hi MySQL Fans ;-);
Does anybody understand what the QUICK option is doing when used with the
DELETE command ? It says in the manual "..no MERGEing of INDEX leaves during
delete".
Sorry, but I could not make any sense out of this. Could somebody please be so
kind to enlighten me ?
I guess it i
update is a reserved word in MySQL. Choose another username.
Lian Sebe
Freelance Analyst-Programmer
www.programEz.net
> -Original Message-
> From: Adam Lawrence [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 5:10 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL 4.0.
: Wednesday, June 25, 2003 8:10 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL 4.0.13 GRANT syntax
>
>
> I am attempting to modify the GRANT table using the syntax
> specified in the
> MySQL 4.0.13 documentation, and am getting error messages claiming the
> syntax is inco
On Wed, Jun 25, 2003 at 10:09:58AM -0400, Adam Lawrence wrote:
> I am attempting to modify the GRANT table using the syntax specified in the
> MySQL 4.0.13 documentation, and am getting error messages claiming the
> syntax is incorrect. (I'm running MySQL on Windows 98, by th
I am attempting to modify the GRANT table using the syntax specified in the
MySQL 4.0.13 documentation, and am getting error messages claiming the
syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used
mysqlc with root access.
mysql> USE mysql;
Database changed
mysq
Hello Jeff,
Monday, June 16, 2003, 1:13:27 PM, you wrote:
JS> On Mon, 16 Jun 2003 12:45:53 -0400, Martin's - Web Dept. wrote:
>> I am quite willing to acknowledge that I'm new at this ...
>>
>> But I can't find the syntax error in this query:
>>
&
On Mon, 16 Jun 2003 12:45:53 -0400, Martin's - Web Dept. wrote:
> I am quite willing to acknowledge that I'm new at this ...
>
> But I can't find the syntax error in this query:
>
> SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
>
>
On Mon, Jun 16, 2003 at 12:45:53PM -0400, Martin's - Web Dept. wrote:
> I am quite willing to acknowledge that I'm new at this ...
>
> But I can't find the syntax error in this query:
>
> SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
>
>
I am quite willing to acknowledge that I'm new at this ...
But I can't find the syntax error in this query:
SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
desc is a field name, usb is the keyword I'm searching for.
MYSQL version 4.0.12
Thanks for your
I posted a page containing the reserved words at
http://www.knowd.co.jp/staff/nils/
In case it is of any help for somebody.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 10日 火曜日 11:18、Jim Winstead さんは書きました:
> On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote:
> > SELECT item_n
List" <[EMAIL PROTECTED]>
Sent: Monday, 09 June, 2003 22:18
Subject: Re: Trouble with SELECT AS syntax
On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote:
> SELECT item_name AS name, item_desc AS desc FROM food;
'desc' is a reserved word.
Try:
SELECT i
Jim was faster ;-), ..but I am getting there.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 10日 火曜日 11:18、Jim Winstead さんは書きました:
> On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote:
> > SELECT item_name AS name, item_desc AS desc FROM food;
>
> 'desc' is a reserved word.
>
> T
Hi Edward,
I am not sure which version and OS you are using. I tried it on Suse Linux 8.1
and MySQL 4.1 alpha. I get the same error. It seems that there is a problem
with this part
"item_desc AS desc "
AS a test I modified the definiton of item_desc to the same as the column
item_name, but
On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote:
> SELECT item_name AS name, item_desc AS desc FROM food;
'desc' is a reserved word.
Try:
SELECT item_name AS name, item_desc AS `desc` FROM food;
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://
Despite my review of the manual, I cannot get my SELECT AS statements to work.
Every attempt returns Error 1064. My statements, which appear to be in
accordance with the manual (http://www.mysql.com/doc/en/SELECT.html), are formed
as below. I have included my with my CREATE TABLE record for refer
esn't work and gives me a SYNTAX ERROR. If I use my 'id' column
(the primary key) instead of the 'order' column, it works fine:
mysql_query("SELECT MIN(id), MAX(id) FROM downloads WHERE class='1'");
My columns are defined as follows:
CREATE TABLE downl
Hi... silly question maybe.
I want to execute the following query:
mysql_query("SELECT MIN(order), MAX(order) FROM downloads WHERE class='1'");
...but it doesn't work and gives me a SYNTAX ERROR. If I use my 'id' column
(the primary key) instead o
Hi,
On Mon, Mar 31, 2003 at 03:40:03PM +0100, warm-fusion wrote:
> Hi, I'm just wondering what the right syntax for using the delete
> statement is? I'm trying to write a simple garbage collection/deletion
> query similar to the queries below.
>
>
warm-fusion wrote:
Hi, I'm just wondering what the right syntax for using the delete
statement is? I'm trying to write a simple garbage collection/deletion
query similar to the queries below.
delete from 'item' where 'quantity_of_item_in_stock'
Hi, I'm just wondering what the right syntax for using the delete
statement is? I'm trying to write a simple garbage collection/deletion
query similar to the queries below.
delete from 'item' where 'quantity_of_item_in_stock' <= 10;
(the above version of the
Hello
I use the mysql command line tool quite often and always wondered why
there's no feature that lets me quickly see the syntax of a "FOREIGN
KEY" or "GRANT" command. Now while browsing the source I found the
new "syntax" command in 4.0.12 and got the idea
Hi
AUTO_INCREMENT needs to be an integer, NUMERIC is a decimal?
not 100% sure but it looks like it
Peter
-Original Message-
From: Cesar Baquerizo [mailto:[EMAIL PROTECTED]
Sent: 24 March 2003 20:59
To: MySQL
Subject: CREATE syntax wrong?
Hello,
I am on:
mysql Ver 11.18 Distrib
helps
Roger
-Original Message-
From: Cesar Baquerizo [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 3:59 PM
To: MySQL
Subject: CREATE syntax wrong?
Hello,
I am on:
mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686)
Is there any reason the following should not work:
CREATE
Hello,
I am on:
mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686)
Is there any reason the following should not work:
CREATE TABLE category
(
category_id NUMERIC NOT NULL AUTO_INCREMENT,
category_name VARCHAR(40),
description VARCHAR(80),
PRIMARY KEY (category_id)
) TYPE=MyISAM;
I
table.
>
>Regards,
>
>Sal
>
>
>> -Original Message-
>> From: MySQL [mailto:[EMAIL PROTECTED]
>> Sent: 12 March 2003 22:33
>> To: MySQL
>> Subject: UPDATE syntax help
>>
>>
>> Hi all, I am having a little UPDATE synt
Hi
I may be way off base here but - why do you reference IMPORT_USERS in your
UPDATE statement? You aren't updating any columns in that table.
Regards,
Sal
> -Original Message-
> From: MySQL [mailto:[EMAIL PROTECTED]
> Sent: 12 March 2003 22:33
> To: MySQL
> Su
Gerald R. Jensen wrote:
> I just ran your query (create and both inserts), and it
> worked like a charm on a Win32 MySQL 3.23.52.
>
> Just out of curiousity, why are putting the \r in?
>
Gerald (and all who were interested),
I didn't put the \r in, actually...mysqldump did. The solution to the
Tab,
>> file). Anyway, it can't help to try the following:
>> C:\mysql\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql
> Thanks, I'll try that... But in the meantime, is there something I can
> do to get Mysql to show me more information about
2003 10:51 AM
Subject: Import Batch syntax error
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with
I have been having a similar problem with a backup file from a phpBB forum
errors keeping showing a syntax error which from what you are all suggesting is
the size of the sql, is that correct?
Andrew
>-Original Message-
>From: Stefan Hinz [mailto:[EMAIL PROTECTED]
>Sent: 20 Marc
t;
> Regards,
Thanks, I'll try that... But in the meantime, is there something I can
do to get Mysql to show me more information about the syntax error? I
think that the difference in the parser might be causing my line-numbers
to be off. I went into my text editor and replaced the lin
Tab,
>> Are you running this from a script? Maybe it's just a script
>> timeout which would stop with the following line when it gets the
>> timeout:
> Oops, no sorry for all those who don't know where I left off yesterday
> (tee hee).. This is an import of a .sql file being run from the command
Stefan Hinz wrote:
>
> Are you running this from a script? Maybe it's just a script
> timeout which would stop with the following line when it gets the
> timeout:
Oops, no sorry for all those who don't know where I left off yesterday
(tee hee).. This is an import of a .sql file being run from th
Tab,
> On Thursday 20 March 2003 18:51, Tab Alleman wrote:
>> Still trying to get all the way through my import batch file.
>>
>> Now I'm getting a syntax error on a certain line of the file, and a
>> subsequent run produced the same exact error on the same exact l
On Thursday 20 March 2003 18:51, Tab Alleman wrote:
> Still trying to get all the way through my import batch file.
>
> Now I'm getting a syntax error on a certain line of the file, and a
> subsequent run produced the same exact error on the same exact line, but
> I can'
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with that line.
Here's the line that produces the
do everything I need to
do.
Now - I am trying to connect my database to coldfusion (create the data
source) and that is pretty straight forward. So the ONLY thing I can think
of is that I am fudging my user id's when I create them in mysql. SO.. I
just want to double check this syntax with
connect my database to coldfusion (create the data
source) and that is pretty straight forward. So the ONLY thing I can think
of is that I am fudging my user id's when I create them in mysql. SO.. I
just want to double check this syntax with all of you to make sure I created
the user in such a way
"Andy Eastham" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED] Mysql. Com" <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 10:14 AM
Subject: RE: UPDATE syntax help
> Paul,
>
> You have to use the results of one select to generate lots of update
> statements.
cript file with your code (or
directly from SQL if you're a martyr) and then run it.
I've used both methods successfully,
Andy
> -Original Message-
> From: JJ [mailto:[EMAIL PROTECTED]
> Sent: 12 March 2003 23:45
> To: MySQL
> Cc: Paul DuBois
> Subject: Re: UPD
s" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 9:02 AM
Subject: Re: UPDATE syntax help
At 8:33 +1000 3/13/03, MySQL wrote:
>Hi all, I am having a little UPDATE syntax issue. According to th
That explains it then D'OH
Is there a workaround?
Thanks :-)
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 9:02 AM
Subj
At 8:33 +1000 3/13/03, MySQL wrote:
Hi all, I am having a little UPDATE syntax issue. According to the manual
According to the manual, this won't work until MySQL 4.x
UPDATE EBA_USERS, IMPORT_USERS
SET EBA_USERS.HUB_ID = IMPORT_USERS.HUB_ID,
EBA_USERS.REP_LOCATI
Hi all, I am having a little UPDATE syntax issue. According to the manual
UPDATE EBA_USERS, IMPORT_USERS
SET EBA_USERS.HUB_ID = IMPORT_USERS.HUB_ID,
EBA_USERS.REP_LOCATION_ID = IMPORT_USERS.REP_LOCATION_ID,
EBA_USERS.REP_FIRST_NAME = IMPORT_USERS.REP_FIRST_NAME,
EBA_USERS.REP_LAST_NAME
At 21:41 -0600 3/9/03, Charles Lewis wrote:
I was reading somewhere that MySQL 4.1 UPDATE syntax will allow
update to table with values from another table in the following
manner:
update client, zip
set client.st = zip.st, client.city = zip.city
where client.zip = zip.zip;
Is there a creative
I was reading somewhere that MySQL 4.1 UPDATE syntax will allow update to
table with values from another table in the following manner:
update client, zip
set client.st = zip.st, client.city = zip.city
where client.zip = zip.zip;
Is there a creative way to do this in 4.0.11?
chas
At 9:45 -0600 3/8/03, Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Description:
It is unbelievable that the MySQL ver 4.0 have so many bug, I
have been reported 2 bugs just a few days ago.
Now, I have found a bug again.
The bug is :
When I execute
501 - 600 of 1024 matches
Mail list logo
