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
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
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
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
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
Graham,
Monday, May 13, 2002, 8:45:09 PM, you wrote:
GN I have a directory of professional magicians, consisting of a MySQL table
GN like
GN this:
GN +-++-+
GN | artist | area| magic |
GN
Hi,
I have a directory of professional magicians, consisting of a MySQL table
like
this:
+-++-+
| artist | area| magic |
+-++-+
| Joe Bloggs | AZ*IN*TX | childrens |
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;
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
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 -
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
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.
I've looked throught the MySQL documentation and I can't seem to find the
answer to this problem. I have a query that will work on a Microsoft SQL
server, but I've tried moving it to a MySQL server and it won't work. I
tried modifying it and I can't get it to work either. The scenario and
At 18:15 -0500 3/18/02, John Burns wrote:
I've looked throught the MySQL documentation and I can't seem to find the
answer to this problem. I have a query that will work on a Microsoft SQL
server, but I've tried moving it to a MySQL server and it won't work. I
tried modifying it and I can't get
I have three tables as follows (simplified):
persons (person_id,person)
skills( skill_id,skill)
person_skills( person_id,skill_id)
A person can have one or more entries in the person_skills table, indicating
their skills.
I need to select persons where there skills match ALL skill_id's in a
Hi,
Select person from persons as p, person_skills as ps
where p.personid = ps.person_id
And ps.skill_id in (id1,id2..);
Anvar.
At 09:40 PM 21/01/2002 -0500, you wrote:
I have three tables as follows (simplified):
persons (person_id,person)
skills( skill_id,skill)
person_skills(
I would like to use an input form to add users to my database, however, if
the name is already in use, I do not want to add a duplicate record. I also
need this to be case insensitive (ie Santa Claus = santa Claus).
I've tried the following code, but it doesn't seem to be working
At 10:02 AM -0800 12/18/01, Steve Osborne wrote:
I would like to use an input form to add users to my database, however, if
the name is already in use, I do not want to add a duplicate record. I also
need this to be case insensitive (ie Santa Claus = santa Claus).
Make the (LastName,
Sorry for the repost of this problem, but I can't find the answer anywhere,
and I'm stuck here until I solve this.
I am receiving the following error when I try to restore a database backup
from an .sql file:
ERROR 1064 at line 12: You have an error in your SQL syntax near
'PACK_KEYS=1' at line
]
- Original Message -
From: Steve Werby [EMAIL PROTECTED]
To: Steve Osborne [EMAIL PROTECTED]; MySQL (E-mail)
[EMAIL PROTECTED]
Sent: Friday, November 30, 2001 2:58 PM
Subject: Re: SQL syntax error
Steve Osborne [EMAIL PROTECTED] wrote:
I am receiving the following error when I try
In the last episode (Nov 30), Steve Osborne said:
I created the file with ver 3.23.43, tried to recreate database on
3.22.32. I administer 2 other databases the same commands and they
work fine. I looked at the difference in the sql files, and those
ones don't contain the PACK_KEYS
Hi,
Im still learning sql so I hope this doesnt sound to basic.
I would like to find out if there is a way to insert a record only when (X and Y) do
not exist.
I have the value to check against stored in a variable.
My table looks like the following:
ID | X | Y
-
1 |
Hi,
Im still learning sql so I hope this doesnt sound to basic.
I would like to find out if there is a way to insert a record only when (X and Y) do
not exist.
I have the value to check against stored in a variable.
My table looks like the following:
ID | X | Y
-
1 |
Robert Martin wrote:
Hi,
I?m still learning sql so I hope this doesn?t sound to basic.
I would like to find out if there is a way to insert a record only when (X and Y) do
not exist.
I have the value to check against stored in a variable.
ALTER TABLE table ADD UNIQUE u_xy_idx ( x, y );
01, 2001 12:50 PM
To: [EMAIL PROTECTED]
Subject: sql syntax INSERT
Hi,
Im still learning sql so I hope this doesnt sound to basic.
I would like to find out if there is a way to insert a record
only when (X and Y) do not exist.
I have the value to check against stored in a variable.
My
Hi,
MySQL said: You have an error in your SQL syntax near 'order by
'Variable_name' ASC' at line 1
Any ideas as to what this means, and how to fix it?
Thanks, Dave
-
Before posting, please check:
http://www.mysql.com
From: [EMAIL PROTECTED]
MySQL said: You have an error in your SQL syntax near 'order by
'Variable_name' ASC' at line 1
Any ideas as to what this means, and how to fix it?
Hi Dave,
How 'bout sending us the entire SQL statement, please.
---
Rodney Broom
Programmer: Desert.Net
with the
control panel on my website and went to MySQL database. I clicked on: Show
MySQL system variables. Then I could click on: Variable_name, or Value both
give me this:
MySQL said: You have an error in your SQL syntax near 'order by 'Value' ASC'
at line 1
So I thought this might be what
SQL syntax near 'order by 'Value' ASC'
at line 1
This means that the clicking produced an invalid SQL
command. Seemingly it wanted to run
show variables order by 'Value' ASC
which is no valid command (SHOW VARIABLES doesn't allow an ORDER BY clause).
So I thought this might be what is keeping
Date |Tue, 28 Aug 2001 15:14:54 +0500
From |Alexander Barkov [EMAIL PROTECTED]
Hello!
AB Hello!
AB These query produces an SQL syntax error
AB in 3.23.29a-gamma:
AB GRANT ALL PRIVILEGES ON databases.*
AB TO 'foo'@'localhost' IDENTIFIED BY 'bar';
AB SHOW TABLES FROM databases;
AB
Hello!
These query produces an SQL syntax error
in 3.23.29a-gamma:
GRANT ALL PRIVILEGES ON databases.*
TO 'foo'@'localhost' IDENTIFIED BY 'bar';
SHOW TABLES FROM databases;
Probably this is because of databases is
a keyword. However, mysqladmin does allow to
create database 'databases
I have two table I need to join in a query. The second table needs to be
join twice (I think) to the first. Details as follows (tables pared down)...
Table games
gameid
hometeamid
guestteamid
Table team
teamid
sponsor
I want a query to return game.gamid, team.sponsor (hometeam),
On 26-Apr-01 [EMAIL PROTECTED] wrote:
I have two table I need to join in a query. The second table needs to be
join twice (I think) to the first. Details as follows (tables pared
down)...
Table games
gameid
hometeamid
guestteamid
Table team
teamid
sponsor
I want a query to
BY custmls.currentprice
The error is: "1064 You have an error in your SQL syntax near 'ON ipix
custmls.mlsnumber = ipix.mlsnumber where custmls.listingoffice = 0251 AN' at
line 1 "
Any ideas?
Thanks
Pat
Sir, the error message was obviously from an SQL statement other than
the one
BY custmls.currentprice
The error is: "1064 You have an error in your SQL syntax near 'ON ipix
custmls.mlsnumber = ipix.mlsnumber where custmls.listingoffice = 0251 AN' at
line 1 "
Any ideas?
Thanks
Pat
Pat Militzer
Tech Support Supervisor
Metro/MLS Inc.
11430 W North Ave
Wauwatosa, WI
Thanks, I tried the latter, but it didn't work. I'll try you're suggestion.
curtis
- Original Message -
From: "Quentin Bennett" [EMAIL PROTECTED]
To: "'Curtis Maurand'" [EMAIL PROTECTED]; "MySQL List"
[EMAIL PROTECTED]
Sent: Monday, March 19, 2001 11:44 P
Hi,
Just a quick quesiton, I have a table that contains difined as
create table picks(
handle char(30) primary key,
...
total int unsigned);
there is a user table that has a list of handles and other user info. handle is the
primary key.
If I issue the command "select handle,
PROTECTED]]
Sent: Tuesday, 20 March 2001 4:28 p.m.
To: MySQL List
Subject: [OT] SQL syntax qestion
Hi,
Just a quick quesiton, I have a table that contains difined as
create table picks(
handle char(30) primary key,
...
total int unsigned);
there is a user table that has a list of handles
On Mon, 19 Mar 2001, Curtis Maurand wrote:
Hi,
Just a quick quesiton, I have a table that contains difined as
create table picks(
handle char(30) primary key,
...
total int unsigned);
there is a user table that has a list of handles and other user info. handle is the
),
gift_cert VARCHAR(3),
related TEXT,
featured VARCHAR(32),
download char(128),
dl_type char(128),
dl_location char(128),
inactive char(128)
)
signat config error: You have an error in your SQL syntax near ' '', '',
'', '',
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',' at line 1
At 10:09 PM +0200 2/2/01, Ciprian wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Anybody knows where I can find a list with all SQL syntax -es.
Eventually explained.
Thanks
If you mean the SQL statements supported by MySQL, the MySQL Reference
Manual
101 - 147 of 147 matches
Mail list logo