No, it’s not OK. Circular references between tables are messy. See this (decade old) article: SQL By Design: The Circular Reference Some DBMS can handle these, and with special care, but MySQL will have issues. Option 1 As your design, to make one of the two FKs nullable. This allows you to solve the chicken-and-egg … Read more
I know this question has been answered, but for me the problem was that the mysql server listens on a Unix socket not on a tcp socket. So the solution was to add: port: ‘/var/run/mysqld/mysqld.sock’ to the connection options.
Problem is the word VISIBLE, remove it and it will work. Index are visible by default. Your question: “If i remove VISIBLE it works just fine, so why did mysql workbench decided to add visible?” My answer: The option to mark index invisible is not yet implemented in MariaDB (afaik!). Update: The syntax for MariaDB … Read more
Tip for CSV exports: SELECT REPLACE(CAST(prijs_incl AS CHAR), ‘.’, ‘,’) will give you input that can be used as numeric fields in european excelsheets.
If you really must do it this way, you can use something like this: UPDATE messages SET test_read=1 WHERE id IN ( SELECT id FROM ( SELECT id FROM messages ORDER BY date_added DESC LIMIT 5, 5 ) tmp );
MySQL 8.0 uses a new default authentication plugin – caching_sha2_password – whereas MySQL 5.7 used a different one – mysql_native_password. Currently, the community Node.js drivers for MySQL don’t support compatible client-side authentication mechanisms for the new server plugin. A possible workaround is to alter the type of user account to use the old authentication plugin: … Read more
You’re looking for GROUP_CONCAT() Try this: select group_concat(MyString separator ‘, ‘) as myList from table where id < 4 Of course, you can group by the results.
You can use STR_TO_DATE() to convert the number to a date, and then back with MONTHNAME() SELECT MONTHNAME(STR_TO_DATE(6, ‘%m’)); +———————————+ | MONTHNAME(STR_TO_DATE(6, ‘%m’)) | +———————————+ | June | +———————————+ Warning: This could be slow if done over a lot of rows.
you need escape select * from mytable where mycol like ‘5\% off’ escape ‘\’; For a version that works regardless of NO_BACKSLASH_ESCAPES mode, you can use a different character, like pipe: select * from mytable where mycol like ‘5|% off’ escape ‘|’;
According to the MySQL manual MySQL uses Henry Spencer’s implementation of regular expressions, which is aimed at conformance with POSIX 1003.2 POSIX regexes don’t support using the question mark ? as a non-greedy (lazy) modifier to the star and plus quantifiers like PCRE (Perl Compatible Regular Expressions). This means you can’t use +? and *? … Read more