-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 "select * from old_topic where FID=4 and (
ry NOT NULL default '',
`replytime` datetime NOT NULL default '-00-00 00:00:00',
PRIMARY KEY (`MGID`),
KEY `uid` (`uid`),
KEY `FID` (`FID`,`page`,`replytime`),
FULLTEXT KEY `topic` (`topic`)
) TYPE=MyISAM
>How-To-Repeat:
>Fix:
>Sub
FIELDS TERMINATED
> BY '\t' LINES TERMINATED BY '\r' (manufacture name,name,street
> address,city,state,zipcode)
> Error: 1064 - You have an error in your SQL syntax near 'name,name,street
> address,city,state,zipcode)' at line 1
You have field names with
name,name,street
address,city,state,zipcode)
Error: 1064 - You have an error in your SQL syntax near 'name,name,street
address,city,state,zipcode)' at line 1
when I attempt to LOAD DATA INFILE the tab delimited field ascii file.
=
Field
ROTECTED]>
Sent: Thursday, March 06, 2003 9:32 AM
Subject: Re: Syntax confusion
> At 0:23 +0100 3/6/03, Benjamin Pflugmann wrote:
> >On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
> >[...]
> >> BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <=
At 0:23 +0100 3/6/03, Benjamin Pflugmann wrote:
On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
[...]
BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <= '2003-02-25 23:59:59'
or
TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25'
Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE i
On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
[...]
> BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <= '2003-02-25 23:59:59'
>
> or
>
> TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25'
Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE is a
timestamp, not a number of days.
As
s" <[EMAIL PROTECTED]>
To: "Jeff" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 8:51 AM
Subject: Re: Syntax confusion
At 8:40 +1000 3/6/03, Jeff wrote:
>Hi, perform the following query
>
>SELECT BA_ID, B
lt;[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 8:51 AM
Subject: Re: Syntax confusion
> At 8:40 +1000 3/6/03, Jeff wrote:
> >Hi, perform the following query
> >
> >SELECT BA_ID, BA_DATE
> >FROM BA
> >WHERE SU
At 8:40 +1000 3/6/03, Jeff wrote:
Hi, perform the following query
SELECT BA_ID, BA_DATE
FROM BA
WHERE SUBSTRING(BA_ID,1,3) = 'TSV'
and get
'TSV12345-1','2003-02-25 00:00:00'
'TSV12345-2','2003-02-25 00:00:00'
'TSV14818-3','2003-02-19 00:00:00'
'TSV14836-00015','2003-02-27 00:00:00'
'T
Hi, perform the following query
SELECT BA_ID, BA_DATE
FROM BA
WHERE SUBSTRING(BA_ID,1,3) = 'TSV'
and get
'TSV12345-1','2003-02-25 00:00:00'
'TSV12345-2','2003-02-25 00:00:00'
'TSV14818-3','2003-02-19 00:00:00'
'TSV14836-00015','2003-02-27 00:00:00'
'TSV14841-9','2003-02-28 00:00:
: Tuesday, March 04, 2003 4:58 PM
To: Bob Ramsey
Cc: [EMAIL PROTECTED]
Subject: Re: help with join syntax
Hi.
This is not at all an answer to your problem,
and perhaps you're already aware of my tip:
I usually use phpMyAdmin and paste my SQL statements
in there to see what is causing the
t it just keeps
choking on the join statement.
"You have an error in your SQL syntax near '(fac_stud_lunch INNER JOIN
fac_stud_lunch_join ON fac_stud_lunch.instructor_hawk' at line 2"
Thanks,
Bob
==
.location, fac_stud_lunch.num_students
> FROM lawfac_pub INNER JOIN (fac_stud_lunch INNER JOIN fac_stud_lunch_join
> ON fac_stud_lunch.instructor_hawkid =
> fac_stud_lunch_join.instructor_hawkid) ON lawfac_pub.hawkid =
> fac_stud_lunch_join.instructor_hawkid
> WHERE (((fac_stud_lunch_join.student_hawkid) Not Like &#
l_time;
And I keep getting an error on the inner join. I've usually been able to
get the syntax for joining 3 or 4 tables by using Access, but it seems to
have failed me this time.
Any ideas why this select statement is failing?
Thanks,
Bob
===
BY F.saveorder (another column) in
this case, unless you include it (F.saveorder) in the SELECT and GROUP BY
list.
HTH,
Tore.
- Original Message -
From: "Scott Brown" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 22, 2003 1:57 PM
Subject: Query s
OK, I am having a bit of trouble designing a MySQL query that returns what
I want. Here is the query as I have it thus far:
SELECT DISTINCT regformfields.name AS thename,
regformfields.label AS thelabel,
regfields.name AS fieldsname
FROM regformfie
Hi,
md5 is a function name, maybe that's why you need to quote the field
name. Check the MySQL manual about that.
On Thu, 2003-02-20 at 10:51, [EMAIL PROTECTED] wrote:
> >Description:
> syntax checker reject length restriction when index char column
> with ending by num
>Description:
syntax checker reject length restriction when index char column
with ending by number.
>How-To-Repeat:
alter table xmlmd5 add index md5 (md5(10));
ERROR 1064: You have an error in your SQL syntax near 'md5(10))' at line 1
column defi
On Sat 2003-02-01 at 10:35:46 -, [EMAIL PROTECTED] wrote:
> Hi Benjamin,
>
> Wow, that sure sorted that problem out... I had to rejig it slightly to
> get it to work,
Oops... too much copy&paste by me :-)
> but this is the final working version:
Glad it worked out.
Bye,
Benjamin.
27;ll work out why I couldn't do that so I can better
understand it.
Kevin
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Kevin Smith" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, February 01, 2003 4:32 AM
On Fri, Jan 31, 2003 at 02:07:11PM -, Kevin Smith wrote:
> Hi All,
>
> Can anyone help me get this query working in MySQL, this was created using
> Access, but it doesn't port well for MySQL syntax:
>
> SELECT b.id, p.part_code, p.product_type, p.description,
Hi.
On Fri 2003-01-31 at 15:46:37 -, [EMAIL PROTECTED] wrote:
> Hi All,
>
> Can anyone help me get this query working in MySQL, this was created using
> Access, but it doesn't port well for MySQL syntax:
>
> SELECT basket.id,
> products.part_cod
eated using
: > Access, but it doesn't port well for MySQL syntax:
: >
: > SELECT basket.id,
: > products.part_code,
: > products.product_type,
: > products.description,
: > product_options_1.options,
: > basket.price, basket.quantity,
:
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT basket.id,
products.part_code,
products.product_type,
products.description,
product_options_1.options,
basket.price, basket.quantity,
basket.
To: <[EMAIL PROTECTED]>
Sent: Friday, January 31, 2003 3:46 PM
Subject: SQL Syntax
> Hi All,
>
> Can anyone help me get this query working in MySQL, this was created using
> Access, but it doesn't port well for MySQL syntax:
>
> SELECT basket.id,
> products.part_
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT basket.id,
products.part_code,
products.product_type,
products.description,
product_options_1.options,
basket.price, basket.quantity,
basket.
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT b.id, p.part_code, p.product_type, p.description, po1.options,
b.price, b.quantity, b.price*b.quantity AS total
FROM (products AS p LEFT
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote:
> you are correct - subselects are NOT allowed until version 4
Subselects will be available in version 4.1
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Developing Dynamic Web Applications
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote:
> you are correct - subselects are NOT allowed until version 4
4.1 as opposed to 4.0.x.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 3.23.51
you are correct - subselects are NOT allowed until version 4
until then:
SELECT t1.*
FROM table1 t1
LEFT JOIN t2 ON t1.id = t2.id
OR
SELECT t1.*
FROM table1 t1
LEFT JOIN t2 USING (id)
> -Original Message-
> From: Doug Beyer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, Janua
In the last episode (Jan 15), Doug Beyer said:
> It's my understanding that embedded selects are NOT allowed in MySql. Is this
>correct?
>
> Example:
>
> SELECT t1.*
> FROM table1 t1
> WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )
Correct. Your example can easily be converted to a join,
same results and both varying between .01, .02 seconds to execute.
6 of one half dozen of another or is there an advantage to one?
My guess is that the second syntax is preferred given the reduced row count
for events in it's explain table.
The first statement uses left joins, the second
It's my understanding that embedded selects are NOT allowed in MySql. Is this correct?
Example:
SELECT t1.*
FROM table1 t1
WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )
Doug Beyer
SAS Research and Development
503-617-7103 (Portland)
[EMAIL PROTECTED]
SAS... The Power to Know
-
Hello,
I need to get a single result from a SELECT from a table with the following sturcture:
component - varchar(25) primary key
catNum - varchar(25) primary key
price - decimal(10,2)
my component list may contain duplicate catNum ie:
primary drive -WD1GJB
- W
on:
Server101.com
>MySQL support: none
>Synopsis: Replication halts with sql syntax error
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.54 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver
I would like to return rows, with specific columns, for each individual in
my NAMES table, with address and e-mail if these exist. Thought I had the
syntax down but I'm getting NULL results where I know there is data. I'm
used to using SQL Server shortcut * for outer joins, guess that&
I don't know if i understood you very well, but here's a try..
mysql> select * from Classes;
++-+
| ID | Name|
++-+
| 1 | XO-312 |
| 2 | PA-211a |
| 3 | XUL-001 |
++-+
3 rows in set (0.00 sec)
mysql> select * from Workshops order by ClassID,Date;
++
First of, thanks to all who replied to my questions earlier!
Now I have another problem. I have a table of Classes and Workshops. Each
Class has a number of workshops. Each workshop has a date.
I have a query that gives me the date range of a class - the min and max
dates of its workshops.
"sele
On 8 Jan 2003, at 15:27, Svens Klave wrote:
> | image | check |
> | 6782 | 0 |
> | 2732 | 1 |
> | 6734 | 1 |
>
> so I want to make query
> select * from foo1 where [so is it possible to make some if check=1 then
> image is image but if check=0 then into image goes othe
On Wed, Jan 08, 2003 at 03:27:51PM +0200, Svens Klave wrote:
>
> Can anybody help me
> with select query
>
> how to do this:
>
> I have table "foo1" with two fields "image" "check"
>
> | image | check |
> | 6782 | 0 |
> | 2732 | 1 |
> | 6734 | 1 |
>
> so I want to ma
* Svens Klave
> Can anybody help me
> with select query
I can try.
> how to do this:
>
> I have table "foo1" with two fields "image" "check"
>
> | image | check |
> | 6782 | 0 |
> | 2732 | 1 |
> | 6734 | 1 |
>
> so I want to make query
> select * from foo1 where [so is
rectly.
select *,if(image,"1","0") as ImagePresent from foo1 where ...
If you don't want to spell out all of the fields, that's the easiest
syntax. You'll can all your fields plus an extra column named
ImagePresent that will be the same as your "check"
Can anybody help me
with select query
how to do this:
I have table "foo1" with two fields "image" "check"
| image | check |
| 6782 | 0 |
| 2732 | 1 |
| 6734 | 1 |
so I want to make query
select * from foo1 where [so is it possible to make some if check=1 then
image
EMAIL PROTECTED]'
Subject: Update syntax
Hi All,
With a database that contains tables PetInv and Purchases:
mysql> update PetInv
-> set PetInv.Qty = PetInv.Qty + Purchases.Qty
-> where PetInv.ItemNo = Purchases.ItemNo;
ERROR 1109: Unknown table 'Purchases' in whe
Hi All,
With a database that contains tables PetInv and Purchases:
mysql> update PetInv
-> set PetInv.Qty = PetInv.Qty + Purchases.Qty
-> where PetInv.ItemNo = Purchases.ItemNo;
ERROR 1109: Unknown table 'Purchases' in where clause
As you can see I'm trying to add purchase quantitie
ginal Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 25, 2002 12:10 AM
Subject: syntax
> I portaded my Application from the MS SQL Server 7.0 to MySQL 3.23.54
and
> i'm having problems with the both syntax.
>
> How can i d
I portaded my Application from the MS SQL Server 7.0 to MySQL 3.23.54 and
i'm having problems with the both syntax.
How can i do this query in MySQL Server Syntax:
"select sld_vlprov,hist_lanc from sld_lanc,lanc
where sld_lanc.sld_user *= lanc.user_usuario and
dt_movlanc &
>Description:
I found 3 syntax errors found in safe_mysqld (and safe_mysqld.sh),
in both source and binary distribution of MySQL 3.23.54. Since syntax errors
are appearent, so I just post the patch file here to fix it.
diff -u -r mysql-3.23.54/scripts/safe_mysqld.sh
mysql-3.23
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 13 Dec 2002, imacat wrote:
> >Description:
> I found 3 syntax errors found in safe_mysqld (and safe_mysqld.sh),
> in both source and binary distribution of MySQL 3.23.54. Since syntax errors
> are appearent, so
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: "list mysql" <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 2:06 AM
Subject: Re: alter table syntax
> In the last episode (Dec 09), k
Thanks for the suggestions.
It worked fine
regards
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 06, 2002 11:36 PM
Subject: re: Re: alter table syntax
> kayamb
In the last episode (Dec 09), kayamboo said:
> I don't get you.
> But when I executed the drop table syntax fromt he command line, the result
> was this error
>
> mysql> alter table town_db drop primary key ;
> ERROR 1025: Error on rename of '.\forest\#sql-cc_1&
I don't get you.
But when I executed the drop table syntax fromt he command line, the result
was this error
mysql> alter table town_db drop primary key ;
ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db'
(errno: 150)
mysql>
C
kayamboo,
Friday, December 06, 2002, 9:15:04 AM, you wrote:
k> When I tried to drop the key, this was the error
k> mysql> alter table town_db drop primary key ;
k> ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db'
k> (errno: 150)
k> I suppose some lock in the index somew
In the last episode (Dec 06), kayamboo said:
> When I tried to drop the key, this was the error
>
> mysql> alter table town_db drop primary key ;
> ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db' (errno:
>150)
And what does "perror 150" return (it's a shell command, not
Sorry, I tried that before.
***
This is my show create table syntax
mysql> show create table town
> | subcity | varchar(50) | | PRI | | |
> | rankt | int(10) unsigned | | | 0 | |
> +-+--+--+-+-+---+
> 3 rows in set (0.00 sec)
>
> I am able to create new table but can't alter the exi
sec)
I am able to create new table but can't alter the existing one to achieve
this.
Any suggestions with alter syntax is highly appreciated
Thanks for your time
Regards
-
Hi,
I suppose you have to use a NULL value:
INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES
(2113,NULL,NULL)I
[EMAIL PROTECTED] wrote:
>
> Hi,
> I have the following statement causing an error near ","
> sNewCallBackSQL = "INSERT INTO CallBacks (LearnerID,CallDate,CallTime) V
"a set which contains as an element
> the set itself"
>
> WHERE fooId IN (fooId)
>
> Adolfo
>
>> -Original Message-
>> From: Peter Abilla [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, December 02, 2002 1:43 PM
>> To: [EMAIL PROTECTED]
>> S
Hi,
I have the following statement causing an error near ","
sNewCallBackSQL = "INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (" &
ExLearnerID & " , " & sCallDate & " , " & sCallTime & ")"
The executed statement is:
INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (211
From: Peter Abilla <[EMAIL PROTECTED]>
> In this example, I have the table 'bar' and the column 'fooID'.
It sounds to me like you've actually got two tables. If this is the case, you can do
something like:
SELECT bar.foo
FROM bar, baz
WHERE baz.fooID in (baz.fooID)
Which would give yo
002 1:43 PM
> To: [EMAIL PROTECTED]
> Subject: sql:WHERE IN SYNTAX
>
>
> Question about SQL "WHERE IN" syntax:
>
> I know that something like this is fine to do:
>
> (1)
> SELECT foo
> FROM bar
> WHERE fooID in ('1','2')
>
&
Question about SQL "WHERE IN" syntax:
I know that something like this is fine to do:
(1)
SELECT foo
FROM bar
WHERE fooID in ('1','2')
In the example above, the parenthesis includes the itemized fooID's. But, I
want to do a similar thing where instead of
- Original Message -
From: "Trask" <[EMAIL PROTECTED]>
> I'm trying to configure MySQL and PHP so that PHP can access MySQL for
> function calls and database access. It's my understanding that I need to
> use the command - "mysql_connect(, , );&quo
Hi,
I'm trying to configure MySQL and PHP so that PHP can access MySQL for
function calls and database access. It's my understanding that I need to
use the command - "mysql_connect(, , );"
I tried that and got a syntax error, I tried:
[root@www phpBB2]# mysql_con
icate-rewrite-db
DN> directive. Here's a snippet from my my.cnf file on the slave:
DN> master-port = 3306
DN> replicate-rewrite-db=mysql->master_mysql
DN> When I try to start the instance, I get the following error in my
DN> log:
DN> 021118 14:30:56 mysqld s
* yan zhang
> My MySQL LEFT JOIN Syntax as following is wrong? I
> cannot get the right result.
What result do you get?
> SELECT name, email form T1 LEFT JOIN T2 ON
> T1.Snum=T2.Bnum
Except from the typo form -> FROM, this looks like a valid statement. Do you
get an error?
suggestion:
if you have a windows machine that you can use as
a front end, download a copy of corereader.
http://corereader.com
it lets you create joins by clicking on objects
in your database. you can quickly experiment
with the logic instead of worrying about syntax.
let corereader take
Hi there,
My MySQL LEFT JOIN Syntax as following is wrong? I
cannot get the right result.
SELECT name, email form T1 LEFT JOIN T2 ON
T1.Snum=T2.Bnum
T1(Snum,name,email,address)
T2(Bnum, notes, time)
I wnat ot get the result(name, email, notes).
Any suggestion, comments
le on the slave:
master-port = 3306
replicate-rewrite-db=mysql->master_mysql
When I try to start the instance, I get the following error in my
log:
021118 14:30:56 mysqld started
Bad syntax in replicate-rewrite-db - missing '->'!
021118 14:30:56 mysqld ended
I've tried
r_mysql
When I try to start the instance, I get the following error in my
log:
021118 14:30:56 mysqld started
Bad syntax in replicate-rewrite-db - missing '->'!
021118 14:30:56 mysqld ended
I've tried every possible combination of spaces I could think of, and I've
even
>If the data contains "\", then database will automatically takes "\"
>away and shift 1 byte left.
>My data will mass up. That is why I still need "\"
Does your data actually include backslash characters? If you want to import them as
they are, you definitely don't want to ESCAPE BY them.
Esca
At 12:38 -0500 11/6/02, Vivian Wang wrote:
I tried,
db.query("load data infile '/data/winshare/experian/test' into table
d_adds fields terminated by '' escaped by '' lines terminated by
'\\n'");
db.query("load data infile '/data/winshare/experian/test' into table
d_adds fields terminated by
e what's happening is that Python itself is processing escapes
before passing the query to MySQL, and MySQL itself will then process
escapes. You have to account for the extra level of escape processing.
Try this:
db.query("load data infile '/data/winshare/experian/test' into table
d_a
erian/test' into table
d_adds fields terminated by '' escaped by '' lines terminated by
'\\n'");
At 10:01 AM 11/6/2002 -0600, Paul DuBois wrote:
At 10:03 -0500 11/6/02, Vivian Wang wrote:
I did my testing.
If I use ESCAPED BY '\\', I got
1064, &q
s wrote:
At 10:03 -0500 11/6/02, Vivian Wang wrote:
I did my testing.
If I use ESCAPED BY '\\', I got
1064, "You have an error in your SQL syntax near ''' at line 2"
Using ESCAPED BY '\', then no error and result is fine.
If the data contains "\&
At 10:03 -0500 11/6/02, Vivian Wang wrote:
I did my testing.
If I use ESCAPED BY '\\', I got
1064, "You have an error in your SQL syntax near ''' at line 2"
Using ESCAPED BY '\', then no error and result is fine.
If the data contains "\"
I did my testing.
If I use ESCAPED BY '\\', I got
1064, "You have an error in your SQL syntax near ''' at line 2"
Using ESCAPED BY '\', then no error and result is fine.
If the data contains "\", then database will automatically takes "\
At 14:38 -0500 11/5/02, Vivian Wang wrote:
The syntac ESCAPED BY of load data infile is wrong in
http://www.mysql.com/doc/en/LOAD_DATA.html.
the [ESCAPED by '\\']
should be:
[ESCAPED BY '\']
Why do you say that?
-
Before post
The syntac ESCAPED BY of load data infile is wrong in
http://www.mysql.com/doc/en/LOAD_DATA.html.
the [ESCAPED by '\\']
should be:
[ESCAPED BY '\']
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
---
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
---
-Original Message-
From: Randy Hammons [mailto:rathlon1@;cox.net]
Sent: 26 October 2002 18:45
To: mysql
Subject: mysql access via php function, hlp with syntax
Can someone please tell me what is wrong
Can someone please tell me what is wrong with this function? I can't for
the life of me see an error. But, for some reason I keep getting the
following error:
PARSE ERROR: parse error, unexpected $ in
"d:\web.root\xx_db\inc\functions1.inc on line 28
function is:
function dtb_qry_tbl_dsp($qry,
Christian Reichenbach wrote:
You've a very radical position.
Not really; I don't find it at all radical to think in terms of
'reasonability'. The poster in question believes that adding a feature
to make square brackets work like quotation marks would make the code
base harder to maintain a
>From: Christian Reichenbach <[EMAIL PROTECTED]>
>
We encountered that MySQL (or MyODBC) uses different
quoting characters for legal names and strings.
>>>BSJ> Well, let's put it this way : tables names between
>>>BSJ> square brackets only exists in Microsoft!
>>>That might be right, but th
Hi Jan,
>>>We encountered that MySQL (or MyODBC) uses different
>>>quoting characters for legal names and strings.
>>BSJ> Well, let's put it this way : tables names between
>>BSJ> square brackets only exists in Microsoft!
>>That might be right, but this is how Microsoft works.
JS> I'm sorry, but
>>We encountered that MySQL (or MyODBC) uses different
>>quoting characters for legal names and strings. At present we
>>are using square brackets for names (like [my table], [my column] or
>>[my table].[my column]) and inverted commas for strings
>>(like mytxt = 'text').
>>
>>Is there an option fo
A few months ago I tried to use MySQL as an alternative database
backend for our software product. Currently we are using MS Access and
MS SQL Server.
We encountered that MySQL (or MyODBC) uses different quoting
characters for legal names and strings. At present we are using square
brackets for na
fine.
KC> now when i issue a backup table syntax. it is giving
KC> syntax. Is back table only works in backing up table
KC> in the server or I can make a copy thru a client
KC> software like MyCC
You can make backup using MyCC, but backup files will be located on
server box.
If you get
hello..
i have a winxp and linux 7.2 on the same machine. I
have mysql on the linux server and MyCC in the win
partition.
i connect to the linux MySQL using the vmware lopback
adapter. everything is working fine.
now when i issue a backup table syntax. it is giving
syntax. Is back table only
Dragos,
Monday, October 07, 2002, 7:30:47 PM, you wrote:
DMP> I am trying to run this update statement, but I got an error syntax...near
DMP> offsetCould You please point out what is wrong?
DMP> Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
DMP>
* Dragos Madalin Popa
> I am trying to run this update statement, but I got an error syntax...near
> offsetCould You please point out what is wrong?
>
> Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
> ABBREVIATION is null;
Use t
sql,query
Hi,
I am trying to run this update statement, but I got an error syntax...near
offsetCould You please point out what is wrong?
Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
ABBREVIATION is null;
Thank You,
Best Regard
Scott,
Saturday, October 05, 2002, 7:45:16 AM, you wrote:
SJ> I have a db with slightly over 614,000 records of names and addresses. In
SJ> the address column, there are quite a few records like
SJ> "123 any rd # 2"
SJ> "319 w. 1st st # B"
SJ> "4321 test blvd # 42"
SJ> etc
SJ> I want to replac
You almost got it. Your syntax will be something like this:
UPDATE Table SET address=REPLACE(address,'#','Number') WHERE column
like"%#%"
When I am trying to figure out the syntax for something, I always add a
LIMIT 1 at the end so that only one record gets ch
I have a db with slightly over 614,000 records of names and addresses. In
the address column, there are quite a few records like
"123 any rd # 2"
"319 w. 1st st # B"
"4321 test blvd # 42"
etc
I want to replace all the number signs with the actual word 'number'.
Is there a SQL command I can use
On Monday, September 30, 2002, at 08:44 24h, Gebhardt, Karsten wrote:
> I have two tables
>
> CREATE TABLE pid_segment (
> id INT NOT NULL UNIQUE PRIMARY KEY,
> msg TEXT)
> TYPE=INNODB
>
> CREATE TABLE hl7incom(
> id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES
> pid_segment
> (id
Found solution, the right syntax is:
SELECT hl7incom.id
FROM hl7incom, pid_segment
LEFT JOIN pid_segment
ON hl7incom.id = pid_segment.id
WHERE hl7incom.msg LIKE '%PID%'
AND pid_segment.id IS NULL;
Cheers for try of help,
Karsten
Same result, also if I do not define unique index
Same result, also if I do not define unique index.
Just a suggestion:
SELECT hl7incom.id
FROM hl7incom, pid_segment
WHERE hl7incom.msg LIKE '%PID%'
AND not(pid_segment.id = hl7incom.id)
GROUP BY hl7incom.id;
Otherwise my only other suggestion would involve using the 'NOT IN'
logic, but I think
601 - 700 of 1024 matches
Mail list logo
