On 29/02/12 12:38, Brown, Charles wrote:
Hello,
Can someone give me syntax to create a user called starsky and password hutch
with the following objectives:
- user the minimum to run back scripts
- user has the minimum to lock tables
- user has the minimum to do SELECT on tables
Thx
**
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
--- Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Stephen Liu wrote:
> >> If you want to
> >> get rid of the user entirely, use DROP USER.
> >
> > Could you please explain in more detail??? Where shall I add "DROP
> > USER"
>
> The manual always explains the full syntax (http://dev.mysql.com/),
Stephen Liu wrote:
If you want to
get rid of the user entirely, use DROP USER.
Could you please explain in more detail??? Where shall I add "DROP
USER"
The manual always explains the full syntax (http://dev.mysql.com/), but in
brief,
DROP USER 'vmailuser'@'localhost';
will remove the use
--- Baron Schwartz <[EMAIL PROTECTED]> wrote:
> OK, the privileges are gone. USAGE is a synonym for "no privileges."
Noted with tks.
> If you want to
> get rid of the user entirely, use DROP USER.
Could you please explain in more detail??? Where shall I add "DROP
USER"
> > To safe guard,
Stephen Liu wrote:
mysql> SHOW GRANTS FOR 'vmailuser'@'localhost';
+--+
| Grants for [EMAIL PROTECTED]
Hi Baron,
> > I suppose it has been done ???
>
> Yes, but you can check with SHOW GRANTS FOR 'vmailuser'@'localhost'
> to be sure.
mysql> SHOW GRANTS FOR 'vmailuser'@'localhost';
+
Hi,
Stephen Liu wrote:
Hi Baron,
Tks for your advice.
To undo this GRANT, run
REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
mysql> REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql>
Hi Baron,
Tks for your advice.
> To undo this GRANT, run
>
> REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
> 'vmailuser'@'localhost';
mysql> REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql>
I suppose it has bee
Hi Stephen,
Stephen Liu wrote:
Hi folks,
OpenBSD 4.0 x86_64
Mysql
Postfix_2.4.3
After running following command;
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON test.* TO
'vmailuser'@'localhost' IDENTIFIED BY 'password123';
Query OK, 0 rows affected (0.00 sec)
I found I made a mistake to r
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
Field was wrongly named - Cheers!
--
View this message in context:
http://www.nabble.com/Syntax-Problem-tf2779708.html#a7756233
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
> I have a query running within a project from a Windows machine retrieving
> data from a Linux Source the query works perfectly. If i upload the exact
> same project to the Linux machine and run it the query doesnt work ??!!??
>
> the query string is ...
>
> SELECT DISTINCT ID, BatchID FROM Conta
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]
>Create table events (
>uid BIGINT NOT NULL AUTO_INCREMENT,
>name VARCHAR(255),
>start_date DATE,
>duration INTEGER,
>location_id BIGINT,
>primary key (uid)
>);
>
>Create table locations (
>uid BIGINT NOT NULL AUTO_INCREMENT,
>name VARCHAR(255),
>address VARCHAR(255),
>primary key (uid)
>)
>
>Alter
Michael Immerman <[EMAIL PROTECTED]> wrote on 11/25/2005 11:52:47 AM:
> I have a query that works perfectly in version 4.1.10a-nt however it
> fails in version
>4.0.24. If someone has any ideas on how to fix the query to run
> in 4.0.24, I would really appreciate it! Thanks - code below:
>
Hello.
Unfortunately, you can bind only to a single specific address.
Daniel Schaerli wrote:
> Hi,
>
> How is the sintax to in my.cnf listen only to specified ip-addresses or
> ip-ranges? I tried:
> bind_address 127.0.0.1 192.168.0.10 192.168.0.20
> and
> bind_address 127.0.0.1, 19
Hello.
> Question 1: How do I check my syntax against the version and distribution
> that I am
> running?
In manual it is usually said which features are available as of which
version. Use the special form of comments to adopt your queries to
corresponding version. See:
http://dev.m
Hello.
Select syntax is correct on my 4.1.10a MySQL instance.
EXPLAIN is telling me 'Impossible WHERE' until I put
values in the tables so the query could produce at
least several rows. After that everything was OK.
Graham Anderson <[EMAIL PROTECTED]> wrote:
> this sql works on mys
"Sue Cram" <[EMAIL PROTECTED]> wrote on 02/08/2005 01:18:48 AM:
> Thanks to the people who helped me with my IF statement question
> last night. Now I need to carry it one step further to a compound
> 'IF' statement. Again, can't find much information in the manuals --
>
> Several people sent
Harald Fuchs wrote:
That's correct, but it can be written shorter and clearer:
CASE Lccation
WHEN 1 THEN 'Downstairs Cat Room'
WHEN 2 THEN 'Kitten Room'
WHEN 3 THEN 'Quarantine'
ELSE 'Unknown' END AS Location
- surely it would be better to have the location ids and location names
in a lookup ta
In article <[EMAIL PROTECTED]>,
Johan Höök <[EMAIL PROTECTED]> writes:
> Hi,
> I guess your "CASE" statement should look something like:
> CASE WHEN Location=1 THEN 'Downstairs Cat Room'
> WHEN Location=2 THEN 'Kitten Room'
> WHEN Location=3 THEN 'Quarantine'
> ELSE 'Unknown' EN
I didn't found an IF ... ELSE ... in MySQL ... and I'm using it for at
least 4 years !... since the old 3.23.xx times !!!
So you will have to do:
SELECT a,b,c,
IF(Location=1, 'Downstairs Cat Room',
IF(Location=2, 'Kitten Room',
Hi,
I guess your "CASE" statement should look something like:
CASE WHEN Location=1 THEN 'Downstairs Cat Room'
WHEN Location=2 THEN 'Kitten Room'
WHEN Location=3 THEN 'Quarantine'
ELSE 'Unknown' END AS Location
/Johan
Sue Cram wrote:
Thanks to the people who helped me with my IF state
I did a lot of homework on IF statements recently.
Below are copies of some of the scripts I'm using now.
This first example draws on a database filled with the
names of the world's continents, oceans, nations and
states, each given an ID in a field named IDArea. Each
page on my site has an echo s
> -Original Message-
> From: Jeremy Cole [mailto:[EMAIL PROTECTED]
> Sent: den 4 februari 2005 22:24
> To: Thomas Sundberg
> Cc: mysql@lists.mysql.com
> Subject: Re: Syntax diagram, where is it located in the doc?
>
> Hi Thomas,
>
> > I'm lookin
Hi Thomas,
I'm looking for the syntax diagram for MySQL and can't find it. I have
Just to give you a complete answer to your question, this is what is
valid (I've stripped out the C code parts to leave just the definition):
where_clause:
/* empty */
| WHERE expr
expr: expr_expr
en 4 februari 2005 14:19
To: Thomas Sundberg
Cc: mysql@lists.mysql.com
Subject: Re: Syntax diagram, where is it located in the doc?
From the manual, "where_definition consists of the keyword
WHERE followed by an _expression_ that indicates the condition
or conditions that rows must satisfy t
Hello.
May be it is not exactly what you want, but usually, I look at
the sql/sql_yacc.yy in a source distribution.
"Thomas Sundberg" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I'm looking for the syntax diagram for MySQL and can't find it. I have
> downloaded the entire MySQL manual as one
"Thomas Sundberg" <[EMAIL PROTECTED]> wrote on 04/02/2005
13:48:03:
> It is very simple but absolutely not straight forward. It really doesn't
say
> anything. Just that you should do things right and then you will not
have
> any problems.
> The concrete problem I tried to solve were if MySQL su
> -Original Message-
> From: Thomas Sundberg > Sent: Friday, February 04, 2005 07:48
> To: mysql@lists.mysql.com
>
>
> > -Original Message-
> > From: Michael Stassen > > Sent: den 4 februari 2005 14:19
> > To: Thomas Sundberg
> > Cc: mysql@lists.mysql.com
> >
> > From the manu
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> Sent: den 4 februari 2005 14:19
> To: Thomas Sundberg
> Cc: mysql@lists.mysql.com
> Subject: Re: Syntax diagram, where is it located in the doc?
>
> From the manual, "where_defin
"Thomas Sundberg" <[EMAIL PROTECTED]> wrote on 04/02/2005
12:46:02:
>
> > > Does anybody at the list know the answer to my question? I
> > sent it a
> > > few days ago and haven't received any response. It does
> > exist a syntax
> > diagram
> > > for MySQL, doesn't it?
> >
> > Since no-one
you told us why you
need this, someone could provide you with the answer you need.
Michael
Thomas Sundberg wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: den 4 februari 2005 12:45
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Syntax diag
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: den 4 februari 2005 12:45
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Re: Syntax diagram, where is it located in the doc?
>
> "Thomas Sundberg" <[EMA
"Thomas Sundberg" <[EMAIL PROTECTED]> wrote on 04/02/2005
11:39:12:
> Hi!
>
> I'm looking for the syntax diagram for MySQL and can't find it. I have
> downloaded the entire MySQL manual as one html page and searched it for
the
> definition of where_definition and I cant find it. Could somebody
Try SELECT SUBSTRING(AnimalName, 1, 1)
MySQL wants the "(" to immediately follow the function i.e. no spaces.
-Original Message-
From: Sue Cram [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 03, 2005 9:28 AM
To: mysql@lists.mysql.com
Subject: Syntax Failures with SELECT SUBSTRING - H
> >
> > I think you need to do something like this:
> >
> > select t1.data
> > from table1 t1 inner join table2 t2 on t1.zip = t2.zip
> > where t2.chain like '%carmike%';
>
> i tried this one... it seams to work. i'll read a bit more about joins ..
> thank you... appreciate it...
>
You're welcom
>
> - Original Message -
> From: "kalin mintchev" <[EMAIL PROTECTED]>
> To: "Adam" <[EMAIL PROTECTED]>
> Cc: "MySQL General" <[EMAIL PROTECTED]>
> Sent: Sunday, November 14, 2004 11:33 PM
> Subject: Re: syntax quest
- Original Message -
From: "kalin mintchev" <[EMAIL PROTECTED]>
To: "Adam" <[EMAIL PROTECTED]>
Cc: "MySQL General" <[EMAIL PROTECTED]>
Sent: Sunday, November 14, 2004 11:33 PM
Subject: Re: syntax question..
>
> > Kalin,
>
> Kalin,
>
> Kalin> thanks to all... yes, Rhino - i'm new. my first
> Kalin> post. the version is the problem indeed. it's
> Kalin> 4.0.13-standard. how would i achieve the same
> Kalin> query in this version?...
>
> You'll need to provide the following:
>
> (1) What is the result you want to achi
Kalin,
Kalin> thanks to all... yes, Rhino - i'm new. my first
Kalin> post. the version is the problem indeed. it's
Kalin> 4.0.13-standard. how would i achieve the same
Kalin> query in this version?...
You'll need to provide the following:
(1) What is the result you want to achieve?
(2) What are
thanks to all... yes, Rhino - i'm new. my first post.
the version is the problem indeed. it's 4.0.13-standard.
how would i achieve the same query in this version?...
thank you..
> Hi
> sub selects are only supported from MySql 4.1 onwards, so it may be invalid
> if you have an earlier version.
>
- Original Message -
From: "kalin mintchev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 14, 2004 6:05 PM
Subject: syntax question..
> hi everybody..
>
> can somebody please explain what is wrong with this command:
> select t1.data from table1 as t1 where t1.zip=(s
- Original Message -
From: "kalin mintchev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 14, 2004 6:05 PM
Subject: syntax question..
> hi everybody..
>
> can somebody please explain what is wrong with this command:
> select t1.data from table1 as t1 where t1.zip=(s
On Sunday 14 November 2004 05:05 pm, kalin mintchev wrote:
> can somebody please explain what is wrong with this command:
> select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2
> where t2.chain like "%carmike%");
If your no usiing 4.1, subselects are not even allowed..
If so
Hi
sub selects are only supported from MySql 4.1 onwards, so it may be invalid
if you have an earlier version.
you may also cause a conflict by using the database alias (t1) as the name
of the result
Peter
> -Original Message-
> From: kalin mintchev [mailto:[EMAIL PROTECTED]
> Sent: 14
At 15:42 -0700 4/21/04, cristopher pierson ewing wrote:
Apologies if this is an easy one, I'm stumped!
I'm having some trouble with syntax running MySQL from the command line.
I'm running MySQL 4.1.1-alpha from the OS X standard installer package on
a G5 running panther.
I have logged into MySQL
"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;
>
AIL PROTECTED]>
To: "'Eric Ellsworth'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 27, 2004 10:09 AM
Subject: RE: Syntax Check: Group BY with Joins
> Eric
>
> Try putting the "HAVING" clause after group by. I believe
>
Eric
Try putting the "HAVING" clause after group by. I believe
"having" is the last clause (may be LIMIT).
David
> -Original Message-
> From: Eric Ellsworth [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 27, 2004 8:01 AM
> To: [EMAIL PROTECTED]
> Subject: Syntax Check: Group BY with
Hi Trevor,
I think that query might work as-is in MySQL 4.1. However, the current
production version doesn't support subqueries. Your query can be
rewritten with a join like this I think:
SELECT C.*, COUNT(*) AS LINK_COUNT FROM Categories C
INNER JOIN Links L ON (L.CAT_ID=C.CAT_ID AND L.LINK_APPR
At 1:08 PM -0600 9/19/03, Stout, Jeff wrote:
I have added data into MySQL server 4.0.15
INSERT INTO userdata (userid, password)
VALUES ('user', AES_ENCRYPT ("user","password")
I'm having trouble doing the decrypt
SELECT userid, password (AES_DECRYPT)
FROM userdat
On Mon, 16 Jun 2003 12:45:53 -0400, Martin's - Web Dept. wrote:
> I am quite willing to acknowledge that I'm new at this ...
>
> But I can't find the syntax error in this query:
>
> SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
>
> desc is a field name, usb is the keyword I'm sear
On Mon, Jun 16, 2003 at 12:45:53PM -0400, Martin's - Web Dept. wrote:
> I am quite willing to acknowledge that I'm new at this ...
>
> But I can't find the syntax error in this query:
>
> SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
>
> desc is a field name, usb is the keyword I'm s
You are mixing table and global grants together here.
Use separate grant commands. I am too lazy to look
it up right now, but FILE is global. I am not sure about
CREATE and DROP.
Aso, I believe that should be 'id'@'127.0.0.1'
not localhost.
localhost always connects to the pipe.
SSH connects to a
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
Thanks guys,
Appreciate the help. Kinda makes sense now ;-)
Jeff
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Benjamin Pflugmann" <[EMAIL PROTECTED]>; "Jeff"
<[EMAIL PROTECTED]>; "MySQL List" <[EMAIL P
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
Samuel,
> select sld_vlprov,hist_lanc from sld_lanc,lanc
> where sld_lanc.sld_user *= lanc.user_usuario
In MySQL, this could simply be:
select sld_vlprov,hist_lanc from sld_lanc,lanc
where sld_lanc.sld_user = lanc.user_usuario
But you can write it like you did, as well:
> select * from sld_lan
-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
David,
Tuesday, November 19, 2002, 5:20:23 PM, you wrote:
DN> (sorry if this is a duplicate -- I don't think the original made it)
DN> Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication
DN> is working fine, but I'm running into errors with the replicate-rewrite-db
DN> dir
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> ABBREVIATION is null;
* 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 the CONCAT function:
http://www.mysql.co
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
[snip]
+-++-+
| artist | area | magic |
+-++-+
| Joe Bloggs | AZ*IN*TX | childrens |
+-++-+
| Fred Smith | All| close-up|
+-++-
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 this
SELECT user.*, wbs.name
FROM
user_wbs INNER JOIN user ON user.id = user_wbs.user_id INNER JOIN
wbs ON wbs.id = user_wbs.wbs_id
that should do the same as your select
just MySQL doesnt like nested joins/selects
hope this will be sorted out in 4.1
Tommy
-Original Mes
Hello Andreas,
> I just encountered the following: let $a be a numeric php expression,
a
> the corresponding integer field in a table. When I say: "UPDATE table
> SET a=$a" it denies the update. When I say: "Update table SET a='$a'"
it
> performs the update. Uhm, now I am wondering. Isn't 'someth
On Sat, 19 Jan 2002 23:03:38 -0800
Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> I'm working on the section of my book which deals with MySQL
> configuration. Since my goal is to cover *at least* MySQL 4.0
> (possibly 4.1 if I'm too slow), I need to make sure that I cover
> things on the 4.0 TODO
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
At 10:44 PM -0700 9/16/01, Robert Peters wrote:
>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
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
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
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
Sara writes:
> Hi
>
> I have compiled a report using Mascon only to find I can't export it to any other
>software I have! Great report but not much good to me as it is :-(
>
> (I'm not well versed in php yet, otherwise this might be an issue)
>
> However, I did get the sql query script and th
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]
Even if sub-selects were available in MySQL (which they're not), that query
would still not work as it will only select the values that are unique to
tableA.
What you would be looking at is something like:
SELECT email
FROM tableA
UNION
SELECT email
FROM tableB
But unfortunately, UNION is not a
I am a rookie as well so this may not work but I think it should. Could you
not just copy all of one into the other and then select all out of it using
DISTINCT so you get no duplicates out of it?
Bomber Steel
Mankind has, ever since it began to think,
worshipped that which it cannot understand.
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, I
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]>
1 - 100 of 103 matches
Mail list logo
