Top "Mysql" questions

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

How to set initial value and auto increment in MySQL?

How do I set the initial value for an "id" column in a MySQL table that start from 1001? I want …

mysql insert auto-increment
Access denied for user 'root'@'localhost' while attempting to grant privileges. How do I grant privileges?

I've looked at a number of similar questions and so I'm demonstrating that I've checked the basics. Though of course, …

mysql mysql-error-1045
How can I view live MySQL queries?

How can I trace MySQL queries on my Linux server as they happen? For example I'd love to set up …

mysql monitoring
Adding multiple columns AFTER a specific column in MySQL

I need to add multiple columns to a table but position the columns after a column called lastname. I have …

mysql ddl
ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

I have created tables in MySQL Workbench as shown below : ORDRE table: CREATE TABLE Ordre ( OrdreID INT NOT NULL, OrdreDato …

mysql sql mariadb mysql-error-1452
How to take backup of a single table in a MySQL database?

By default, mysqldump takes the backup of an entire database. I need to backup a single table in MySQL. Is …

mysql backup restore
How to install Python MySQLdb module using pip?

How can I install the MySQLdb module for Python using pip?

python mysql pip
What is the MySQL VARCHAR max size?

I would like to know what the max size is for a MySQL VARCHAR type. I read that the max …

mysql varchar maxlength
connecting to MySQL from the command line

How can you connect to MySQL from the command line in a Mac? (i.e. show me the code) I'm …

mysql
SQL Group By with an Order By

I have a table of tags and want to get the highest count tags from the list. Sample data looks …

mysql sql mysql-error-1111