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)
);
- 136
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
- 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 ...
- 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/...
- 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 ...
- 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
- 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 ...
- 151
Only top scored, non community-wiki answers of a minimum length are eligible