Where is a good place to find help with some basic sql? I am having a
problem getting the query results I need. Don't tell me to consult the
manual because that is the first place I turned to. I just need a real life
example of the solution to see be able to pick it apart. I posted the
request
How can I write a query that answers the following question: Which stores
have not entered soups in the collection_schedule for the current day? I
just want to get a list that shows the stores.code, stores.name,
stores.phone of all the stores that failed to update the soups for the day.
collect
I realize this may be a little OT but I'm sure many of us MySQL rookies
would be interested in the responses.
I would be interested in hearing how someone goes about planning the layout
of their database including how they determine what tables, fields, column
types, queries, etc they will need.
Hi!
This query works: select date_format(date, "%W, %e %M %Y") as date from
table
This query doesn't: select concat(date_format(date, "%W, %e %M %Y"),"
",another) as time_of_day
I'm wondering if it is possible to use concat in this way and how if it is
possible.
Thanks!
Jeff
