Email Alerts
-
MySQL tutorial: Best practices for securing tables, triggers and privileges
Take advantage of this set of best practices for MySQL, an open source relational database management system. Learn about the differences between user and local variables, creating triggers to remove users and more in this MySQL tutorial. Tip
-
Creating triggers to remove users
A MySQL expert gives an example of a foreign key and a trigger to use when removing users from tables. Ask the Expert
-
User vs. local variables
A MySQL expert describes the difference between user variables and local variables. Ask the Expert
-
Limiting table access with a stored procedure
An expert describes how to limit table access and viewing with a stored procedure instead of the GRANT statement. Ask the Expert
-
Modifying the GRANT statement
A MySQL expert describes how to modify the GRANT option, when issuing permissions for tables, with the WITH GRANT OPTION. Ask the Expert
-
Adding a not exist to a subquery with several joins
A MySQL expert describes how to rewrite NOT EXISTS as joins when trying to add a NOT EXIST to a subquery with several joins. Ask the Expert
-
mysql_ functions vs. mysqli object approach
MySQL expert Scott Noyes explains why using mysqli over mysql_functions allows you to take advantage of MySQL's newer features and PHP scripts. Ask the Expert
-
PEAR functionality in MySQL
An expert describes PEAR and what it does in MySQL. Ask the Expert
-
CSV, ARCHIVE, FEDERATED and EXAMPLE in MySQL 5
A MySQL expert explains why the hype about CSV, ARCHIVE, FEDERATED and EXAMPLE storage engines in MySQL 5 is justified. Ask the Expert
-
Hierarchal data storage in MySQL
An expert describes how to perform store a hierarchy in MySQL by splitting the materialized path to a separate table. Ask the Expert