2014/09/06 09:06 -0700, Don Wieland
Can anyone tell me why this query is generating an ERROR:
Which error? The first "IF" statement is not properly ended? it isn't.
(A series of equality tests against the same variable is done more conveniently
with "CASE ... END CASE".)
--
Can anyone tell me why this query is generating an ERROR:
DROP TRIGGER rtsadven_development.content_assets_after_insert_subtypes;
CREATE TRIGGER `rtsadven_development`.`content_assets_after_insert_subtypes`
AFTER INSERT ON `rtsadven_development`.`content_assets`
FOR EACH ROW
BEGIN
IF N
Hi,
Le 08/08/2014 17:48, Johan De Meersman a écrit :
>
> As your code is french, I'll assume you're on Azerty; the backtick is Alt-Gr
> plus the rightmost key (right next to return) on the middle row. Enjoy
> spraining your fingers :-p
>
> /johan
>
Alt-GR plus '7' for French keyboard layout
- Original Message -
> From: "florent larose"
> Subject: sql syntax error
>
> near ''membres2' WHERE
> [...]
> FROM 'espace_membre2'.'membres2' WHERE
You were on the right path - mysql is wibbly about quotes. Either
hello, i am working on my personal website wih php 5.4.16 / mysql 5.6.12 (my
system : windows 7 / wampserver 2).
i have a bug when i am running my connection to database webpage.
My error message is the following :
Erreur SQL : You have an error in your SQL syntax; check the manual that
>
> Given the title of the book is "Head First SQL" and not "Head First MySQL"
> it probably isn't exclusively using syntax for MySQL. While SQL is a
> standard the various SQL databases are not completely identical with the
> syntax they support. This ma
Hi Tim,
> -Original Message-
> From: Tim Dunphy [mailto:bluethu...@gmail.com]
> Sent: Sunday, 29 June 2014 10:09
> To: Jesper Wisborg Krogh
> Cc: mysql@lists.mysql.com
> Subject: Re: alter table modify syntax error
>
> >
> > The syntax "sixth"
>
> The syntax "sixth" is not a supported syntax. You should use the syntax
> "AFTER " where you replace with the column name
> you want to position the modified column after.
Oh thanks. That's actually what I ended up doing after I got frustrated
with
Hi Tim,
> -Original Message-
> From: Tim Dunphy [mailto:bluethu...@gmail.com]
> Sent: Sunday, 29 June 2014 03:45
> Cc: mysql@lists.mysql.com
> Subject: Re: alter table modify syntax error
>
> Hey guys,
>
> Sorry to hit you with one more. But I'm tryi
Hey guys,
Sorry to hit you with one more. But I'm trying to use a positional
statement in a column move based on what you all just taught me:
mysql> alter table modify column color varchar(10) sixth;
But I am getting this error:
ERROR 1064 (42000): You have an error in your SQL synta
--+--+-+-++
>> 7 rows in set (0.03 sec)
>>
>> I am trying to position the 'color' column after the 'model' column with
>> the following command:
>>
>> mysql> alter table car_table modify column color af
owing command:
mysql> alter table car_table modify column color after model;
And I'm getting the following error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'after model'
table modify column color after model;
And I'm getting the following error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'after model' at line 1
I'm just wondering
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
>>
>>> well, i am using delete/insert-statements since 10 years to maintain
>>> users since you only have to know the tables in the database "mysql"
>>> and use "flush privileges" after changes
>>>
>>> The privileges should be maintained only using the designated commands.
>> You cannot rely on
Am 02.12.2011 21:59, schrieb Claudio Nanni:
> 2011/12/2 Reindl Harald
>
>> well, i am using delete/insert-statements since 10 years to maintain
>> users since you only have to know the tables in the database "mysql"
>> and use "flush privileges" after changes
>>
>> The privileges should be main
2011/12/2 Reindl Harald
> well, i am using delete/insert-statements since 10 years to maintain
> users since you only have to know the tables in the database "mysql"
> and use "flush privileges" after changes
>
> The privileges should be maintained only using the designated commands.
You cannot
well, i am using delete/insert-statements since 10 years to maintain
users since you only have to know the tables in the database "mysql"
and use "flush privileges" after changes
DROP USER is the only SINGLE COMMAND
as long as you do not use table/column-privileges there are exactly
two relevant
DROP USER command is the only command to remove any user and its
association from all other tables.
Cheers
On Fri, Dec 2, 2011 at 8:22 AM, Reindl Harald wrote:
> ALWAYS
> start with "select * from mysql.user where user='mail_admin' and host like
> '\%';"
> and look what records are affected
ALWAYS
start with "select * from mysql.user where user='mail_admin' and host like
'\%';"
and look what records are affected to make sure the were-statement works as
expected and then use "CURSOR UP" and edit the last command to "delete from"
not only doing this while unsure with escapes protects
(0.00 sec)
>
>
> sorry for not including enough information last time.
>
> best
> tim
>
> - Original Message -
> From: "Krishna Chandra Prajapati"
> To: "Tim Dunphy"
> Cc: mysql@lists.mysql.com
> Sent: Thursday, December 1, 2011 9:03:46 PM
On 2011-12-02, Tim Dunphy wrote:
>
> Thanks but I probably should have noted that I only want to delete the
> wildcard user. There are other users I would prefer to not delete.
>
> mysql> select user,host from mysql.user where user='mail_admin';
> ++---+
>| user
luding enough information last time.
best
tim
- Original Message -
From: "Krishna Chandra Prajapati"
To: "Tim Dunphy"
Cc: mysql@lists.mysql.com
Sent: Thursday, December 1, 2011 9:03:46 PM
Subject: Re: delete syntax
delete from mysql.user where user='mail_admin'
delete from mysql.user where user='mail_admin';
Krishna
On Fri, Dec 2, 2011 at 7:23 AM, Tim Dunphy wrote:
> hello list,
>
> I am attempting to delete a user from the mysql.user table without
> success.
>
> mysql> delete from mysql.user where user='mail_admin@%';
> Query OK, 0 rows affected (
hello list,
I am attempting to delete a user from the mysql.user table without success.
mysql> delete from mysql.user where user='mail_admin@%';
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host from mysql.user where user='mail_admin';
++---+
| u
I cannot seem to get SSL connections working using the REQUIRE ISSUER or
REQUIRE SUBJECT clauses.
I have a mysql working with ssl. I can connect from the client host to
the server using ssl, where the user has been setup using:
GRANT ALL PRIVILEGES ON x.* TO ''@'ipaddress' IDENTIFIED
ql-bin.000620’,
master_log_pos=713184200;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '‘’, master_user=‘repladmin’,
master_password=‘’' at line 1
I have confirmed that I am a
NDTIME=b; //wrong
END $$
DELIMITER ;
--
ERROR
-------
Script line: 4 You have an error in your SQL syntax; check the manual that
corresponds to your My
ERROR
-------
Script line: 4 You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near &#x
d on MULTIPLE attributes.
>>
>> So the result should only contain rows for images, that relate to an
>> attribute ID = 1 (size) that is bigger than 100 AND!!! an attribute ID =
>> 5 that equals 'jpg'.
>>
>> [[...]]
You need to do a multi-table join
On Wed, 2010-06-16 at 08:59 +0100, Nigel Wood wrote:
> I'd use:
> drop temporary table if exists AttSearchMatches;
> select pid as targetPid, count(*) as criteraMatched from B where
> userId=35 and ( (b.aid=1 and b.value >50) OR (b.aid=3 and b.value
> =4) ) group by pid having criteraMatched = 2;
>
[
> I have 2 tables. Table A containing 2 fields. A user ID and a picture ID =>
> A(uid,pid) and another table B, containing 3 fields. The picture ID, an
> attribute ID and a value for that attribute => B(pid,aid,value).
>
> Table B contains several rows for a single PID with various AIDs and value
[Top-post.]
You'll probably have much better luck on the MySQL General list.
CC'ed on this email.
On Tue, Jun 15, 2010 at 20:58, Jan Reiter wrote:
> Hi folks!
>
> I'm kind of ashamed to ask a question, as I haven't followed this list very
> much lately.
>
>
>
> This isn't exactly a PHP
esigns.com]
> Sent: April 26, 2010 10:29 PM
> To: mysql@lists.mysql.com
> Subject: Re: Join syntax problem
>
> Thanks for the replies. It was my understanding that whitespace is
> ignored,
> and I did not think that not having space, in particular with "." wou
N keywords AS kw USING (image_id)" .
"WHERE ky.image_id = im.image_id";
Gets me this error message.
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'keywords AS kw
USING (image_id)WHERE ky.image_id = im
lves, kw.wildlife, kw.american,
> kw.scenic, kw.birds, kw.africa, kw.eagles, kw.hunter" .
> "FROM *images AS im"."JOIN keywords AS kw USING (image_id)" .
> "WHERE ky.image_id = im.image_id";
>
> Gets me this error message.
>
> You have an error in
, kw.hunter" .
> "FROM *images AS im"."JOIN keywords AS kw USING (image_id)" .
looks like there's no space between 'im' and 'JOIN' in the line above
> "WHERE ky.image_id = im.image_id";
try: print($query);
>
> Gets me this
rds AS kw USING (image_id)" .
"WHERE ky.image_id = im.image_id";
Gets me this error message.
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'keywords AS kw
USING (image_id)WHERE ky.image_id =
Have you considered Reading The *Fine* Manual at
http://dev.mysql.com/doc/#manual ?
On Sat, Dec 5, 2009 at 4:59 PM, Victor Subervi wrote:
> Hi;
> I remember vaguely how to do this but don't know how to google it:
>
> show tables like categories$;
>
> such that it will return tables such as:
>
>
On Sat, Dec 5, 2009 at 11:09 AM, Michael Dykman wrote:
> show tables like 'categories%';
>
Thanks.
V
Hi;
I remember vaguely how to do this but don't know how to google it:
show tables like categories$;
such that it will return tables such as:
categoriesProducts, categoriesPrescriptions, etc.
TIA,
Victor
That's it! Thanks,
V
On Tue, Sep 29, 2009 at 12:13 PM, David Giragosian wrote:
> On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi >wrote:
>
> > Hi;
> > Please give me the syntax below such that I can force the insert
> statements
> > to use only select
On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi wrote:
> Hi;
> Please give me the syntax below such that I can force the insert statements
> to use only selected values ("item1", "item2", "item3"):
>
> create table (field SOMETHING_HERE item1 item2
Hi;
Please give me the syntax below such that I can force the insert statements
to use only selected values ("item1", "item2", "item3"):
create table (field SOMETHING_HERE item1 item2 item3,
...
)
TIA,
Victor
Perfect. Thank you.
Victor
On Sun, Jul 26, 2009 at 2:18 PM, Darryle Steplight wrote:
> Hi Vicor,
>Look into INSERT ON DUPLICATE or REPLACE statements. You need to
> have a primary key or unique key for these too work.
>
> On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervi
> wrote:
> > Hi;
> > I
Hi Vicor,
Look into INSERT ON DUPLICATE or REPLACE statements. You need to
have a primary key or unique key for these too work.
On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervi wrote:
> Hi;
> I would like to test the following:
>
> update maps set map where site=mysite;
>
> to see if there is s
from: http://dev.mysql.com/doc/refman/5.1/en/insert.html:
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
SET col_name={expr | DEFAULT}, ...
[ ON DUPLICATE KEY UPDATE
col_name=expr
[, col_name=expr] ... ]
The ON DUPLICATE KEY predicate tells you
Hi;
I would like to test the following:
update maps set map where site=mysite;
to see if there is such an entry in maps. If there is, then update. If there
is not, then I would like to execute an insert statement. How do I do that?
TIA,
Victor
Johnny Withers schrieb:
Group is a keyword in mysql:
You need to put backticks around it in your statement:
| LOAD DATA INFILE 'test.csv' INTO TABLE table
| FIELDS TERMINATED BY ','
| LINES STARTING BY '' TERMINATED BY '\n'
| (Page, Device, `GROUP` , ItemID, Item, Value);
Ooookay. Thank
he third table,... Just to have an index.
>
> I'm using:
> | LOAD DATA INFILE 'test.csv' INTO TABLE table
> | FIELDS TERMINATED BY ','
> | LINES STARTING BY '' TERMINATED BY '\n'
> | (Page, Device, GROUP , ItemID, Item, Value);
>
>
27;\n'
| (Page, Device, GROUP , ItemID, Item, Value);
which gives me:
| #1064 - You have an error in your SQL syntax; check the manual that
| corresponds to your MySQL server version for the right syntax to use
| near 'Group, ItemID, Item, Value)' at line 2
I cannot find the error. P
OK I tried this exact syntax and I get the same error. I tried it on mysql
client for 6.0.10
On Wed, May 20, 2009 at 2:22 PM, Gavin Towey wrote:
> Interesting. This syntax is only supposed to be available as of 5.4, but
> it doesn't even work there. The reference I found was
Interesting. This syntax is only supposed to be available as of 5.4, but it
doesn't even work there. The reference I found was at :
http://dev.mysql.com/tech-resources/articles/mysql-54.html
But I couldn't find other references to the new signal support.
This is listed as the examp
Hi Folks,
I am getting syntax error with the mysql signal. I have a trigger
that needs a signal for raising an error condition if a row with
specific value is removed.
CREATE TRIGGER my_trig BEFORE DELETE ON my_tbl
FOR EACH ROW BEGIN
DECLARE mysig CONDITION FOR SQLSTATE '
ge-
From: Rolando Edwards [mailto:redwa...@logicworks.net]
Sent: Tuesday, May 19, 2009 12:40 PM
To: Alex Katebi; mysql@lists.mysql.com
Subject: RE: What is wrong with this SYNTAX?
DELIMITER $$
CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global
FOR EACH ROW BEGIN
IF STRCMP(NEW.Variable_na
tebi [mailto:alex.kat...@gmail.com]
Sent: Tuesday, May 19, 2009 10:33 AM
To: mysql@lists.mysql.com
Subject: What is wrong with this SYNTAX?
It is complaining about near STRCMP.
CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global
FOR EACH ROW BEGIN
IF STRCMP(NEW.Variable_name,'A
It is complaining about near STRCMP.
CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global
FOR EACH ROW BEGIN
IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN
set NEW.Variable_name=NULL;
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Variable_name=NULL
ELSEIF STRCM
> Date: Sat, 16 May 2009 15:39:56 -0700
> From: davidmichaelk...@gmail.com
> To: mysql@lists.mysql.com
> Subject: Confused about syntax for specific join with 3 tables
>
> I've been doing some experimenting with the data model from the "MySQL"
> book
I've been doing some experimenting with the data model from the "MySQL"
book (Addison Wesley). I have no trouble understanding joins between
two tables, but I'm finding it's a little confusing when 3 or more
tables are involved. I'm going to cite a particular set of tables and a
specific quer
Always echo out your SQL string, it will make it a lot more obvious.
You want to see the result. I php concatenated string can be
confusing at times.
Also, you are not escaping your data, so if you had a word of 'stops,
here' that would break it as well.
So in your case, you very well m
Thanks, Scott.
I thought I couldn't have missed ','(comma) before. But today somehow it
works... ;;
I wasted hours figuring this out, but you saved me!
Maybe I'm still a complete newbie!
Thanks, again. Have a great day. :)
On Thu, Apr 30, 2009 at 12:52 PM, Scott Haneda wrote:
>
> On Apr 29,
On Apr 29, 2009, at 11:29 AM, Antonio PHP wrote:
This is MySQL data structure. - I underlined where it causes the error
message. (datetime)
`id_Company` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
`Revenue` mediumint(6) NO
e query and the table structure. timestamp fields
> can have options set to auto update them, where order matters, and only one
> field can support that feature.
>
> Please supply more data.
>
>
> On Apr 28, 2009, at 2:18 PM, Antonio PHP wrote:
>
> You have an error in your
syntax; check the manual that
corresponds to
your MySQL server version for the right syntax to use near 'Created
= NOW(),
Updated = NOW()' at line 8
'Created' and 'Updated' are set to datetime (InnoDB).
The same syntax works for some newly created tables... and
Can you please give the full table structure and query?
On Tue, Apr 28, 2009 at 23:18, Antonio PHP wrote:
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'Created = NOW(),
> Updated = NO
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'Created = NOW(),
Updated = NOW()' at line 8
'Created' and 'Updated' are set to datetime (InnoDB).
The same syntax works for so
actually, that was stupid of me - you need a list of tables not files.
I think the only to do this, and the way we do it, is to run some command
like:
mysql -e"show tables in db-name like 'z%'" >tabnames
Note the use of double-quotes and single-quotes.
then use a loop to read the file "tabnames"
>> Date: Sun, 19 Apr 2009 16:29:48 +0200
>> From: m...@kiewel-online.ch
>> To: saeho...@hotmail.com
>> CC: mysql@lists.mysql.com
>> Subject: Re: mysqldump syntax - dumping only specific tables starting
> with a certain character. (e.g. z*)
>>
>> -BEGI
me. Plz tell me what I've done wrongly this time. :)
> Date: Sun, 19 Apr 2009 16:29:48 +0200
> From: m...@kiewel-online.ch
> To: saeho...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: mysqldump syntax - dumping only specific tables starting with a
> certain
s' mean? (as in linux command 'ls'?)
you have to use the ` sign, not the '
Uwe
>
> :)
>
>
>> Date: Sun, 19 Apr 2009 08:53:36 -0500
>> Subject: Re: mysqldump syntax - dumping only specific tables starting with a
>> certain character. (e.
I tried it, then it gives the following error message
mysqldump: Can't get CREATE TABLE for table 'ls z*' (Table '(db-name).ls z*'
doesn't exist)
What does 'ls' mean? (as in linux command 'ls'?)
:)
> Date: Sun, 19 Apr 2009 08:53:36
try something like:
mysqldump -u(user) -p (db-name) `ls z*` > (filename)
2009/4/19 ChoiSaehoon
>
> Is there a way to dump only specific tables starting with a certain
> character?
>
>
>
> For example, I only want to dump tables starting with the character 'z'.
>
> The following doesn't work.
>
Is there a way to dump only specific tables starting with a certain character?
For example, I only want to dump tables starting with the character 'z'.
The following doesn't work.
mysqldump -u(user) -p (db-name) z* > (filename)
Do I have to use regular expression here?
Please hel
5)
-> *);*
Works without the asterisks.
PB
-
jean claude babin wrote:
I'm new with MySQL server 5.0 ,I tried to create a table MemberDetails from
the mysql command shell,
I got an error 1064 (42000): *You have an error in your SQL syntax*;
Here is my code:
m
I'm new with MySQL server 5.0 ,I tried to create a table MemberDetails from
the mysql command shell,
I got an error 1064 (42000): *You have an error in your SQL syntax*;
Here is my code:
mysql> CREATE TABLE memberDetails
-> *(*
->memberId INT NOT NULL
Thanks for the tip. I am looking at just making 16 separate queries.
It will be easier to manage and faster to run.
Dan
On Sep 6, 2008, at 9:37 PM, Brent Baisley <[EMAIL PROTECTED]> wrote:
Well, for your simple example, you can use query variables to add
the "counters".
SET @cntr:=0, @last
Well, for your simple example, you can use query variables to add the
"counters".
SET @cntr:=0, @lastVal:='A'
INSERT INTO tableB LOC,DATA SELECT CONCAT(LOC,
CONCAT( IF(@lastVal=LOC, @cntr:[EMAIL PROTECTED], @cntr:=0),
IF(@lastVal:=LOC,'',''))) LOC, CONCAT(DATA, @cntr) FROM tableA ORDER
BY
I have an existing data set - here is an example (the real one is more
complex than this)
LOC DATA
-
A 1
B 2
C 3
D 4
E 5
F 6
...
and I am looking to run some sort of INSERT ... SELECT on this to make
a new table like this:
LOC DATA
else
.
-Original Message-
From: roger.maynard [mailto:[EMAIL PROTECTED]
Sent: 23 January 2008 18:58
To: mysql@lists.mysql.com
Subject: INSERT WHERE NOT EXISTS syntax
Can anyone tell me why this isn't working... v5.0
INSERT INTO master_comments (comment_no,comment
Can anyone tell me why this isn't working... v5.0
INSERT INTO master_comments (comment_no,comment_text,language_id)
SELECT comment_no,comment_text,language_id from mComments
WHERE NOT EXISTS (SELECT comment_no FROM master_comments);
I thought I had it working once but now it isn't?
Ro
Thanks to all.
> -Original Message-
> From: Michael Dykman [mailto:[EMAIL PROTECTED]
> Sent: September 28, 2007 1:36 PM
> To: Beauford
> Cc: mysql@lists.mysql.com
> Subject: Re: Count syntax
>
> 1 means that 1 will be added to the sum if the condition
>
attachments. Please notify the sender immediately by reply e-mail and delete
the e-mail from your system.
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Friday, September 28, 2007 1:36 PM
To: Beauford
Cc: mysql@lists.mysql.com
Subject: Re: Count syntax
1 means
1 and 0 do in this -
> SUM(IF(supportertype = 'L', 1, 0))
>
> > -Original Message-
> > From: Baron Schwartz [mailto:[EMAIL PROTECTED]
> > Sent: September 28, 2007 1:00 PM
> > To: Beauford
> > Cc: mysql@lists.mysql.com
> > Subject: Re
Thanks - it works, but what does the 1 and 0 do in this -
SUM(IF(supportertype = 'L', 1, 0))
> -Original Message-
> From: Baron Schwartz [mailto:[EMAIL PROTECTED]
> Sent: September 28, 2007 1:00 PM
> To: Beauford
> Cc: mysql@lists.mysql.com
> Subject: Re: Coun
Beauford wrote:
Hi,
I have the following line of code and I keep getting wrong results from it.
Can someone let me know what I'm doing wrong here. I just can't quite figure
out the syntax that I need.
select count(*) as numrows, count(supportertype) as leadcar from regis
Hi,
I have the following line of code and I keep getting wrong results from it.
Can someone let me know what I'm doing wrong here. I just can't quite figure
out the syntax that I need.
select count(*) as numrows, count(supportertype) as leadcar from registrar
where supportertype = &#
(
UserID
) REFERENCES TimeTracker.TT_Users (
UserID
)
As iam new to this mysql when i was doing the program mysql shows the error
as
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the
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
Information Technology
1700 Pratt Drive
Blacksburg, VA 24060
Email: [EMAIL PROTECTED]
Phone: (540) 231-4396
-Original Message-
From: Tom Khoury [mailto:[EMAIL PROTECTED]
Sent: Monday, August 13, 2007 2:38 PM
To: mysql@lists.mysql.com
Subject: Syntax Error in Stored Procedure
Below is a
END IF;
97:
98:-- Construct the final SQL statement.
99: IF (Filter_Clause = '') THEN
100:SET Final_SQL = Base_SQL;
101: ELSE
102:SET Final_SQL = concat(Base_SQL, 'WHERE ', Filter_Clause);
103:END IF;
104:
105:-- Execute the constructed SQL Stateme
--- 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
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'@'loc
--- 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
ec)
I found I made a mistake to run it. I need to revoke the GRANT given to
vmailuser to test database.
I found on;
13.5.1.5. REVOKE Syntax
http://dev.mysql.com/doc/refman/5.0/en/revoke.html
The syntax;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user]
but can't resolve whethe
un it. I need to revoke the GRANT given to
vmailuser to test database.
I found on;
13.5.1.5. REVOKE Syntax
http://dev.mysql.com/doc/refman/5.0/en/revoke.html
The syntax;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user]
but can't resolve whether retaining the 1st 'user'
and
.date DESC , o.status, u.username
LIMIT 0 , 30
--
View this message in context:
http://www.nabble.com/Syntax-error-tf2938979.html#a8216881
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
1 - 100 of 1024 matches
Mail list logo
