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 out
Baron & Prathima,
Thank for the information!
What happened is that I hadn't used MySQL for a long time and looked
up on the Internet on how to change my root and individual users'
passwords.
The last command the URL had me type was "flush privileges;" and once
I did that, I think it crea
Hi all,
I have compiled mysqld 5.0.37 with utf support:
( configure --with-charset=utf8 --with-extra-charsets=none)
utf8 is the default in my.cnf:
( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 )
mysqld acknowledges it:
mysql> show variables like "charac%";
+--
Hi all,
I have compiled mysqld 5.0.37 with utf support:
( configure --with-charset=utf8 --with-extra-charsets=none)
utf8 is the default in my.cnf:
( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 )
mysqld acknowledges it:
mysql> show variables like "charac%";
+--
We are getting a weird DROP DATABASE error
>
2007-06-10 11:25:41 db 527 DEBUGDROP DATABASE BCS
OperationalError: (1051, "Unknown table
'assignments,chemo,choicelists,dia,forms
,horm,id,permissions,qhistory,qnotes,qstates,questionnaires,r'")
<<<
the thing is, there is NO table
Hi untz,
untz wrote:
Hello there,
I am using MySQL 5 on OS X Tiger...
After starting the server, I tried to create a sample database and this
is what what happened:
$ mysql -u untz -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to
Hello there,
I am using MySQL 5 on OS X Tiger...
After starting the server, I tried to create a sample database and
this is what what happened:
$ mysql -u untz -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.16