Dear all,
When I try to update or create a record to a table,
there is an error saying the table is read-only.
How can I change it to read-write?
I have chmod 777 to all the tables in the mysql data directory.
I have also restarted the mysql engine.
This happened only after I copy the tables f
SQL SQL SQL SQL
hi,
i have 2 problems here.
1)
i have 2 tables:
currency rates
+-+ ++
| code char(3)| | currency char(3) |
| name varchar(10)| | rate double|
| bcurrency cha
On Fri, Feb 02, 2001 at 12:11:07AM -0800, Matthew Halliday wrote:
>
> I have a database that I finally got connected to my newly installed
> MySQL, I've had a bad week, however I can't add information to the
> tables, it says they are read only! How can I fix this? I've check
> the manual but I a
Hello
Thats probably you username in user table has given you only SELECT prilvages
(Select_priv)
You can log in as root in mysql and UPDATE the user table to give you INSERT,
DELETE privlages
Refer to any sql book on the syntax of UPDATE
On Fri, 02 Feb 2001, Matthew Halliday wrote:
> I have
I have a database that I finally got connected to my newly installed
MySQL, I've had a bad week, however I can't add information to the
tables, it says they are read only!
How can I fix this? I've check the manual but I am really new to SQL and
linux.
-matthew
--
