optionText='Not at all, I\'m waiting for the
other shoe to drop' where (pollID='34' AND voteID='3');
When I hit Enter, it gives me this prompt:
'
And nothing I input will do anything. I end up having to exit with CTRL-C or
CTRL-D. I know this is probably a simple syntax issue, but what am I
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 9:31 AM
To: [EMAIL PROTECTED]
Subject: UPDATE syntax dummy question...
Howdy,
I'm trying to perform an update on a php poll table.
Here is the table description:
mysql describe vbooth_data
I input will do anything. I end up having to exit with CTRL-C or
CTRL-D. I know this is probably a simple syntax issue, but what am I doing
wrong?? And what is mysql looking for with that ' prompt? Thanks!
Matthias
Howdy Matthias,
update vbooth_data set optionText='Not at all, I'm waiting for the other
shoe
to drop' where (pollID='34' AND voteID='3');
When I hit Enter, it gives me this prompt:
'
Two things:
1 (the ) is because it is waiting for the end of the string - you have an
apostrophe opening
:
update vbooth_data set optionText='Not at all, I'm waiting for the other
shoe to drop' where (pollID='34' AND voteID='3');
When I hit Enter, it gives me this prompt:
'
And nothing I input will do anything. I end up having to exit with CTRL-C
or CTRL-D. I know this is probably a simple syntax
On Tue, 2002-09-03 at 16:31, Matthias Trevarthan wrote:
And here is my update query:
update vbooth_data set optionText='Not at all, I'm waiting for the other shoe
to drop' where (pollID='34' AND voteID='3');
When I hit Enter, it gives me this prompt:
'
This prompt indicates you did
on update query ?
From the syntax, it's ok for me :D
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.361 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt
This may be a truly dumb question, but could someone please tell me why
this sql query/ statement does not work:
update CompanyContacts
set ByEmailAddress = '[EMAIL PROTECTED]'
where Description like '%marve%'
If I say:
select * from CompanyContacts
where Description like '%marve%'
I get the
David
[ mysql,query ]
update CompanyContacts
set ByEmailAddress = '[EMAIL PROTECTED]'
where Description like '%marve%'
Can you show us the output of:
describe CompanyContacts
...and also what is the exact error message?
Are you connected as a user who is allowed to update the
Hi there
I want to do a left outer join but i also have a bunch of where conditions
in my sql statment that i need. Can anyone help me out:
SELECT title, authorName, journalName, journalPages, aname, tname,
avg(ranking)
FROM publications, area, topic, pubTopicInt,
LEFT OUTER
AND
publications.pubID = 3
GROUP BY (publications.pubID);
Thanks
Desmond
From: Desmond Lee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: help with syntax of left outer join
Date: Tue, 13 Aug 2002 14:34:06 -0700
Hi there
I want to do a left outer join but i also have a bunch of where conditions
From: Desmond Lee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: help with syntax of left outer join
Date: Tue, 13 Aug 2002 14:34:06 -0700
Hi there
I want to do a left outer join but i also have a bunch of where conditions
in my sql statment that i need. Can anyone help me out:
SELECT
Desmond Lee wrote:
Hi there
I want to do a left outer join but i also have a bunch of where conditions
in my sql statment that i need. Can anyone help me out:
SELECT title, authorName, journalName, journalPages, aname, tname,
avg(ranking)
FROM publications, area, topic,
From create syntax, you cannot put , after VARCHAR(1). You have another ,
after AUTO_INCREMENT, maybe it is not correct too.
At 01:56 PM 7/31/2002 -0400, Larry Irwin wrote:
Using MySQL 4.02 on SuSE Linux 7.3
The MySQL docs at http://www.mysql.com/doc/C/R/CREATE_TABLE.html state that
CHECK (expr
and
LastName from the Contacts table with the matching ContactId.
The two SELECTS work fine individually and if I manually supply the
first SELECT with the result of the SELECT in the subquery, I get the
correct result.
But I get a syntax error when I combine them.
Can anyone suggest where I am
]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:55 PM
Subject: subquery syntax
Hello:
I am new to this and am having trouble with subqueries.
Using MySQL 3.23
I have a Contacts table, and a Users table each with a ContactId field.
I want to retrieve the ContactID from the Users table where
AM
To: [EMAIL PROTECTED]
Subject: subquery syntax
Hello:
I am new to this and am having trouble with subqueries.
Using MySQL 3.23
I have a Contacts table, and a Users table each with a ContactId field.
I want to retrieve the ContactID from the Users table where UserName and
UserPassword
. Argg. Apparently you will have to wait for version 4.1.
Subqueries are not supported
Jeff
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:55 PM
Subject: subquery syntax
Hello:
I am new to this and am having trouble
Subject: subquery syntax
Hello:
I am new to this and am having trouble with subqueries.
Using MySQL 3.23
I have a Contacts table, and a Users table each with a ContactId field.
I want to retrieve the ContactID from the Users table where UserName and
UserPassword
- Original Message -
From: Daniel Brockhaus [EMAIL PROTECTED]
To: Jeff Dyer [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 4:43 PM
Subject: Re: subquery syntax
Wouldn't
SELECT Contacts.FirstName, Contacts.LastName FROM Contacts, Users WHERE
Dear Folks,
I'm not sure this is a bug or the SQL syntax.
I created a db named a-b that includes a hyphen.
% mysql a-b
mysql show tables ;
+-+
| Tables_in_a-b |
+-+
| a |
| b
On Tue, Jul 30, 2002 at 01:45:59PM +0900, Takanori Ugai wrote:
Dear Folks,
I'm not sure this is a bug or the SQL syntax.
I created a db named a-b that includes a hyphen.
% mysql a-b
mysql show tables ;
+-+
| Tables_in_a-b
Thank you all to answer me
Quotation.
mysql show tables from `a-b`;
It is working well.
In messasge [EMAIL PROTECTED],
Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Tue, Jul 30, 2002 at 01:45:59PM +0900, Takanori Ugai wrote:
Dear Folks,
I'm not sure this is a bug or the SQL syntax
If this question is off topic, please let me know.
I have a description field with a set of keywords. I need to update some
data based on a keyword, which is randomly placed in the field. Can
someone please help with a SQL syntax to find the word within the field.
Thanks in anticipation
Hello!
David Durham wrote:
If this question is off topic, please let me know.
I have a description field with a set of keywords. I need to update
some data based on a keyword, which is randomly placed in the field.
Can someone please help with a SQL syntax to find the word within
Use LIKE '%KEYWORD%'
At least this works for Oracle
-Original Message-
From: David Durham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 3:39 PM
To: [EMAIL PROTECTED]
Subject: SQL Syntax (May be OT)
If this question is off topic, please let me know.
I have a description
Ashwin,
Wednesday, July 24, 2002, 3:15:25 PM, you wrote:
AK I have a table with a field full of urls.. what I need to do is to append
AK to those urls with a new url, so for example, if the field had
AK http://www.yahoo.com i want to make it
AK
Hi all,
I have a table with a field full of urls.. what I need to do is to append
to those urls with a new url, so for example, if the field had
http://www.yahoo.com i want to make it
http://www.myserver.com/login?url=http://www.yahoo.com ..
I have tried the following which I thought should
your example on 3.23.51 and 4.0.2 and got only syntax error.
In your previous post there were a mention about error Ignoring user
Look at:
http://www.mysql.com/doc/I/g/Ignoring_user.html
As to your crashed tables, you can restore them from backup or you can
re-create them using mysql_install_db
Hi.
On Mon 2002-07-08 at 22:54:09 -0700, [EMAIL PROTECTED] wrote:
I'm trying to get the name of a booth or tradeshow depending on the
customer_link_type (which is an ENUM) combined with the
customer_link_table_id which tells me the index/id of the correct table
to look in. I've tried this
on crashdb;
grant all on crashdb to [EMAIL PROTECTED] identified by password('pass');
grant all on crashdb to [EMAIL PROTECTED] identified by 'pass';
flush privileges;
\q
Fix:
Use the correct GRANT syntax
Submitter-Id: submitter ID
Originator:Edward van der Jagt
Organization
PROTECTED] identified by 'pass';
flush privileges;
\q
Fix:
Use the correct GRANT syntax
Submitter-Id: submitter ID
Originator: Edward van der Jagt
Organization: The Network Guru
MySQL support: none
Synopsis: Incorrect GRANT causes crash of mysqld
Severity: serious
the correct GRANT syntax
Submitter-Id: submitter ID
Originator: Edward van der Jagt
Organization: The Network Guru
MySQL support: none
Synopsis:Incorrect GRANT causes crash of mysqld
Severity:serious
Priority:medium
Category:mysql
Class: sw-bug
Release: mysql
] identified by password('pass');
grant all on crashdb to [EMAIL PROTECTED] identified by 'pass';
flush privileges;
\q
Fix:
Use the correct GRANT syntax
Submitter-Id: submitter ID
Originator: Edward van der Jagt
Organization: The Network Guru
MySQL support: none
Synopsis: Incorrect GRANT
VARCHAR(1), CHECK (SELECT (print_ticket) REGEXP [0-9]),
print_on_stmtVARCHAR(1), CHECK (print_on_stmt IN Y|N|E|R),
produce_ticket VARCHAR(1), CHECK (produce_ticket REGEXP [ASP])
) TYPE=InnoDB;
None of the CHECK stmts will pass the syntax checker...
Help greatly appreciated.
Larry Irwin
CCA Medical
VARCHAR(1), CHECK (SELECT (print_ticket) REGEXP [0-9]),
print_on_stmtVARCHAR(1), CHECK (print_on_stmt IN Y|N|E|R),
produce_ticket VARCHAR(1), CHECK (produce_ticket REGEXP [ASP])
) TYPE=InnoDB;
None of the CHECK stmts will pass the syntax checker...
Help greatly appreciated.
Larry Irwin
CCA Medical
* The `FOREIGN KEY', `CHECK', and `REFERENCES' clauses don't
actually do anything. The syntax for them is provided only for
compatibility, to make it easier to port code from other SQL
servers and to run applications that create tables with references.
*Note Differences
I'm trying to get the name of a booth or tradeshow depending on the
customer_link_type (which is an ENUM) combined with the
customer_link_table_id which tells me the index/id of the correct table
to look in. I've tried this SQL command, but it doesn't work right. I
get multiple permutations
-
Van: Egor Egorov [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 20 juni 2002 15:53
Aan: [EMAIL PROTECTED]
Onderwerp: Re: update syntax
RBRoa,
Thursday, June 20, 2002, 8:07:54 AM, you wrote:
R Is it possible to include another table in [where clause] using the
update
R syntax in MySQL?..
R e.g
Hello Terry,
Thursday, June 20, 2002, 5:14:40 PM, you wrote:
DT Egor,
DT I hope I understand you work for MySQL in some fashion, is there any plan to
DT allow sub-selects in future releases ?
Yes, multi-table updates and sub-selects is on development and they
will come in version 4.1
DT RSVP,
On Wed, 1969-12-31 at 21:59, Ricardo Fitzgerald wrote:
Hi,
I'm having trouble trying to insert form data into a mysql db, the
thing is my client wants table data to be splitted, I mean some data
comes from the first form, and the rest from another form.
Hi Ricardo!
Why not use a
Hi,
I'm having trouble trying to insert form data into a mysql db, the
thing is my client wants table data to be splitted, I mean some data
comes from the first form, and the rest from another form.
This is a portion of the php script.
// Add together proper fields to enter birth date
Hi.
On Tue, May 28, 2002 at 04:32:20PM -0700, [EMAIL PROTECTED] wrote:
Thanks for the reply! Should I change the structure such that all
varchar fields are in the same table?
I see no reason for this. It may make a (minor) speed difference, but
you should only ever change your table layout
Hi.
On Tue, May 28, 2002 at 06:51:11PM -0400, [EMAIL PROTECTED] wrote:
How do you reference a column name in another table to avoid repeating the
values?
I am not sure if I understand you correctly, but I assume you mean this:
Given the following table layout (it's a simplification in that I
Hello list, this is my first table for a simple php page and I'm hoping
someone could briefly review its structure. The only fields I'll be
sharing are property_name and type. Are they set up properly for select
join queries?
thank you, justin
Database=properties
Tables are
Hi.
Looks okay, except that you probably want to reference via pro_id and
d_id in table available_properties (given that I understood your table
layout correctly). It is usally considered bad design to repeat the
values itself (the varchars) in several tables.
Bye,
Benjamin.
On Tue,
table; syntax qustion
Hi.
Looks okay, except that you probably want to reference via pro_id and
d_id in table available_properties (given that I understood your table
layout correctly). It is usally considered bad design to repeat the
values itself (the varchars) in several tables.
Bye
: first mysql table; syntax qustion
Hi.
Looks okay, except that you probably want to reference via pro_id and
d_id in table available_properties (given that I understood your table
layout correctly). It is usally considered bad design to repeat the
values itself (the varchars) in several tables
At 21:27 -0500 5/23/02, Andrew Lietzow wrote:
Dear MySQL wizards,
I have two tables, call them a and b. The database structure is
identical. I want the records in b to overwrite the records in (REPLACE
INTO) a.
This is the statement that does NOT work.
REPLACE INTO a SELECT b.* FROM b
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Cc: andy [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 3:56 PM
Subject: Re: Problem with join syntax
* andy [EMAIL PROTECTED]
thank you roger for your reply.
I am wondering how to form the stmt if I do
* andy
thanx for your help. Anyhow this statement does not return the wanted
fields.
I would like to return the website and the signature of the
user, but only
if those values are available. There might be none of them available, but
maybe 1 or even both.
this query:
SELECT
I changed my.cnf to add an autoextending datafile but I get errors on
startup.
Here's the my.cnf syntax:
innodb_data_file_path = hat/hatdata1:64M;hat/hatdata2:64M:autoextend
Here's the error output from mysqld:
InnoDB: syntax error in innodb_data_file_path
020523 16:34:24 Can't init databases
Hi Steve,
On Fri, 2002-05-24 at 09:56, Orr, Steve wrote:
I changed my.cnf to add an autoextending datafile but I get errors on
startup.
Here's the my.cnf syntax:
innodb_data_file_path = hat/hatdata1:64M;hat/hatdata2:64M:autoextend
Here's the error output from mysqld:
InnoDB: syntax
WHERE a.field1 = b.field1
I also tried this with the last the conditional statement reversed. MySQL
doesn't like my syntax. The field names in A are identical to B.
TIA for any help.
--
Andrew Lietzow
The ACL Group, Inc.
The SELECT part has to be a legal SELECT statement, which yours
isn't
Hey guys,
when i delete a row using the query DELETE FROM $table WHERE id = 3 LIMIT 1;
how can i make it that the id column (auto_increment) starts over from 1 and
build up to however many rows there are without counting 1 2 4 5 6 etc.?
any ideas?
Jule
--
|\/\__/\/|
|
At 18:29 -0400 5/22/02, Jule wrote:
Hey guys,
when i delete a row using the query DELETE FROM $table WHERE id = 3 LIMIT 1;
how can i make it that the id column (auto_increment) starts over from 1 and
build up to however many rows there are without counting 1 2 4 5 6 etc.?
If you're asking how
hi. i'm new to the list and have only been playing with mySQL for a few
weeks now, i have a question regrading the syntax of an UPDATE statement - i
hope nobody minds me asking.
i want to uopdate a table with the data from another, i've written the
following:
update trackinfo SET
[snip]
update trackinfo SET trackinfo.postcode = newtrackinfo.postcode FROM
trackinfo, newtrackinfo WHERE trackinfo.telephone = newtrackinfo.telephone;
[/snip]
http://www.mysql.com/doc/U/P/UPDATE.html
MySQL does not support sub-queries, such as the one you are attempting here.
(the FROM on..)
There is no from clause in the update syntax. However, I'm not sure how
you would update a tablethe way you are trying to. I'm sure it can be done, and your
SQL looks
correct besides the fromclause. Just take that out and see if what it says.
-Nick
hi. i'm new to the list and
have only been
cheers for the responses. i'll have to find another way, but thanks.
.b
-Original Message-
From: Nick Stuart [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002 13:46
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: UPDATE question, SQL syntax, etc.
There is no from clause
* andy [EMAIL PROTECTED]
thank you roger for your reply.
I am wondering how to form the stmt if I do already know the user_id
I tryed this, but it does not work though. Anyhow there has to be a from
field. But on which table?
SELECT w.website, c.comment
LEFT JOIN user_websites AS w ON
Hi there,
I have some trouble with the syntax of join query and some perfomance isues.
I did split my data due to the rules of normalisation. So there is a website
table and a comment table and I would like to find out if the user with the
id '10215' has a stored comment or website.
Here is my
any perfomer
GN who does magic for children. What am I doing wrong please? I've tried
GN several other syntax combinations without success.
What are the values of your php variables? Are you sure that they are
correct?
GN kind regards,
GN Graham Nichols.
--
For technical support contracts
syntax combinations without success.
kind regards,
Graham Nichols.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
syntax combinations without success.
kind regards,
Graham Nichols.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
[snip]
+-++-+
| artist | area | magic |
+-++-+
| Joe Bloggs | AZ*IN*TX | childrens |
+-++-+
| Fred Smith | All| close-up|
Hello All,
I have a LEFT JOIN nested inside an INNER JOIN that generates a mySQL
syntax error. I'm new to mySQL so I wonder if anyone could help me
understand the problem. The query runs fine under PostgreSQL, MS SQL, and
MS Access.
SELECT
Recording.Entry, InstCode.InstType
Gregg,
Tuesday, May 07, 2002, 12:15:27 AM, you wrote:
Check the manual:
http://www.mysql.com/doc/V/a/Variables.html
GG According to the manual from the above link, where it states:
GG ==
GG You can set a variable with the SET syntax:
GG
Hi,
Gregg Graubins wrote:
Gregg,
Monday, May 06, 2002, 6:57:55 PM, you wrote:
GG Upon reading into the user variables section of the mysql manual, I
cut
cut
According to the manual from the above link, where it states:
cut
mysql SELECT @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3;
someone confirm, please?
On a general note, it would be nice to have the formal syntax of FT search
patterns in the manual.
TIA,
Vadim.
[sql query - to satisfy the darn spam filter]
-
Before posting, please check:
http
Greetings,
Upon reading into the user variables section of the mysql manual, I decided
to make my life easier inside several of my queries by specifying some user
variables. Note that I'm trying to have everything inside the select
statement - Primarily because I'm simply passing it through to
(some_text_field) AGAINST ('(red pepper) (green bean)')
don't produce the result desired, that is, multiple .. elements are not
allowed, with or without parentheses...
Could someone confirm, please?
On a general note, it would be nice to have the formal syntax of FT search
patterns in the manual
Gregg,
Monday, May 06, 2002, 6:57:55 PM, you wrote:
GG Upon reading into the user variables section of the mysql manual, I decided
GG to make my life easier inside several of my queries by specifying some user
GG variables. Note that I'm trying to have everything inside the select
GG statement -
]
Subject: Re: FULLTEXT search pattern syntax
Of course, I forgot to mention 'IN BOOLEAN MODE'.
...
MATCH (some_text_field) AGAINST ('(red pepper) (green bean)' IN BOOLEAN
MODE)
...
Vadim P. wrote:
Hi,
It's not quite clear from the manual, but it appears that queries with
FULLTEXT search
, with or without parentheses...
Could you explain, what result is desired and what result you are getting ?
Because, right now I can only say that multiple .. elements ARE
allowed, of course.
On a general note, it would be nice to have the formal syntax of FT search
patterns in the manual.
I
, with or without parentheses...
Could you explain, what result is desired and what result you are getting ?
Because, right now I can only say that multiple .. elements ARE
allowed, of course.
On a general note, it would be nice to have the formal syntax of FT search
patterns in the manual
the above link, where it states:
==
You can set a variable with the SET syntax:
SET @variable= { integer expression | real expression | string expression }
[,@variable= ...].
You can also assign a value to a variable in statements other than SET
in the manual:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
V This syntax does not work in MySQL.
V Thank you very much for you time.
V Vadim Kulikov
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net
and t2.col2 is NULL
This syntax does not work in MySQL.
#
I need help!
#
Thank you very much for you time.
Vadim Kulikov
877-428-3279
[EMAIL PROTECTED]
P.S. Someone left a comment with the example on how you can do delete
with join under MYSQL help site. But its
and t2.col2 is NULL
This syntax does not work in MySQL.
#
I need help!
#
Thank you very much for you time.
Vadim Kulikov
877-428-3279
[EMAIL PROTECTED]
P.S. Someone left a comment with the example on how you can do delete
with join under MYSQL help site. But its
-Original Message-
From: Vadim [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 27, 2002 4:49 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: I need an example on DELETE /UPDATE with JOIN syntax
Greetings:
My company migrated to MySQL a few months ago from Sybase
and bond_master.maturity = 2002/02/15;
AW That has syntax errors. I am issuing this at the mysql command prompt - a
AW little background:
AW two tables:
AW bond_master (fields: cusip, maturity, rating)
AW bond_data(field: cusip, date, delta)
AW common field:
AW cusip
AW goal:
AW
Tony,
Friday, April 26, 2002, 12:15:00 AM, you wrote:
TWDescription:
TW When dumping the 'mysql' database, the dump file contains syntax errors,
TW and I can't find where this has been rectified in later releases.
TW Example dump using 'mysqldump -cl mysql':
TW [snip]#
TW # Table structure
Description:
When dumping the 'mysql' database, the dump file contains syntax errors,
and I can't find where this has been rectified in later releases.
Example dump using 'mysqldump -cl mysql':
[snip]#
# Table structure for table 'db'
#
CREATE TABLE db (
Host char(60) NOT NULL default
Hello, I am new to mysql - past the very basics - you may see a few silly
questions - here is the first.
I have a DELETE statement:
delete bond_master,bond_data from bond_data where
bond_master.cusip=bond_data.cusip and bond_master.maturity = 2002/02/15;
That has syntax errors. I am
Hi!
Eric == Eric Thelin [EMAIL PROTECTED] writes:
Eric On Sat, 20 Apr 2002 [EMAIL PROTECTED] wrote:
I always get a syntax error when using INSERT_METHOD in creating merge
tables. If I leave off the INSERT_METHOD part it works fine. I have
tried this on many versions in the past and now
for MERGE tables was introduced in version 4.0.0. Let's
see... yep, http://www.mysql.com/doc/N/e/News-4.0.0.html says so.
Regards,
Benjamin.
PS: The syntax you used should be fine with a version supporting it
On Fri, Apr 19, 2002 at 04:00:02PM -0700, [EMAIL PROTECTED] wrote
Hi.
On Sat, Apr 20, 2002 at 01:12:14AM -0700, [EMAIL PROTECTED] wrote:
Perhaps the INSERT_METHOD functionality was introduced in 4.0 but the
merge tables themselves work in later 3.23 versions.
As I said, INSERT for MERGE was introduced in 4.0 (including
INSERT_METHOD). Of course, MERGE
the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.
You have written the following:
I always get a syntax error
Hi.
AFAIK, insert for MERGE tables was introduced in version 4.0.0. Let's
see... yep, http://www.mysql.com/doc/N/e/News-4.0.0.html says so.
Regards,
Benjamin.
PS: The syntax you used should be fine with a version supporting it
On Fri, Apr 19, 2002 at 04:00:02PM -0700, [EMAIL
in table phistory ( column testname)
I wanted to write a SQL query for this
select distinct testname from testhistory where testname not in (select
distinct testname in phistory)
but I get a syntax error
Help
Jim
-
Before posting
from testhistory where testname not in (select
distinct testname in phistory)
but I get a syntax error
Help
Jim
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
out the test name but I dont want duplicate. I made the column unique
jalf in table phistory ( column testname)
jalf I wanted to write a SQL query for this
jalf select distinct testname from testhistory where testname not in (select
jalf distinct testname in phistory)
jalf but I get a syntax
I have the following query:
select *, max(event_date) as high, min(event_date) as low from schedule
where event_date between '2002-03-01' and '2003-04-30' group by
week_ending,meeting_id order by name, event_date, start_time
If I order by event_date, start_time, name, I get the proper results.
Does anyone know what is wrong with my syntax? (the sql statement works in
mssql server)?
SELECT user.*, wbs.name
FROM wbs INNER JOIN (user INNER JOIN user_wbs ON user.id =
user_wbs.user_id) ON wbs.id = user_wbs.wbs_id
Thanks,
Scott
Message-
From: Hathaway, Scott L [mailto:[EMAIL PROTECTED]]
Sent: Mon, 25 Mar 2002 15:47
To: '[EMAIL PROTECTED]'
Subject: syntax question
Does anyone know what is wrong with my syntax? (the sql statement works in
mssql server)?
SELECT user.*, wbs.name
FROM wbs INNER JOIN (user INNER JOIN
I'm trying to figure out a query that will tell me the total number of
people in our house email file that physically opted out in the last
week. I'm a bit of a mysql newbie as you can tell...
This is the general concept, though it doesn't seem to work:
select count(id) from contact # my
AND date = 2002-03-17;
-Original Message-
From: rory oconnor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 10:49 AM
To: mysql list (choose midget)
Subject: Query syntax help
I'm trying to figure out a query that will tell me the total number of
people in our house email
I'm trying to figure out a query that will tell me the total number of
people in our house email file that physically opted out in the last
week. I'm a bit of a mysql newbie as you can tell...
This is the general concept, though it doesn't seem to work:
select count(id) from contact
: Query syntax help
I'm trying to figure out a query that will tell me the total number of
people in our house email file that physically opted out in the last
week. I'm a bit of a mysql newbie as you can tell...
This is the general concept, though it doesn't seem to work:
select count(id) from
701 - 800 of 991 matches
Mail list logo