juergen d

Argentina

Age: 37

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

profile for juergen d on Stack Exchanges

4h
answered Auto generated number mysql
5h
revised Sort SQL string column with currency
edited tags
5h
comment Sort SQL string column with currency
Why not change the column type to a number and don't store the currency or store it in a different column
5h
comment Sort SQL string column with currency
What Db engine do you use?
6h
comment MySQL joins - correct way
This is very basic SQL. Please take a tutorial first
8h
comment MySQL performance: DATE vs TINYINT
Comparing with null does not work with <>. You have to use the IS operator
8h
comment Cutting SELECT query time in MySQL
Add the output of explain select ...
9h
comment Reuse query results in a different query
That is very basic SQL. Please take a tutorial first.
11h
comment Desing ER Diagram
We won't do it for you. Where are you stuck currently?
23h
comment Why my bind is not passing parameters? Help please
Build a query for every table of your DB.
23h
comment Why my bind is not passing parameters? Help please
You can't bind table or column names. Only values
1d
comment Using Bash to add a line as a new MySql entry
dev.mysql.com/doc/refman/5.1/en/load-data.html
1d
answered mysql | show tables with specified name
1d
revised MySQL variable format for a "NOT IN" list of values
edited tags; edited tags
1d
comment MySQL product extra's
How are the extras related to the products? Can a product have any extra?
1d
comment Taking MYSQL query out of for loop
SELECT * FROM guest_list_guests where id in (1,2,3)
1d
answered Select from multiple rows based on values compare
2d
awarded Constituent
Apr
16
revised want columns value to be changed in output query
added 24 characters in body
Apr
15
accepted Enum in WPF ComboxBox with localized names
1 2 3 4 5