juergen d

Argentina

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

profile for juergen d on Stack Exchanges

19h
comment In SQL server what is the difference between using = and join?
You are using the old legacy join syntax. Use explicit join syntax like your professor
1d
comment Select * from table group by date (week incriment)
SELECT yearweek(date), group_concat(id) FROM tbl group by yearweek(date)
1d
revised Combine 2 queries in single query
added 10 characters in body
1d
comment Faster access to my comments
I am just refering to its name which is on top of it when opening it.
1d
comment mysql throwing syntax error for curdate() function
If you want date and time use CURRENT_TIMESTAMP
1d
comment Faster access to my comments
I want a general "messages" box.
1d
revised Insert Column Values from Multiple Rows into a Single Row
added 42 characters in body
1d
asked Faster access to my comments
1d
comment Getting value from a table and add value from table 2 if excist
See this great explanation of joins
1d
comment I want a basic syntax to create a time dimension table in MYSQL
What do you actally need to do?
1d
comment More efficient way than 'using UserID in (1,2,3 ...)'
Are the IDs also in a table or where are they coming from?
1d
comment Reuse deleted primary keys implementation
NO, no, no, no, no!!!!!! Don't do that. Don't mess with the auto-incremented keys. What do you really need?
2d
revised Fill a column with a sequence int numbers in MySQL
added 15 characters in body
2d
answered Fill a column with a sequence int numbers in MySQL
2d
comment How to sort / order different mysqli queries
How about adding your table structure, example data, expected output and the query you are stuck with?
2d
answered How to Extract Months and also show the totals for that month
2d
revised How to Extract Months and also show the totals for that month
added 10 characters in body
2d
answered Sum the total hours and group by hours
2d
comment SQL Group by Week Date
Google sql server week start date
2d
revised Query to get max time from a group by for each group
added 136 characters in body
1 2 3 4 5