juergen d

Argentina

Age: 38

I learn a lot by participating on Stack Exchange. I like that!

profile for juergen d on Stack Exchanges

1h
comment How do I create an SQL table only if it doesn't exist?
If you already tried if not exists then the error lies in the code part of you app which you don't show and not in the query itself
2h
revised SQL MAX() function selects the greatest in absolute value even if I don't use ABS()?
edited tags
2h
answered SQL MAX() function selects the greatest in absolute value even if I don't use ABS()?
2h
accepted New navigation page does not remember settings when clicking the NEW tab
2h
comment What is the best book to master sql?
This is not the place for recommendations
2h
comment How to speed up left join queries by indexing?
No, they won't.
3h
comment How to speed up left join queries by indexing?
Where did you get that from? Aliases are not needed. You only need them if you join the same table twice or to name subqueries. You can use them for better readability. But thats it. They don't speed up anything!
3h
comment MariaDB : IN condition in a subquery to a view with count
What are you trying to do in your own words?
3h
comment How to speed up left join queries by indexing?
virtual alias? What is that?
3h
comment How to speed up left join queries by indexing?
Use explain select ... to see which indexes are used and which you need to add
4h
comment How to delete a single row in android sqlite
The column names yes, But not complete source files.
4h
comment How to delete a single row in android sqlite
We don't do the debugging for you. Please add only the very relevant code parts.
5h
comment MySQL Query Date Great than specific date
OP mentioned that date_despatched is a date field already, Using DATE() removes the ability of using indexes which makes the query slow.
5h
comment SQL - How insert into one single table column a array?
@Andrew: It is slow, complicated to handle and against every DB normalization rule.
5h
comment SQL - How insert into one single table column a array?
No, no, no, no, no! Never store multiple values in a single column!
5h
answered MySQL Query Date Great than specific date
6h
comment Syntax error in SQLite creating a table
or use backticks to escape the name
6h
comment Update a row value in SQL database after submit based on selected checkbox(es)
What exactly do you ask for? The query?
6h
comment Postgres collation on aliased field
In Postgresql you probably can't use an alias in the order clause at all
19h
revised Join tables and update column on multiple conditions
added 27 characters in body
1 2 3 4 5