Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Bookmarks inbookmarks:mine
inbookmarks:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options user 199116

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

0
votes
0answers
The default foreign key contrain of MariaDB ON UPDATE and ON DELETE is RESTRICT. However, in my schema, most foreign keys have ON UPDATE / ON DELETE set to CASCADE. Although I appreciate the explici …
asked Feb 18 '20 by user209974
0
votes
1answer
I have a table that stores Windows system paths. I am scratching my head about how to store them and in particular which collation to use. The paths are unicode strings. They are case insensitive, th …
asked Jan 29 '20 by user209974
0
votes
1answer
Then mysql --user=user --password=password fails with a ERROR 1045 (28000): Access denied for user 'user'@'host' (using password: YES) So far so good. … However, mysql --user=user --password=password --ssl succeeds, even though I did not provide any client certificate. status shows SSL: Cipher in use is DHE-RSA-AES256-GCM-SHA384 …
asked Jan 28 '20 by user209974
1
vote
1answer
The MySQL documentation says they do it, and that's all you need to know: MySQL parses but ignores “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined … MySQL accepts REFERENCES clauses only when specified as part of a separate FOREIGN KEY specification. …
asked Apr 1 '20 by user209974
3
votes
1answer
I have a table that contains data (blobs). Data is often read, rarely inserted, and never modified. For all of this data, I compute hashes that I also store in the DB. These hashes are only checked w …
asked Jan 17 '20 by user209974