Snippets
MySQL

How-to articles, tricks, and solutions about MYSQL

"Database query failed: Data truncated for column 'column_name' at row 1

This error message is indicating that a database query has failed due to data being too large to fit into a specific column in the database table.

php MySQL

Base table or view not found: 1146 Table Laravel 5

Error 1146: Table 'table_name' doesn't exist

php MySQL laravel

Best practice multi language website

One best practice for implementing a multi-language website in PHP is to use a language detection library such as Text-Language-Detect.

php MySQL localization internationalization multilingual

Best way to check if mysql_query returned any results?

To check if a MySQL query returned any results, you can use the mysqli_num_rows function.

php MySQL

Calculate age based on date of birth

Here is some sample PHP code that calculates a person's age based on their date of birth:

Checking for an empty result (PHP, PDO, and MySQL)

In PHP, you can use the PDO (PHP Data Objects) extension to interact with a MySQL database.

php MySQL pdo

Codeigniter's `where` and `or_where`

In CodeIgniter, the where method on the database class is used to add a WHERE clause to your query.

php MySQL codeigniter activerecord

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure is an exception that is thrown when there is a failure in the communication link between your Java program and the MySQL database. This can happen for a variety of reason

java MySQL jdbc

Commands out of sync; you can't run this command now

The "Commands out of sync; you can't run this command now" error in PHP usually occurs when you have called a MySQL function in an incorrect order.

php sql MySQL mysqli

Connect Java to a MySQL database

To connect a Java application to a MySQL database, you need to use the JDBC (Java Database Connectivity) API.

java MySQL jdbc

1 2 3 4 5 > >>