Hi Experts,
When issuing updates in mysql (in the console window), mysql will tell
you if any rows matched and how many rows were updated (see below). I
know how to get number of rows udpated using mysql_affected_rows(), but is
there any
way to get the number of rows matched? I want to find
Hi
when I stop mysql server with sudo /etc/init.d/mysql stop the
mysqld_safe process go to 100% of CPU and I must to kill it
manually.
What's happens? Ho can I stop it without killing?
--
Scripts: http://www.spacemarc.it
--
MySQL General Mailing List
For list archives:
try mysqladmin shutdown
On 6/11/07, spacemarc [EMAIL PROTECTED] wrote:
Hi
when I stop mysql server with sudo /etc/init.d/mysql stop the
mysqld_safe process go to 100% of CPU and I must to kill it
manually.
What's happens? Ho can I stop it without killing?
--
Scripts: http://www.spacemarc.it
Hi
AFAIK, before changing data, the old values are saved in the rollback
segment.
On saving the updated values, from the Buffer to the rollback segment/data
files,
--- it checks if there is any matched row that matches the condition. If
found, then flags Matched.
---after filtering out the
On 10 jun 2007, at 20.47, tAndRead wrote:
Hi all,
snip
when I try to add a foreign text from the keyboard in the mysql
client,
keystrokes are ignored! unless they are numbers, commas etc
(using kde-konsole with the the DeJaVu international font)
I believe this has to do something with
Ok..thanks! But my problem here is how to check if there were any matched
rows when no rows were changed. mysql_affected_rows() will tell me the
affected rows. Simmly, is there any routine using which one can know if
there were any matched rows?
Cheers,
Rajan
On 6/11/07, ViSolve DB Team [EMAIL
Is this a user untz going to do even the create procedure, if yes then
you need to grant super previliege to this user.
grant super on *.* to 'untz'@'localhost' identified by 'password';
regards
anandkl
On 6/11/07, untz [EMAIL PROTECTED] wrote:
Baron Prathima,
Thank for the information!
Hi,
I think you need to log in as root and grant yourself some privileges then. If you
have lost the root password or root doesn't have privileges anymore either, there is a
chapter in the manual on how to do this: http://dev.mysql.com/
Cheers
Baron
untz wrote:
Baron Prathima,
Thank for
Hi
Simple.. The query feedback will depict the matched changed numbers.
mysql update test set roll = 1, s = 'new' where roll = 1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
Thanks
ViSolve DB Team.
- Original Message -
From: Ace [EMAIL PROTECTED]
ok...That I know but I need it to check in my code...
On 6/11/07, ViSolve DB Team [EMAIL PROTECTED] wrote:
Hi
Simple.. The query feedback will depict the matched changed numbers.
mysql update test set roll = 1, s = 'new' where roll = 1;
Query OK, 0 rows affected (0.00 sec)
* Rows matched:
REcently my mysql server has been overload with a lot
of connections; in fact losing the mysql.user table and
one whole database.
How can this be prevented?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General
Hi,
I'm trying to build the RPMs with ICC, but I'm not having a lot of luck. I
saw the documentation for what paremeters are used to combile the tar
balled binaries, but can anyone give me some guidance on how to get the
RPMs to build?
The distributions I want to build for are CentOS 5.0 /
On Mon, 11 Jun 2007, Dave Shariff Yadallee - System Administrator a.k.a. The
Root of the Problem wrote:
REcently my mysql server has been overload with a lot
of connections; in fact losing the mysql.user table and
one whole database.
Define losing. You lost access, or the tables got
Have you looked at mysql_info()? The format of the return value might not be
the most useful, but it should give you what you need.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Hello,
I am trying to revoke all privileges from a user on a certain table in a
database.
I want the user to continue to have all his/her privileges intact for the
other tables though.
I used the statement REVOKE ALL PRIVILEGES on dbName.tableName from
thisUser;
But that doesn't seem to change
On Mon, 11 Jun 2007, Mahmoud Badreddine wrote:
Hello,
I am trying to revoke all privileges from a user on a certain table in a
database.
I want the user to continue to have all his/her privileges intact for the
other tables though.
I used the statement REVOKE ALL PRIVILEGES on
I have inherited database servers from a group whose main job was not working
on mysql. I am not certain if all the tables on the databases are being used.
Is there some efficient way of determining if a table is being accessed or when
the last time it was accessed?
Thanks,
Keith
--
Hi,
Is it possible to insert values into two tables simultaneously and
have the value of one of the columns in the second table be the
auto_increment value from inserting into the first?
E.g. if table1 has an auto_increment column c1, the logic I'm looking
for would be something like:
INSERT
Yes, you are right! mysql_info() is not most useful. It does give me number
of rows matched but will involve complications of parsing the string.
Is there no other way to this? How can this be missed? I am not so
convinienced on mysql_info()!
On 6/11/07, Jerry Schwartz [EMAIL PROTECTED]
Hi,
Hamish Allan wrote:
Hi,
Is it possible to insert values into two tables simultaneously and
have the value of one of the columns in the second table be the
auto_increment value from inserting into the first?
No, because you can only insert into one table at a time. But you can write a
On 6/11/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Hamish Allan wrote:
Hi,
Is it possible to insert values into two tables simultaneously and
have the value of one of the columns in the second table be the
auto_increment value from inserting into the first?
No, because you can only
Just speaking as a newbie who has no idea what he is talking about ...
If nobody suggests anything better ...
I've noticed that there is a clear correspondence between table names and
the files that MySQL keeps, i.e.
[EMAIL PROTECTED] dashley]# ls -al /var/lib/mysql/fboprimedevel/
total 7832
2007/6/11, Ananda Kumar [EMAIL PROTECTED]:
try mysqladmin shutdown
I've tried but nothing is happens: the mysqld_safe process
is always to 100%
--
Scripts: http://www.spacemarc.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql grant super *.* to 'untz'@'localhost' identified by 'password';
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
untz wrote:
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql grant super *.* to 'untz'@'localhost' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
Looks like words privileges on are missing from GRANT statement you
used
Should be grant super privileges on *.* to 'untz'@'localhost'
identified by 'password';
Not grant super *.* to 'untz'@'localhost' identified by 'password';
Regards,
Mikhail Berman
-Original Message-
From: untz
Gerald,
I tried this and still got an error!
mysql grant all privileges on *.* to 'untz'@'localhost' identified
by 'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql
Can anyone please help me? I am unable to use MySQL at all, at this
Mikhail,
I just tried what you suggested and got this:
mysql grant super privileges on *.* to 'untz'@'localhost' identified
by 'maddog';
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
I get this everytime I post to the mysql mailing list?
On Jun 11, 2007, at 1:26 PM, [EMAIL PROTECTED] wrote:
Subject of the message: Re: Access Denied When Trying to Create
Database
Recipient of the message: mysql@lists.mysql.com
mysql@lists.mysql.com
--
MySQL General Mailing List
For
untz wrote:
Gerald,
I tried this and still got an error!
mysql grant all privileges on *.* to 'untz'@'localhost' identified by
'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql
Can anyone please help me? I am unable to use MySQL at all,
Gerald,
I tried this and it still didn't work!
Raven:~ untz$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 223 to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql grant
Don't you mean this ?
grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog';
- Original Message -
From: untz [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, June 11, 2007 4:36:33 PM (GMT-0500) America/New_York
Subject: Re: Access Denied When Trying to Create
Rolando!
Yes, that worked! I did have to log into mysql as root, however...
BTW, for some odd reason someone's symantec virus checker is sending
me denied e-mail responses from Italy, whenever I try to post to the
MySQL mailing list.
Many, many thanks,
Unnsse
On Jun 11, 2007, at 1:41
Yes, you are correct. In a cruel, ironic twist, that actually bit me in
the ass, as it turns out we tried to import some HTML output from MS
Word, which adds all kinds of crazy XHTML comment tag thingys that look
like:
!--[if gte mso 9]
!--[if !mso]
![endif]--
Etc.
*sigh*
-Original
Oh dear... Without getting into any religious arguments, if you have to
use it, PHP already provides a perfectly good interface for preventing
any SQL injections - ever. Use MySQLi and bound parameters. And if
somebody manages to invent some quasi-valid reason for not using MySQLi
(e.g. version of
Having just tried building MySQL 6.0 SRPM on CentOS/RHEL 5, it would
appear that it doesn't even build cleanly with the default settings with
GCC! Has anyone got any information as to why this might be? It seems to
build OK, but then all the tests (mysql-test-run) seem to fail.
Is this known not
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about 5,000,000,000 rows.
that's cool but i assume this is
The answer depends upon the actual queries and/or how much data is being
returned.
there is ALWAYS only one record found/returned per query it's like
looking up one unique id it's like checking if number 5893786 is there
in row number one... or something like number 5893786 - a unique
At 5:53p -0400 on 11 Jun 2007, Gordan Bobic wrote:
I don't understand this never-ending fascination with re-inventing
a square wheel for an application for which the standard round type
has already been kindly provided since year dot.
I imagine the reason for this never-ending fascination
On 6/11/07, kalin mintchev [EMAIL PROTECTED] wrote:
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about
Baron Schwartz wrote:
Kemin Zhou wrote:
Hi All,
I have one of the toughest problem to solve now. I have not been
able to sleep well in the last three days.
There is a simple query
insert into table foo (column1, column2, column5)
select $col
from bar
If I run this query by hand whatever
Thanks All for your help!
If someone from MySQL team is looking at this mail thread, we request to
include this feature in future release.
Cheers,
Rajan
On 6/11/07, Michael Dykman [EMAIL PROTECTED] wrote:
no, there is nothing else. There are cleaner interfaces to this
information but, for
-Original Message-
From: Hannu Krosing [mailto:[EMAIL PROTECTED]
Sent: Monday, June 11, 2007 10:43 PM
To: Larry McGhaw
Cc: Tom Lane; Alvaro Herrera; Dann Corbit; Gregory Stark; Martijn van
Oosterhout; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Selecting a constant question
Ühel
43 matches
Mail list logo