Top "Mysql" questions

Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@'localhost' (using password: YES)

An application was handed to me by an old colleague to manage. However, whenever I try to run it, I …

php mysql mysql-error-1045

MyBatis, how to get the auto generated key of an insert? [MySql]

how can I get the generated key of an insert with MyBatis? I read many pages about this question but …

java mysql insert mybatis

Table is 'read only'

When I want to execute an update query on my table I got an error saying: 1036 - Table data is …

mysql freebsd sql-update

How to build simple reviewing and 5-star rating system?

I'm very new to web technologies and this is basically for a term project that my team is working on. …

php mysql rating-system

Querying multiple databases at once

I have WordPress instances with each in its own database. For an update I need to query all active plugins, …

mysql multiple-databases

PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers

I'm trying to connect to a MySQL database from Symfony 3 application. But when trying to create MySQL schema from a …

php mysql pdo

SQL query to prepend prefix to existing value in a field

I have searched and searched for an answer to this, and I think this must be child's play for anyone …

mysql sql joomla phpmyadmin

PHP date showing '1970-01-01 ' after conversion

I have a form in which date format is dd/mm/yyyy . For searching database , I hanverted the date format …

php mysql date strtotime

Joomla! 3 installation freezes at creating database table

I am trying to install Joomla! 3.2.1 on my system but the installation freezes half way through. I've downloaded and installed …

mysql installation wampserver freeze joomla3.0

Swapping column values in MySQL

I have a MySQL table with coordinates, the column names are X and Y. Now I want to swap the …

mysql database