Hot answers tagged

2 votes

MySQL code error

You need to remove the comma after the last column declaration. CREATE TABLE student ( student_id INT PRIMARY KEY, first_name VARCHAR(20), major VARCHAR(20) );
user avatar
2 votes
Accepted

MySQL error 'with base as' subqueries and GROUP BY

select subdomain, MIN(id) AS min_id from clients group by subdomain having count(*) > 1
user avatar
  • 68.8k
2 votes
Accepted

Load huge mysqldump (500G)

How long do you mean when you say forever? Hours? Days? I wouldn't be surprised if it takes days. Importing an .sql dump file is notoriously time-consuming. It is bound to be single-threaded, so you ...
user avatar
  • 9,821
1 vote

How to tell if a particular MariaDB / MySQL server supports the Barracuda storage format?

All MySQL versions after 5.5.5 support Barracuda, and set innodb_file_format to Barracuda by default. Here's an excerpt from the archived MySQL 5.5 documentation: https://docs.oracle.com/cd/E19957-01/...
user avatar
  • 9,821
1 vote
Accepted

MySQL incorrect equality casting bigint to char

I'm shooting myself in the foot, why does it hurt? This is by design: In all other cases, the arguments are compared as floating-point (double-precision) numbers. For example, a comparison of string ...
user avatar
  • 21.6k
1 vote

pt-online-schema-change failed when creating new tablle, specified key was too long; max key length is 767 bytes issue

Can you live with 191 instead of 225? If not, your 5 options (including that one) are here: http://mysql.rjweb.org/doc.php/limits#767_limit_in_innodb_indexes
user avatar
  • 68.8k
1 vote

MySQL:How to correct a corrupted MySQL binary log on Master server?

This error is usually caused by a hardware glitch or a bug so vague that it hasn't been found in over a decade. The optimal solution that will definitely fix it without any risk of anomalies is to ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible