Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

MySQL Error #1133 - Can't find any matching row in the user table

Unable to set password for a user using 3.5.2.2 - phpMyAdmin for 5.5.27 - MySQL. When trying to set the password while …

mysql phpmyadmin mysql-error-1064
MySQL duplicate entry error even though there is no duplicate entry

I am using MySQL 5.1.56, MyISAM. My table looks like this: CREATE TABLE IF NOT EXISTS `my_table` ( `number` int(11) NOT …

mysql primary-key mysql-error-1062 duplicates
MySQL: Quick breakdown of the types of joins

I would like a quick breakdown of the types of MySQL joins. I know of these, the rest I am …

mysql join
How to get ER model of database from server with Workbench

Is there any way to get an ER model of a database from the server that is connected to my …

mysql entity-relationship mysql-workbench
MySQL DELETE FROM with subquery as condition

I am trying to do a query like this: DELETE FROM term_hierarchy AS th WHERE th.parent = 1015 AND th.…

mysql sql subquery sql-delete in-subquery
mysqli or PDO - what are the pros and cons?

In our place we're split between using mysqli and PDO for stuff like prepared statements and transaction support. Some projects …

php mysql pdo mysqli database-abstraction
Python 3.4.0 with MySQL database

I have installed Python version 3.4.0 and I would like to do a project with MySQL database. I downloaded and tried …

python mysql python-3.x mysql-python python-3.4
How to turn on/off MySQL strict mode in localhost (xampp)?

I want to know how to check whether MySQL strict mode is on or off in localhost(xampp). If on …

mysql xampp localhost mariadb mariasql
How to secure phpMyAdmin

I have noticed that there are strange requests to my website trying to find phpmyadmin, like /phpmyadmin/ /pma/ etc. Now …

php mysql security ubuntu phpmyadmin
Convert MySql DateTime stamp into JavaScript's Date format

Does anyone know how I can take a MySQL datetime data type value, such as YYYY-MM-DD HH:MM:SS and …

javascript jquery mysql datetime