w3docs logo
  1. Snippets
    2. ›
  2. MySQL

How-to articles, tricks, and solutions about MYSQL

In PHP with PDO, how to check the final SQL parametrized query?

In PHP with PDO, you can use the debugDumpParams() method on a prepared statement object to view the final SQL parametrized query.

php MySQL pdo prepared-statement

Increment value in MySQL update query

To increment a value in a MySQL update query using PHP, you can use the += operator.

php sql MySQL sql-update

Insert data into multiple tables using one form

To insert data into multiple tables using one form in PHP, you can use a single SQL statement with multiple INSERT INTO clauses, or you can use multiple individual SQL statements, one for each table.

php MySQL

Installing specific package version with pip

To install a specific version of a package with pip, you can use the pip install command followed by the package name and the desired version number.

MySQL python pip pypi mysql-python

Invoking a PHP script from a MySQL trigger

It is possible to invoke a PHP script from a MySQL trigger by using the system() function in the trigger's body.

php MySQL triggers

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

A java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) error typically indicates that the MySQL server is unable to authenticate the user with the provided username and password.

java MySQL exception jdbc connection

Laravel Delete Query Builder

In Laravel, you can use the Query Builder to delete records from a database table.

php MySQL laravel-4

Laravel Eloquent LEFT JOIN WHERE NULL

In Laravel, you can use the leftJoin method on a query builder instance to perform a left join, and then use the whereNull method to only include records where a column from the right-hand table is null:

php MySQL laravel laravel-4 eloquent

Laravel Migration table already exists, but I want to add new not the older

If you have an existing table in your database that you want to add new columns to using a Laravel migration, you can use the Schema::table method to modify the existing table.

php MySQL laravel

Laravel: getting a single value from a MySQL query

To get a single value from a MySQL query in Laravel, you can use the value method on a query builder instance.

php sql MySQL laravel