Top "Mysql" questions

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

How do I create a user with the same privileges as root in MySQL/MariaDB?

How do I create a user with the same privileges as root in MySQL/MariaDB?.

mysql
GROUP_CONCAT comma separator - MySQL

I have a query where I am using GROUP_CONCAT and a custom separator as my results may contain commas: …

mysql group-concat separator
Inserting a Python datetime.datetime object into MySQL

I have a date column in a MySQL table. I want to insert a datetime.datetime() object into this column. …

python mysql datetime
In MySQL, can I copy one row to insert into the same table?

insert into table select * from table where primarykey=1 I just want to copy one row to insert into the same …

mysql copy duplicates row
Bogus foreign key constraint fail

I get this error message: ERROR 1217 (23000) at line 40: Cannot delete or update a parent row: a foreign key constraint fails ... …

mysql innodb
mysql: see all open connections to a given database?

With administrative permissions im mysql, how can I see all the open connections to a specific db in my server?

mysql database
What's the default password of mariadb on fedora?

I installed mysql through yum just now and the OS fedora installed mariadb for me. I know mariadb is a …

mysql passwords fedora mariadb
Removing MySQL 5.7 Completely

I am trying to uninstall mysql from my ubuntu 12.04 completely. But not able to. I tried a lot of commands. …

mysql ubuntu
How do you uninstall MySQL from Mac OS X?

I accidentally installed the PowerPC version of MySQL on my Intel Mac in Snow Leopard, and it installed without a …

mysql macos osx-snow-leopard
Any way to select without causing locking in MySQL?

Query: SELECT COUNT(online.account_id) cnt from online; But online table is also modified by an event, so frequently …

mysql locking