Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (28)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (27)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Fix the INSERT Command Denied Error
How To Fix the INSERT Command Denied Error? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
✍: FYIcenter.com
The reason for getting the "1142: INSERT command denied" error is that your user accound does not have the INSERT privilege on the table or database. To resolve this error, you need to ask your MySQL DBA to grant you the right privilege.
Your DBA will need to run commands like these to grant you enough privileges :
GRANT INSERT ON fyi.* TO dev; GRANT UPDATE ON fyi.* TO dev; GRANT DELETE ON fyi.* TO dev; GRANT SELECT ON fyi.* TO dev; GRANT CREATE ON fyi.* TO dev; GRANT DROP ON fyi.* TO dev;
Once you got the right privileges, run the following tutorial scrip again:
<?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links (id, url) VALUES (" . " 101, 'dev.fyicenter.com')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed with error:\n"); print(mysql_errno($con).": ".mysql_error($con)."\n"); } $sql = "INSERT INTO fyi_links (id, url) VALUES (" . " 102, 'dba.fyicenter.com')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed with error:\n"); print(mysql_errno($con).": ".mysql_error($con)."\n"); } mysql_close($con); ?>
The script should return this:
1 rows inserted. 1 rows inserted.
2007-05-10, 4481👍, 0💬
Popular Posts:
How To Set session.gc_divisor Properly? - PHP Script Tips - Understanding and Using Sessions As you ...
What is Shell scripting A shell script is a script written for the shell, or command line interprete...
Is Session_End event supported in all session modes ? Session_End event occurs only in “Inproc mode”...
How To Control Table Widths? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells Usually, b...
In which event are the controls fully loaded ? Page_load event guarantees that all controls are full...