Skip to main content
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"
Saves in:saves
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 not deleted user 8876

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.

1 vote
3 answers
10k views

Is it possible to allow missing value inserts in mysql instead of requiring "NULL" in the qu... [closed]

I am writing a script to insert values from a file into a mysql database. The script reads lines from the file and constructs insert queries from them. … Is it possible to acheive this behaviour in mysql? …
MrVimes's user avatar
  • 629
0 votes
3 answers
921 views

Mysql query that is very quick (but sometimes very slow) versus an alternative version of th...

have very limited granted privileges on, so I can't utilize performance improving tricks that I'm used to using on an internal MS SQl database (such as creating helpful temporary tables) Is there any mysql
MrVimes's user avatar
  • 629
0 votes

Mysql query that is very quick (but sometimes very slow) versus an alternative version of th...

I (seem to have) fixed this by adding a query to check the creation date of the account. and created_at >= (select created_at from customers where username = '__username__' ) (username is string_repl …
MrVimes's user avatar
  • 629