We developed a site using PHP and MYSQL on an online shared server. We used
HEAP tables extensively and everything worked fine. When we moved the site
to our dedicated server prior to launching the site, the queries that
should create the HEAP tables return syntax errors (when submitting the
payid and p.badcheck != '0.00')
>>I've been trying to figure out where I might be going wrong with this SQL syntax:
>>
>>select format(sum(p.badcheck)+ (count(p.badcheck)*-15)) as Badcheck
>>from payout p,payhistory ph
>>where ph.paydate between '
I've been trying to figure out where I might be going wrong with this SQL
syntax:
select format(sum(p.badcheck)+ (count(p.badcheck)*-15)) as Badcheck
from payout p,payhistory ph
where ph.paydate between '2001-09-20' and '2001-09-30'
and (p.payid = ph.payid and p.badche
>Description:
There is duplication in the syntax of INSERT. Last version is special case of the
second.
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...),(...),...
or INSERT [LOW_PRIOR
MySQL to return with the syntax "TABLENAME.FIELDNAME",
and not just "FIELDNAME" ?
I know that you can use aliases to get a similar effect but it's a hassle to
write sql's like this :
SELECT table1.f1 as 'table1.f1',table2.f1 as 'table2.f1' F
Tom Churm ([EMAIL PROTECTED]) writes:
> hi,
>
> i've got a table collecting info from html forms. problem is, certain
> wiseguys always make multiple entries. could someone clue me in to how
> i can select the Last entry where there is a duplicate for the User
> (type text, these are email add
hi,
i've got a table collecting info from html forms. problem is, certain
wiseguys always make multiple entries. could someone clue me in to how
i can select the Last entry where there is a duplicate for the User
(type text, these are email addresses), and automatically delete any
previous entr
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' IDENTIFI
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,
At 5:18 PM -0700 8/23/01, Igbar Foosenhopper wrote:
>Is it possible to use current_date (mysql function) to generate a
>default for a column?
No. Defaults must be constants.
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
>
>If so .. what would the syntax look like. I have t
Is it possible to use current_date (mysql function) to generate a
default for a column?
If so .. what would the syntax look like. I have tried several things
and it doesn't seem to like it.
If not .. how could I generate a default of todays date (of course
dependent on the date of i
Thanks for pushing me in the right direction :) It turns out that it
wasn't the semicolon on the end of $sql_query -- it was the newline. I had
been invoking it as follows:
./rundatabasequery.cgi
sql_query=SELECT+*+FROM+newssites_dynamicdata%3B%0D%0A
and the "%0D%0A" was a hex-encoded newline
On Sunday 12 August 2001 01:01, Bennett Haselton wrote:
> I've written a CGI script that runs a database query on a MySQL database (I
> know that's risky -- it's password-protected though, for what it's
> worth). (...)
It's a free world ;-)
> When I run the script with the first of these two lin
Mark:
the key to this puzzle is the separator, the ';'
for your first question, you need to find the ';' followed by a 6. not just
any ';', but the first ';'
the pattern would be "^[0-9]*;6"
which says
^ find beginning of line
[0-9]* followed by zero or more instance
Date |Thu, 26 Jul 2001 21:11:20 +0100
>From |"Graham Nichols" <[EMAIL PROTECTED]>
Hello!
GN> Hi Grigory,
GN> your query below only runs without error if I leave out the word DISTINCT.
>> SELECT web_date, dayofmonth(web_date) AS d, COUNT(DISTINCT IP_address) AS c
>> FROM web_stats GROUP BY d OR
N> which does not give me time to upgrade.
GN> I have a small table 'web-stats' consisting of the following fields:
GN> IP_address
GN> web_date
GN> web_time
GN> web_referer
GN> browser
GN> page
GN> I am using a PHP script to insert entries into this table
pt to insert entries into this table as a rudimentary
hit counter.
My current syntax is
select web_date, dayofmonth(web_date) as d, count (IP_address) as c from
web_stats group by d order by web_date
but what I actually want is to count the unique IP addresses for each date.
How can I work aroun
ble 'web-stats' consisting of the following fields:
>
> IP_address
> web_date
> web_time
> web_referer
> browser
> page
>
> I am using a PHP script to insert entries into this table as a rudimentary
> hit counter.
> My current syntax is
>
> select we
Hi,
Trying to get to grips with regexp but really want to 1st get a simple
expression working with mysql.
SELECT Sequence, Message, id FROM $sqlTable WHERE Sequence
REGEXP(\"^$filterValue;\")
The above works for finding matched values, where the number = to
$filterValue is in in the 1st part
ddress
web_date
web_time
web_referer
browser
page
I am using a PHP script to insert entries into this table as a rudimentary
hit counter.
My current syntax is
select web_date, dayofmonth(web_date) as d, count (IP_address) as c from
web_stats group by d order by web_date
but what I actually want is to c
: "Zbigniew Szczesny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 5:40 PM
Subject: Please help with syntax !!!
Hello !
This is a syntax taken from MS Access:
SELECT messages.message_id, messages_1.message_id
FROM messages AS messages_1 INNER JOI
parent messages which have no children (via "connections") or not.
If so, you would need to enhance the suggested SQL with some MySQL version
of INNER or OUTER join syntax.
At 05:40 PM 7/25/2001 +0200, Zbigniew Szczesny wrote:
>Hello !
>
>This is a syntax taken from M
Hello !
This is a syntax taken from MS Access:
SELECT messages.message_id, messages_1.message_id
FROM messages AS messages_1 INNER JOIN (messages INNER JOIN connections ON
messages.message_id = connections.parent) ON messages_1.message_id = connections.child
ORDER BY messages.message_id
sage -
From: "Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Sara" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 22, 2001 7:11 PM
Subject: Re: syntax problem
> > I rather thought that this was the whole purpose of this mailing list?
>
&g
> I rather thought that this was the whole purpose of this mailing list?
You are right both in your inquiry and in your reply to Sinisa.
It is not his usual way, though, I was astonished myself.
I think most is ok. Try
select handicap_results.date,
handicap_results.victor,
handic
after all trying to learn mysql and am a beginner.
Regards
Sara
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 22, 2001 11:22 AM
Subject: Re: syntax problem
> Sar
I did get the sql query script and thought I could run it in Mascon itself
>and export the data table to excel which would do for now.
>
> However, this syntax appears to produce exactly the query I want in the report tool
>but doesn't appear to work when cut and past into the sql
run it in Mascon itself
and export the data table to excel which would do for now.
However, this syntax appears to produce exactly the query I want in the report tool
but doesn't appear to work when cut and past into the sql query option in mascon.
Can you tell me where the query is wrong p
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 21, 2001 12:33 PM
Subject: Mysql syntax
> If I wanted to asssign John Doe to system1, how would I write the
statement in sql to pull the sysid from the > system table via the sy
I have been trying to figure out how to do this, and I am sure that I am just
overlooking somthing small.
Suppose I create two tables as follows:
CREATE TABLE system (
sysid INT NOT NULL UNSIGNED AUTO_INCREMENT PRIMARY KEY,
sysname VARCHAR(12),
os VARCHAR(10),
cpumhz INT
);
CRE
- Original Message -
From: "Philippe L. Houze" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 8:09 AM
Subject: MySQL: Multiple INSERTS syntax ...
> When running: INSERT INTO customers3 (firstname) select TRIM(trailing
> char(10) FR
Hi,
I found syntax for INSERT command in both Paul DuBois excellent book and
online manual but for single insert. And it works... which for a newbie like
me is thrilling. But, I am stuck for multiple inserts.
I am trying to remove from a database trailing characters (ascii 10) that
have shown
MySQL uses the LEFT JOIN, RIGHT JOIN Syntax ...
RTFM: http://www.mysql.com/doc/J/O/JOIN.html
> -Ursprüngliche Nachricht-
> Von: Bruce Stewart [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 16. Juli 2001 11:54
> An: Mysql-Help (E-mail)
> Betreff: Outer join syntax
outer joins be expressed in the FROM clause as they can
in Oracle (using (+)) and MSSQL (using '*=' or '=*')? What is the syntax?
I think I have looked through the documentation thoroughly enough, that this
question is not a waste of anyone's time. If this is dealt w
.1443|
||
--
|__|__|
|| ||
ooO Ooo
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 12:58 PM
To: Werner Stuerenburg
Cc: [EMAIL PROTECTED]
Subject: Re: Join syntax
I have two databases (db1 e db2) on different hosts (host1 e host
This topic really interested me.
Can an expert of the list explain a good approach handle distributed system
with distributed databases?
thanks
siomara
>From: <[EMAIL PROTECTED]>
>To: Werner Stuerenburg <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Join s
wouldn't have problem, because the
table_reference would be "db1.table1 AS t1, db2.table2 AS t2". But as they are
on different machines, I didn't know the syntax of the table_reference or even
if it was possible.
Thanks,
Rodney
Werner Stuerenburg <[EMAIL PROTECTED]&
D]
> Cc: [EMAIL PROTECTED]
> Subject: Fwd: Join syntax
>
>
> Is it possible to join two tables from different databases that are located
> on different hosts?
>
> Thanks,
>
> Rodney
>
>
>
> -
&
As it seems, it is not possible. You would have to have a
connection which talks to two databases at once, which may not be
possible at all, at least create numerous problems.
But I think it should be possible to create a temporary table in
db 2 and copy the table from db1 into it, then do a join
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Mon, Jul 09, 2001 at 09:29:00PM -0300, Rodney A. Ramos wrote:
>
> Is it possible to join two tables from different databases that are
> located on different hosts?
Nope.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454C
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
> Is it possible to join two columns from different databases
Yes.
> located on differents hosts?
No. Why do you want to do this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Is it possible to join two columns from different databases located on
differents hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
You are the man...thanks a bunch! that's what I needed.
=
r a n d y / sesser at mac.com
> From: "Rolf Hopkins" <[EMAIL PROTECTED]>
> Date: Fri, 6 Jul 2001 14:39:59 +0800
> To: "{ randy }" <[EMAIL PROTECTED]>, "MySQL&
that are in B
but not in A.
- Original Message -
From: "{ randy }" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 14:05
Subject: Re: Syntax question for a beginner..
> Well, I think I got it figured out. I am using PHP,
ow you can't do nested selects :\
- randy
=
r a n d y / sesser at mac.com
> From: "Rolf Hopkins" <[EMAIL PROTECTED]>
> Date: Fri, 6 Jul 2001 13:57:27 +0800
> To: "{ randy }" <[EMAIL PROTECTED]>, "MySQL" <[EMAIL PROTECTED]
both tableA and tableB, without the duplicates.
- Original Message -
From: "{ randy }" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 12:28
Subject: Syntax question for a beginner..
> Alright, I am about to pull my hair out.
.
Black Holes The End of The Universe?
John G. Taylor PG 11. Line 1
-Original Message-
From: { randy } [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 10:29 PM
To: MySQL
Subject: Syntax question for a beginner..
Alright, I am about to pull my hair out.
I have 2 tables. Each have
I had never seen "WHERE NOT" before.
Does this exist in mysql
siomara
>From: Shania Qiu <[EMAIL PROTECTED]>
>To: '{ randy }' <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: RE: Syntax question for a beginner..
>Date: Fri, 6 Jul
I remember somewhere has mentioned that MySQL does not copy with nested
SELECT query. Properly it is the reason.
Shania Qiu
-Original Message-
From: { randy } [mailto:[EMAIL PROTECTED]]
Sent: Friday, 6 July 2001 4:29 p.m.
To: MySQL
Subject: Syntax question for a beginner..
Alright
l FROM tableA WHERE NOT (email IN(SELECT email FROM
tableB));
Now, this gives me an error at the second SELECT. I have been trying
different ways, but no go. I got the general syntax from a friend, but I
could not get it to work. Is my syntax just wrong?
mysql Ver 11.13 Distrib 3.23.36, for -fre
MySQL doen not yet support nested queries.
Jawad Khan wrote:
> server version 3.23.35
>
>
>> -Original Message-
>> From:Khan, Jawad [COLE:6S34:EXCH]
>> Sent:Thursday, June 28, 2001 1:13 PM
>> To: '[EMAIL PROTECTED]'
&
On 28-Jun-01 Jawad Khan wrote:
> Hope you can find the problem in the following SQL command:
>
> delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
> limit 1 ;
>
That is a sub-select, currently unsupported in MySQL.
try :
delete from alarms order by raiseTime limit 1;
server version 3.23.35
> -Original Message-
> From: Khan, Jawad [COLE:6S34:EXCH]
> Sent: Thursday, June 28, 2001 1:13 PM
> To: '[EMAIL PROTECTED]'
> Subject: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete
> as shown
>
> Ho
Hope you can find the problem in the following SQL command:
delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
limit 1 ;
raiseTime is of type BIGINT.
inal Message -
> From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
> To: "MySQL" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 27, 2001 2:47
> Subject: Conversion from Access JOIN syntax to MySQL JOIN syntax...
>
> > Yes, I've read the
2:47
Subject: Conversion from Access JOIN syntax to MySQL JOIN syntax...
> Yes, I've read the docs on JOIN syntax, and search the list archives for
> similar information.
>
> I have this query:
>
> SELECT leg_activity.activity_date, leg_transitions.trans_desc,
> leg_text.le
Yes, I've read the docs on JOIN syntax, and search the list archives for
similar information.
I have this query:
SELECT leg_activity.activity_date, leg_transitions.trans_desc,
leg_text.leg_version, body_list.body_name
FROM (((leg_version_hist RIGHT JOIN (leg_comm_hist RIGHT JOIN leg_act
Here it goes. This is a small schema of the two tables.
Table Employees
i_recid = auto increment UNIQUE KEY
First Name
Last Name
ETC.
Table Contracts
sales_rep = e.i_recid
Contract Date = date of contract
Office = office
So here is what i am trying to do.
Run a
CTED]]
Sent: den 30 maj 2001 15:09
To: [EMAIL PROTECTED]
Subject: Servlet SELECT Query syntax error
Hi
Error message "You have error in your SQL syntax" ... Using Apache Tomcat -
MySQL in Win 2000.
Scenario: Servlet collects form data value, sends query to MySQL, returns
search. The problem
Hi
Error message "You have error in your SQL syntax" ... Using Apache Tomcat -
MySQL in Win 2000.
Scenario: Servlet collects form data value, sends query to MySQL, returns
search. The problem is getting
the value of the inputted parameter named, title_name. Problem c
this.password = newPassword;
}
public String getPassword() {
return password;
}
}
***
>From: "Cal Evans" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>CC: <[EMAIL
If that's an exact quote then you left off the opening quote marks.
Cal
http://www.calevans.com
-Original Message-
From: Li Bing [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 19, 2001 4:14 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: The Syntax to Get JDBC Connection
Dear All,
I use mm.mysql.jdbc to access mysql in Java. To get the connection, the
following sentence is writen in my program. But an error occurred.
I guess that the syntax is wrong. Could you please give me the correct
one.
Connection conn =
DriverManager.getConnection(jdbc:mysql://localhost
-
> From: "Mark Rowlands" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, May 17, 2001 3:11
> Subject: create table with select syntax error problem
>
> > CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10)
&
Original Message -
From: "Mark Rowlands" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 3:11
Subject: create table with select syntax error problem
> CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(
rator does not
> return any results, and the <=> operator returns a syntax error at the >. I
> am hopelessly confused.
>
> SELECT
> listings.lid,listings.Price,Area.Area,listings.Description,listings.Sold,lis
> tings.MLS_Number FROM listings LEFT JOIN Companies ON
CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10)
unsigned DEFAULT '0' NOT NULL,PRIMARY KEY (sajtid)) select
log.sajtid,count(*) from log,sajter where log.sajtid=sajter.id and log.mon =
5 group by log.sajtid;
the create table on its own works, the select statement works,
any results, and the <=> operator returns a syntax error at the >. I
am hopelessly confused.
SELECT
listings.lid,listings.Price,Area.Area,listings.Description,listings.Sold,lis
tings.MLS_Number FROM listings LEFT JOIN Companies ON
(listings.cid=Companies.cid) LEFT JOIN Area ON (list
no , i havn't any key with AUTO_INCREMENT option
i wont numbered my rows on fly! how to do it.
pleease help me!!!
RT> supposed you numbered all rows in the table incrementally in field nid:
RT> select mydata from mytable where mod(nid, N)=offset;
RT> fill in N and offset (0..n-1)
RT> On Sat, 28
>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 12:17 PM
Subject: Syntax error
>
> hi everyone in this group, i am getting lately mysql syntax error when i
run query from JSP page. here is sample code:
>
> public selectMyPass (String userid) {
>
> St
hi everyone in this group, i am getting lately mysql syntax error when i run query
from JSP page. here is sample code:
public selectMyPass (String userid) {
String myQuery = "select pass from datainfo where id=";
myQuery.concate(myQuery,userid);
myResultSet = stmt.executeQue
supposed you numbered all rows in the table incrementally in field nid:
select mydata from mytable where mod(nid, N)=offset;
fill in N and offset (0..n-1)
On Sat, 28 Apr 2001 14:26:46 +0400
Igor V Yermakov <[EMAIL PROTECTED]> wrote:
> i have 400 rows in my mysql database table
> and i wont ge
i have 400 rows in my mysql database table
and i wont get each N row from table (say each sixth row)???
please help me???
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
Hi,
here is
public void
String myQuery = "SELECT password from customerinfo where username=";
myQuery.concat(myQuery,
-
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
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 wan
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), team.spons
= 'ACT' or custmls.listingstatus = 'A*') AND
>custmls.scategory = 1 ORDER 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 "
&g
ls.scategory = 1 ORDER 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 I
select word, count(word) as total
from search_words
where word is not null
group by word
order by total desc
limit 20
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 1:36 PM
To: [EMAIL PROTECTED]
Subject: Correct syntax?
Thanks for help
"select word, count(word) as total from search_words where word IS
NOT NULL group by word order by total desc limit 20"
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Thu, 19 Apr 2001, Graham Nichols wrote:
> Thanks for help from this group I'm using
>
> "sel
Thanks for help from this group I'm using
"select word, count(word) as total from search_words group by word order by
total
desc limit 20"
to locate the top 20 words in a database of website search engine words.
The database had been altered to include an extra column, other than the
'word' col
nce >> CREATE TABLE..
* 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
Hi,
How use CHECK constraint in a CREATE TABLE declaration ??
The language used is MySQL
Indeed, i try many attempt but no success... Somebody could help me ??
I try to do that :
create table Picsou (
name varchar(5)
check (name=='fifi' or name=='riri' or name=='loulou')
)
;
Bu
CTURE`,`telstrasaturn`.`EXPDATE`,`telst
rasaturn`.`PRNREC` FROM "telstrasaturn" FOR UPDATE "
SDWORD 363
DIAG [42000] [TCX][MyODBC]You have an error in your SQL syntax near
'"telstrasaturn" ' at line 1 (1064)
--
What workaround do I hav
"Thalis A. Kalfigopoulos" wrote:
> Check you don't have empty strings as empty remarks, but that you have NULLs.
> Even with empty strings as remarks though you can bypass them with an extra WHERE
>condition :-)
That was it. I was storing empty strings, instead of NULLs. Thanks!
AMK4
On Thu, 5 Apr 2001, Ashley M. Kirchner wrote:
> "Thalis A. Kalfigopoulos" wrote:
>
> > > +--++--+-+
> > > | task | comment |remarks | history |
> > > +--++--+-+
> > > | task_1 | cmt_1
"Thalis A. Kalfigopoulos" wrote:
> > +--++--+-+
> > | task | comment |remarks | history |
> > +--++--+-+
> > | task_1 | cmt_1| rmk_1| |
> > | task_1 | cmt_2
On Wed, 4 Apr 2001, Ashley M. Kirchner wrote:
>
> Db -> table1, table2 and table3
>
> SELECT table1.task, table2.comment, table2.remarks, table3.history
> FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
> LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
>
> Resul
Db -> table1, table2 and table3
SELECT table1.task, table2.comment, table2.remarks, table3.history
FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
Results (roughly) in:
+--++--+-
001, James
> Salinas wrote:
>
> > Hi,
> >
> > My problem is specifically concerning syntax for mysqldump.
> > I can successfully execute the following SQL commands from within MYSQL:
> >
> > mysql> USE cDatabase
> > mysql> SELECT * INTO OUTFILE &quo
fter
pressing ENTER. If you want this to happen at night,
execute the job via cron.
I hope this helps.
Andrew Gould
--- James Salinas <[EMAIL PROTECTED]> wrote:
> Hi,
>
> My problem is specifically concerning syntax for
> mysqldump.
> I can successfully execute the follo
mysql --username=xxx --password=xxx -e "SELECT * INTO OUTFILE
"/root/cTable-data.dump" FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM cTable WHERE
myfield='1'" dbname
On Wed, 4 Apr 2001, James
Salinas wrote:
> Hi,
>
> My
Hi,
My problem is specifically concerning syntax for mysqldump.
I can successfully execute the following SQL commands from within MYSQL:
mysql> USE cDatabase
mysql> SELECT * INTO OUTFILE "/root/cTable-data.dump"
-> FIELDS TERMINATED BY ',' ENCLOSED BY '&q
Db -> table1, table2 and table3
SELECT table1.task, table2.comment, table2.remarks, table3.history
FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
Results (roughly) in:
+--++--+-
ROTECTED]>
Sent: Monday, March 19, 2001 11:44 PM
Subject: RE: [OT] SQL syntax qestion
> Hi,
>
> Yes, in MySQL you can go
>
> select handle, sum(total) as t group by handle order by t;
>
> in ANSI (?) you can go
>
> select handle, sum(total) group by handle order
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
901 - 1000 of 1024 matches
Mail list logo