juergen d

Argentina

Age: 37

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


profile for juergen d on Stack Exchanges

1h
comment MySQL Trigger Syntax
There is no column update mechanism in MySQL. It should be after update on PC
1h
answered Mysql query with count on another table
1h
revised Mysql query with count on another table
added 8 characters in body
1h
comment Error when inserting into sql database using php
Either quote your string values or better use Prepared Statements
7h
comment Slow query in SQLite with index and what is better?
How many records does you query return?
9h
answered How to get particular date in mysql?
9h
revised break into ranges using sql
added 46 characters in body; edited tags
9h
comment How to search for substring in one of two fields of a table
I don't see any syntax error in the query you posted The column names are quoted.
17h
comment Query Mysql Error : Not unique table/alias
If you join the same table again then you need to give these tables different names to distinguish them. And BTW you use a table that you don't even join.
20h
revised ORDER BY field ASC with NULL items at end
added 12 characters in body
22h
answered Using IS NULL vs NOT IN
22h
answered MySQL return rows where one value exists in another column
23h
answered ORDER BY field ASC with NULL items at end
1d
comment Advanced SQLite query on many-to-many relationship
I updated the query.
1d
revised Advanced SQLite query on many-to-many relationship
added 79 characters in body
1d
revised Filtering Rows in SQL using conditions
added 44 characters in body
1d
answered mysql use of in clause throws an error
1d
comment Very slow JOIN query
Probably because you join on a function call which can't make use of indexes.
1d
comment Selecting a data from column
This is very basic SQL. Please take a tutorial first.
1d
answered Advanced SQLite query on many-to-many relationship
1 2 3 4 5