Thanks. That fixed the problem. I put all of my DECLARE statements at the
beginning of the procedure. I finally got the thing to compile and it looks
like this:
DELIMITER $$
DROP PROCEDURE IF EXISTS `code_library`.`Search_Code_Samples` $$
CREATE [EMAIL PROTECTED] PROCEDURE `Search_Code_Sampl
Tom,
I think the problem might be that you have to put all the DECLARE
statements at the top before the other statements. It seems like I had
a similar problem with this once.
Hope this helps.
Randall Price
Secure Enterprise Technology Initiatives
Microsoft Implementation Group
Virginia Tech I
Ah! ORDER BY after GROUP by - now it works:
SELECT o.orderid, u.username, o.date, sum( p.price )
FROM order o, users u, order_item oi, product p
WHERE o.userid = u.id
AND o.orderid = oi.orderid
AND oi.productid = p.productid
AND o.status = 'new'
GROUP BY o.orderid
ORDER BY o.date DESC , o.statu
Hi Mark.
On Fri, 7 Apr 2006, Mark Sargent wrote:
> To: mysql@lists.mysql.com
> From: Mark Sargent <[EMAIL PROTECTED]>
> Subject: Syntax Error
>
> Hi All,
>
> am trying to get up to speed on cli syntax again,
>
> mysql> show open tables from osc
> ->
>
> what is wrong with the command above a
Hi All,
Ah, sorry, a semicolon makes it a whole new world, eh.
Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
"warwick mayson" <[EMAIL PROTECTED]> wrote:
>
> I am new to mysql and have a create script that when sourced throws a syntax error.
>
> The script :
>
> CREATE TABLE employee (
> id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
> name VARCHAR(255) NOT NULL,
> PRIMARY KEY(id)
> )
> TYPE=InnoDB;
>
In the last episode (Mar 06), Lou Ann Hammond said:
>
> Hail,
> Below is the table that is generating the following error:
>
> LOAD DATA LOCAL INFILE '/www/htdocs/car-list/admin/8_rows_dealerX_test.csv'
> REPLACE INTO TABLE carlist_db.e_xoops_dealerX_cardealers FIELDS TERMINATED
> BY '\t' LINES
-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 I just post the pa
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
- 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(, , );"
>
> I tried that and got a syntax error, I
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 th
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 ta
Perhaps the INSERT_METHOD functionality was introduced in 4.0 but the
merge tables themselves work in later 3.23 versions. If this is the
case the documentation needs to be updated to show which version
supports what.
Eric
On Sat, 20 Apr 2002, Benjamin Pflugmann wrote:
> Hi.
>
> AFAIK, insert
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 PROTE
On Sat, 20 Apr 2002 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and inclu
Hi,
Try to change the alias - group is a reserved word and it is causing the syntax error
This one should work
SELECT members.name, gr.id, gr.name
FROM members
LEFT JOIN members AS gr
ON gr.id = members.group_id
WHERE members.id = 6
Dobromir Velev
Web developer
http://www.websitepulse.com/
-
> Here's the simplified query:
>
> SELECT members.name, group.id, group.name
> FROM members
> LEFT JOIN members AS group
> ON group.id = members.group_id
> WHERE members.id = 6
>
>
> And here's the error I get:
>
> You have an error in your SQL syntax near 'group ON group.id =
> me
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
I don't see any ticks surrounding userid...unless of coarse userid is a
number??
Also, myResultSet, is that public? If not, are you returning it? (I'm not
familiar with Java, so not sure if you need to or not)
- Original Message -
From: "Ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Kill the final comma, i.e.
...
SET SailPort = ?,
SailDate = ?,
Deleted = ?
WHERE ...
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Don [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 23, 2001 13:24
> T
21 matches
Mail list logo
