= p.productid
AND o.status = 'new'
ORDER BY o.date DESC , o.status, u.username
GROUP BY o.orderid
LIMIT 0 , 30
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'GROUP BY o.orderid
- Original Message -
From: "Scott Yamahata" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 29, 2006 1:29 AM
Subject: SQL syntax
Hi, I'm getting the following error message:
You have an error in your SQL syntax; check the manual that corresponds to
your MyS
Hi Scott, all,
Scott Yamahata wrote:
Hi, I'm getting the following error message:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ' enabled
= '1'' at line 3INSERT INTO clf_cit
n use the following query.. do not leave the value of column
blank.
INSERT INTO clf_cities SET cityname = 'Santa Barbara', countryid =NULL ,
enabled = '1'
Thanks,
ViSolve DB Team
- Original Message -
From: "Scott Yamahata" <[EMAIL PROTECTED]>
Hi,
have you checked the 'enabled' field datatype or can you give the query.
Thanks
ViSolve DB Team.
- Original Message -
From: "Scott Yamahata" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 29, 2006 11:59 AM
Subject: SQL syntax
Hi, I'm getting th
Hi, I'm getting the following error message:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ' enabled = '1''
at line 3INSERT INTO clf_cities SET cityname = 'Santa Barbara',
Field was wrongly named - Cheers!
--
View this message in context:
http://www.nabble.com/Syntax-Problem-tf2779708.html#a7756233
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
> I have a query running within a project from a Windows machine retrieving
> data from a Linux Source the query works perfectly. If i upload the exact
> same project to the Linux machine and run it the query doesnt work ??!!??
>
> the query string is ...
>
> SELECT DISTINCT ID, BatchID FROM Conta
am i going mad ?
Cheers
JugLugs
--
View this message in context:
http://www.nabble.com/Syntax-Problem-tf2779708.html#a7755229
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-
From: "Ted Yu" <[EMAIL PROTECTED]>
To:
Sent: Thursday, November 30, 2006 9:13 AM
Subject: before update trigger syntax
Can someone tell me what's wrong with my before update
trigger syntax ?
Thanks
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQ
Can someone tell me what's wrong with my before update
trigger syntax ?
Thanks
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 19 to server version:
5.0.18-log
mysql> use eventtracker;
Reading table information for completion of table and
column n
006 10:18 AM
> To: mysql@lists.mysql.com
> Subject: Invalid syntax with STD() function when more than one field is
> used in select query
>
> Hello,
>
> I am encountering a strange issue when using the STD function. On my
> local development machine (MYSQL version 4.18-nt
my hosted production machine (MYSQL version
4.19-standard) that query results in an invalid syntax error:
"#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '(
`LAPSETIME` ) ,
.mysql.com
From: Chris White <[EMAIL PROTECTED]>
Subject: Re: Problem With Join Syntax
On Wednesday 14 June 2006 10:55 am, Albert Padley wrote:
A typical set of data looks like this:
id | inputfieldid | userid | value
1 1 2 John
2 2 2 Sm
2006, Chris White wrote:
> To: mysql@lists.mysql.com
> From: Chris White <[EMAIL PROTECTED]>
> Subject: Re: Problem With Join Syntax
>
> On Wednesday 14 June 2006 10:55 am, Albert Padley wrote:
> > A typical set of data looks like this:
> >
> > id | inputfi
Dan,
Thanks. I'll take a further look at GROUP_CONCAT.
Albert
On Jun 14, 2006, at 1:16 PM, Dan Buettner wrote:
Albert, MySQL's GROUP_CONCAT function might work for you:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
In your case something like this:
SELECT userid, GROUP_CON
Albert, MySQL's GROUP_CONCAT function might work for you:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
In your case something like this:
SELECT userid, GROUP_CONCAT(value)
GROUP BY userid
HTH,
Dan
Albert Padley wrote:
I have the following table schema in MySQL 4.1.18 which I
On Wednesday 14 June 2006 10:55 am, Albert Padley wrote:
> A typical set of data looks like this:
>
> id | inputfieldid | userid | value
> 1 1 2 John
> 2 2 2 Smith
> 3 3 2 [EMAIL PROTECTED]
>
> I am trying to come up with a query
I have the following table schema in MySQL 4.1.18 which I didn't
create, but have to work with.
CREATE TABLE `phplog_userinput` (
`id` int(11) NOT NULL auto_increment,
`inputfieldid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`value` varchar(150) NOT NULL defau
Gerald,
- Original Message -
From: "Gerald L. Clark" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Thursday, June 08, 2006 8:40 AM
Subject: Re: correct syntax
Mike Blezien wrote:
Hello,
we need to query
Mike Blezien wrote:
Hello,
we need to query one of database tables that sore usernames, and many of
them have spaces in them that need to be removed. what would be the
correct function to identify each username column value that has a
space(s) in them?
TIA,
Mike(mickalo)Blezien
How abou
Hello,
we need to query one of database tables that sore usernames, and many of them
have spaces in them that need to be removed. what would be the correct function
to identify each username column value that has a space(s) in them?
TIA,
Mike(mickalo)Blezien
--
MySQL General Mailing List
F
At 15:19 +0100 7/6/06, Rob Desbois wrote:
With the CHANGE clause of ALTER TABLE statement, you must provide
the column definition, so something like this is what you need:
ALTER TABLE actors CHANGE director_id actor_id MEDIUMINT UNSIGNED NOT NULL;
or whatever your original definition is.
Wo
bject: ERROR 1064 (42000): You have an error in your SQL syntax;
Hi All,
gee I really hate bugging you all for this. I looked at this page,
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
which has this,
To change column |a| from |INTEGER| to |TINYINT NOT NULL| (leaving the name
the
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1
Sorry, little confused right about now, eh. Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: h
At 0:09 +1000 8/6/06, Mark Sargent wrote:
ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);
for changing the name of a column, right? So, why doesn't the below work?
mysql> ALTER TABLE actors CHANGE director_id actor_id;
I'm no great expert myself, but off the top of my head, may
your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1
Sorry, little confused right about now, eh. Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
sheeri kritzer wrote:
MySQL usually gives a syntax error *where* the error happens. In this
case, it would indicate a problem with "SEC_TO_TIME(" but there
shouldn't be a problem, both according to the manual AND according to
my example.
The parser reads the query left-to-r
.1/en/date-and-time-type-overview.html
this is the way to SUM the total time, which keeps producing a syntax
error and figure out why
MySQL version 4.1.12
---
SELECT c.account_id,a.name,a.company,
S
Hi Sheeri,
Is your 'u.modified' column a TIME datatype '00:00:00'
Mike
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Wednesday, May 17, 2006
.uid where
u.modified >= DATE_SUB(NOW(),INTERVAL 14 DAY) and country="au" group
by u.uid having mins >= '2' order by mins;
Similar joins, similar where clause, etc and yet I got an answer
(almost 700 rows, took 2 seconds) while you got a syntax error.
select @@version;
-time-type-overview.html
this is the way to SUM the total time, which keeps producing a syntax error and
figure out why
MySQL version 4.1.12
---
SELECT c.account_id,a.name,a.company,
SEC_TO_TIME(SUM(T
Hi Johan,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.sql > outfile.txt
"outfile.txt" it looks something like:
"OrderID", "Quant", "OrdrDate", "code1", "code2"...
10021, 12, 20060412, 23, 95...
10022, 5, 20060412, , 75...
But, I
Hi,
Where should I increase max_allowed packet??
I get a error from Windows (yes, I know... it's running on a M$-os, not
my bad - not my desicion).
The results is about 2 - 10 Gb of data.
Regards,
/Johan
Dilipkumar wrote:
Hi,
Increase max_allowed packet to 1.5 gb and then try to import you
ist [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 10:16 AM
To: mysql@lists.mysql.com
Subject: Outfile syntax and out of memory
Hi,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.sql > outfile.txt
"outfile.txt" it
al Message-
From: Johan Lundqvist [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 10:16 AM
To: mysql@lists.mysql.com
Subject: Outfile syntax and out of memory
Hi,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.sql
Hi,
Increase max_allowed packet to 1.5 gb and then try to import your data .
eg ;
In mysql prompt run the file as
*use database
\. /tmp/filename.txt
*
Johan Lundqvist wrote:
Hi,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.
Hi,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.sql > outfile.txt
"outfile.txt" it looks something like:
"OrderID", "Quant", "OrdrDate", "code1", "code2"...
10021, 12, 20060412, 23, 95...
10022, 5, 20060412, , 75...
But, I never g
Hi Mark.
On Fri, 7 Apr 2006, Mark Sargent wrote:
> To: mysql@lists.mysql.com
> From: Mark Sargent <[EMAIL PROTECTED]>
> Subject: Syntax Error
>
> Hi All,
>
> am trying to get up to speed on cli syntax again,
>
> mysql> show open tables from osc
> ->
Hi All,
Ah, sorry, a semicolon makes it a whole new world, eh.
Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
am trying to get up to speed on cli syntax again,
mysql> show open tables from osc
->
what is wrong with the command above and the one below,
mysql> show tables from osc
->
Why do I not get any output? I was following here,
http://dev.mysql.com/doc/refman/5.1/
EY `name_title_timestamp` ( `cur_namespace` , `cur_title` ,
> `inverse_timestamp` ) ,
> KEY `user_timestamp` ( `cur_user` , `inverse_timestamp` ) ,
> KEY `usertext_timestamp` ( `cur_user_text` , `inverse_timestamp` ) ,
> KEY `namespace_redirect_timestamp` ( `cur_namespace` , `cur_is_red
, `inverse_timestamp` ) ,
KEY `namespace_redirect_timestamp` ( `cur_namespace` , `cur_is_redirect`
, `cur_timestamp` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 PACK_KEYS =1 AUTO_INCREMENT
=1028;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that
>Create table events (
>uid BIGINT NOT NULL AUTO_INCREMENT,
>name VARCHAR(255),
>start_date DATE,
>duration INTEGER,
>location_id BIGINT,
>primary key (uid)
>);
>
>Create table locations (
>uid BIGINT NOT NULL AUTO_INCREMENT,
>name VARCHAR(255),
>address VARCHAR(255),
>primary key (uid)
>)
>
>Alter
I ran into some syntax over the weekend, that I am trying to make sense
of. Here is the create table statements.
Drop table if exists events
Drop table if exists locations
Create table events (
uid BIGINT NOT NULL AUTO_INCREMENT,
name VARCHAR(255),
start_date DATE,
duration INTEGER
On 24/03/2006 11:06 a.m., Eric Beversluis wrote:
Can someone illustrate the correct syntax for using auto_increment in
making a table? I've studied the manual and I'm not seeing how it comes
out.
EG:
CREATE TABLE Books (
bookID INT(5) PRIMARY KEY AUTO_INCREMENT...
THEN WHAT?
Can someone illustrate the correct syntax for using auto_increment in
making a table? I've studied the manual and I'm not seeing how it comes
out.
EG:
CREATE TABLE Books (
bookID INT(5) PRIMARY KEY AUTO_INCREMENT...
THEN WHAT?
Thanks.
EB
--
MySQL General Mailing List
For lis
bobgoodwin wrote:
I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning
exercise for me!
I am using O'Reilly's MYSQL Cookbook, have gone through numerous
pages of the "reference manual" and stuff on Google but still can get
the proper commands and
I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning
exercise for me!
I am using O'Reilly's MYSQL Cookbook, have gone through numerous pages
of the "reference manual" and stuff on Google but still can get the
proper commands and syntax to alter the follo
ortion of the original query contained several
tables that were implicitly cross joined by commas. Eric will need to use
parentheses in order to change the order of operations (the join sequence)
to include one of his comma-listed tables first or he will need to rewrite
his query to use the exp
On 2/20/06, Eric Persson <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a query which works fine for me in my 4.1 environment, but when
> moved to the 5.0.18 environment, it fails with the result below:
>
> mysql> SELECT r.uid, u.username, u.image_type, count(id) AS antal,
> s.timestamp FROM recruits_
2006/2/20, Eric Persson <[EMAIL PROTECTED]>:
> Hi,
>
> I have a query which works fine for me in my 4.1 environment, but when
> moved to the 5.0.18 environment, it fails with the result below:
>
> mysql> SELECT r.uid, u.username, u.image_type, count(id) AS antal,
> s.timestamp FROM recruits_uid r,
Hi,
I have a query which works fine for me in my 4.1 environment, but when
moved to the 5.0.18 environment, it fails with the result below:
mysql> SELECT r.uid, u.username, u.image_type, count(id) AS antal,
s.timestamp FROM recruits_uid r, users u, users u2 LEFT JOIN sessions s
ON s.uid=u.ui
Rhino wrote:
First and foremost, thank you very much Michael for correcting my
mistakes; I _was_ a bit sloppy in my reading of the syntax for the
statements and that caused some unnecessary errors in my reply to Scott.
However, your corrections are not _quite_ right even now. See below
where
foremost, thank you very much Michael for correcting my
mistakes;
> I _was_ a bit sloppy in my reading of the syntax for the statements and
that
> caused some unnecessary errors in my reply to Scott.
>
> However, your corrections are not _quite_ right even now. See below
First and foremost, thank you very much Michael for correcting my mistakes;
I _was_ a bit sloppy in my reading of the syntax for the statements and that
caused some unnecessary errors in my reply to Scott.
However, your corrections are not _quite_ right even now. See below where I
explain
if you do this:
CREATE TABLE Foo
...
constraint (bar) foreign key(workdept) references Sample.department
on delete cascade
...
That's not quite right. There should be no parentheses around the symbol, but
you do need parentheses around the referenced column. The syntax is
database, so I looked up the syntax to do the same
thing in MySQL and came up with this small example:
=
use tmp;
create table Purcell01
(empno smallint not null,
fname char(10) not null,
lname char(10) not null,
primary key(empno)
co
Hello,
I have created some tables a while back, and of course, and I am
learning, I have found problems with duplicate entries and other
problems.
So upon a fresh read of the 5.1 docs, I am trying to understand the word
"symbol" after the constraint.
I would like to be able to somehow comb
> I think I really misunderstood the directions for alter table, an I'm
> not sure how to fix this. I was trying to allow certain columns to be
> null in an existing table.
> I used the following syntax:
> ALTER TABLE users ALTER COLUMN title SET DEFAULT NULL;
> Now
I think I really misunderstood the directions for alter table, an I'm
not sure how to fix this. I was trying to allow certain columns to be
null in an existing table.
I used the following syntax:
ALTER TABLE users ALTER COLUMN title SET DEFAULT NULL;
Now 'describe users;' show
Hi,
I'm porting a D-ISAM application to Mysql. My idea is to emulate ISAM
calls with the HANDLER syntax. But I wish to make sure that performance
will be at least as good as direct ISAM calls. Then I did some tests,
scanning a simple table containing 6000 records with a small C pr
wangxu wrote:
>Follow is my preform and result:
>-
>mysql> backup table ht_detail to '/';
>+++--+--+
>| Table | Op | Msg_type | Msg_text
---
-Original Message-
From: wangxu [mailto:[EMAIL PROTECTED]
Sent: Thursday, 5 January 2006 1:29 PM
To: mysql@lists.mysql.com
Subject: an backup syntax error
Follow is my preform and result:
-
mysql
Follow is my preform and result:
-
mysql> backup table ht_detail to '/';
+++--+--+
| Table | Op | Msg_type | Msg_text |
+-
Hello.
Please, could you provide the CREATE statement for you tables
and describe the relationships between their fields (it will
be good if you include sample data as well).
Matthew Batt wrote:
> Hi
>
> I need to update the 'products_id' field (shown below) by copying data
> from
Hi
I need to update the 'products_id' field (shown below) by copying data from
a separate table but I can't use the 'UPDATE' query as each 'product_id'
entry relates to a specific 'products_model' row.
id / assembly_no / products_id / products_model
1 / 2313 / *** / CASEACERENTRY2
2 / 2313 /
2005 8:12 AM
To: mysql@lists.mysql.com
Subject: LOAD DATA INFILE Syntax
Hi mysql-list,
I just installed,
++
| version() |
++
| 5.0.16-log |
++
Here is what I am testing out: (simple table and data)
% echo 'a b c d' > testfile
mysql> CREATE
Hi mysql-list,
I just installed,
++
| version() |
++
| 5.0.16-log |
++
Here is what I am testing out: (simple table and data)
% echo 'a b c d' > testfile
mysql> CREATE TABLE `test` (
-> `fe` VARCHAR( 2 ),
-> `fi` VARCHAR( 2 ),
-> `fo` VARCHAR( 2
Michael Immerman <[EMAIL PROTECTED]> wrote on 11/25/2005 11:52:47 AM:
> I have a query that works perfectly in version 4.1.10a-nt however it
> fails in version
>4.0.24. If someone has any ideas on how to fix the query to run
> in 4.0.24, I would really appreciate it! Thanks - code below:
>
I have a query that works perfectly in version 4.1.10a-nt however it fails in
version
4.0.24. If someone has any ideas on how to fix the query to run in 4.0.24,
I would really appreciate it! Thanks - code below:
Select
ibiBillMth,ibiBillYear,meter,ibiTotChg,id,userid,ibiDaysInBilling
never mind - found the paragraph in the manual..
The |SQL SECURITY| characteristic can be used to specify whether the
routine should be executed using the permissions of the user who creates
the routine or the user who invokes it. The default value is |DEFINER|.
This feature is new in SQL:200
Am I understanding this correctly?
SQL SECURITY DEFINER...
DEFINER - make sure the person who wrote this procedure had the
authority/permissions to do everything in it and runs or not based on that,
INVOKER - make sure the person who uses this procedure has the
authority/permissions to do ever
Rhino wrote:
- Original Message -
From: Ed <mailto:[EMAIL PROTECTED]>
To: mysql@lists.mysql.com <mailto:mysql@lists.mysql.com>
Sent: Tuesday, October 25, 2005 6:40 PM
Subject: Problem with syntax 4 creating 1 table
Shawn green was very kindly he
- Original Message -
From:
Ed
To: mysql@lists.mysql.com
Sent: Tuesday, October 25, 2005 6:40
PM
Subject: Problem with syntax 4 creating 1
table
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had go the hang
,
`int_Quantity` INT,
`int_saleCart` PRIMARY KEY ( int_saleCart )
) ENGINE = MYISAM
MySQL said: Documentation
|#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'PRIMARY KEY ( int_saleCart )
) ENGINE = MYISA
,`int_saleCart` PRIMARY KEY ( int_saleCart ) ) ENGINE = MYISAM
MySQL said:
#1064 - You have an error in your SQL
syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to use near 'PRIMARY KEY ( int_saleCart ) )
ENGINE = MYISAM' at line 6
He
Hello.
Unfortunately, you can bind only to a single specific address.
Daniel Schaerli wrote:
> Hi,
>
> How is the sintax to in my.cnf listen only to specified ip-addresses or
> ip-ranges? I tried:
> bind_address 127.0.0.1 192.168.0.10 192.168.0.20
> and
> bind_address 127.0.0.1, 19
Hi,
How is the sintax to in my.cnf listen only to specified ip-addresses or
ip-ranges? I tried:
bind_address 127.0.0.1 192.168.0.10 192.168.0.20
and
bind_address 127.0.0.1, 192.168.0.10, 192.168.0.20
and
bind_address 127.0.0.1 192
bind_address 192.168.0.10
bind_address 192.168.0.20
Non of them wo
http://dev.mysql.com/doc/mysql/en/delete.html
...
Multiple-table syntax:
DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
tbl_name[.*] [, tbl_name[.*] ...]
FROM table_references
[WHERE where_definition]
Or:
DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
FROM tbl_name[.*] [, tbl_name
Hi,
I need to know the syntax I can use for a certain delete statement. This is
the idea:
- A table with users, which has at least these fields, a user id field and a
field containing its status (active, disabled, review).
- A table that links certain users to each other, containing at least
Anybody have an idea why I might be getting the following message:
ERROR 1064 (0): You have an error in your SQL syntax near
'('hello','password')' at line 1
When I type this in at the command line:
SELECT AES_ENCRYPT('hello','password'
Incoming from Paul DuBois:
> At 18:50 -0600 10/2/05, s. keeling wrote:
> >
> >Groan. More stuff to learn, configure, maintain, and memorize. I'm
> >trying to replicate Unix's "root vs. mere user" security paradigm in
>
> I think your analogy is flawed. If you really want the root vs mere
> user
At 18:50 -0600 10/2/05, s. keeling wrote:
Incoming from Paul DuBois:
At 16:39 -0600 10/2/05, s. keeling wrote:
>
>The admin account, with no password, doesn't function at all. perl
>programs appear to ignore ~/.my.cnf forcing me to open() them and
>slurp username and password that way.
>
Incoming from Paul DuBois:
>
> At 16:39 -0600 10/2/05, s. keeling wrote:
> >
> >The admin account, with no password, doesn't function at all. perl
> >programs appear to ignore ~/.my.cnf forcing me to open() them and
> >slurp username and password that way.
> >
> >How is this supposed to work? Su
I think I'd probably set up aliases that invoke mysql or mysqladmin
with a --defaults-extra-file option that contains the username/password
for the appropriate account.
At 16:39 -0600 10/2/05, s. keeling wrote:
I've checked everywhere I can find (Paul DuBois' MySQL, ML archives,
dev.mysql.com,
I've checked everywhere I can find (Paul DuBois' MySQL, ML archives,
dev.mysql.com, my local User Group) for this, but everything I find
either describes a simplistic or far more complex case. This is all
on my local box, no networking required, and I'm the only one
accessing the data. I've four
|
> >> | LOCTYPE | varchar(10) | YES | | NULL | |
> >> | COUNTY | int(11) | YES | | NULL | |
> >> | CTRLAT | float | YES | | NULL | |
> >> | CTRLNG | float | YES | | NULL | |
> >> +-+-+--+-+-++
> &
I've been over that page before posting, with no luck. It might be an
obvious error in syntax, but I can't figure it out.
Jason
On 9/26/05, Robert L Cochran <[EMAIL PROTECTED]> wrote:
>
> http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
>
> Bob Cochran
>
&
| NULL | |
| LOCTYPE | varchar(10) | YES | | NULL | |
| COUNTY | int(11) | YES | | NULL | |
| CTRLAT | float | YES | | NULL | |
| CTRLNG | float | YES | | NULL | |
+-+-+--+-+-++
And here is the error I get:
ERROR 1064 (42000): You have an
RROR 1064 (42000): You have an error in your SQL syntax; check the manual
that
corresponds to your MySQL server version for the right syntax to use near
'@d,@d
,LOCNAME,LOCTYPE,@d,STATE,COUNTY,@d,@d,LNG,LAT,@d,@d,@d,@d,@d,@d,@d,@d)' at
line
5
This error is driving me nuts! Any help would b
OUNTY | int(11) | YES | | NULL | |
| CTRLAT | float | YES | | NULL | |
| CTRLNG | float | YES | | NULL | |
+-+-+--+-+-++
And here is the error I get:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that
corresponds to you
:[EMAIL PROTECTED]
> Sent: Friday, September 02, 2005 11:48 AM
> To: Barbara Deaton
> Cc: mysql@lists.mysql.com
> Subject: Re: Where exists query syntax error?
>
>
>
>
> "Barbara Deaton" <[EMAIL PROTECTED]> wrote on 09/02/2005 11:33:19
AM:
>
> &g
: Where exists query syntax error?
"Barbara Deaton" <[EMAIL PROTECTED]> wrote on 09/02/2005 11:33:19 AM:
> I need help re-writing a query.
>
> When accessing DB2 I can execute the below:
> delete from DM_KOHLS.clr_plan_price_change_metrics A
&g
005' ) and
> exists ( select * from SESSION.delete_table_tmp B
>where A.clr_plan_sk = B.clr_plan_sk)
>
>
> I modified it to be what I thought was a valid MySQL statement but
> when I execute it against MySQL I get a syntax e
t was a valid MySQL statement but when I
execute it against MySQL I get a syntax error:
ERROR: Execute error: You have an error in your SQL syntax. Check the manual
that corresponds
to your MySQL server version for the right syntax to use near 'exists (
select * from
dele
Hi,
> In the MySQL Docs at
> http://dev.mysql.com/doc/mysql/en/drop-view.html, it
> says:
>
> "RESTRICT and CASCADE, if given, are parsed and
> ignored."
>
> I am not sure if I understood this?
Easy, you can specify "restrict" or "cascade", but MySQL
does absolutely nothing with it.
With regards
Hello,
In the MySQL Docs at
http://dev.mysql.com/doc/mysql/en/drop-view.html, it
says:
"RESTRICT and CASCADE, if given, are parsed and
ignored."
I am not sure if I understood this?
Regards,
karam
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has
Good issue, I totally had the same concerns, so we built our own
system. As a side note we run an admin server which we use to
generate reports, run backups and so on - it takes load off the
production servers, where speed is critical. Recovery from backup
however is a whole other issue, an
David Ulevitch wrote:
On Jul 12, 2005, at 6:15 AM, gerald_clark wrote:
Nightly backup and binlogs can take you to any point in the day.
I failed to make my entire point clear then. That's true.
But when someone does the "oh fsck, I think I just ran a catastrophic
query on our productio
101 - 200 of 1024 matches
Mail list logo
