I have the following line of code that keeps giving me an error that Engine object has no object execute. I think I have everything right but no idea what keeps happening. It seemed others had this issue and restarting…
I am trying to use the mysql_query statement to update records in my database. Can anyone understand why this code would not work and how I would manage to add dynamically the key values to the UPDATE statements ? ...…
I have a table that looks like this: ID Date Transition 45 01/Jan/09 1 23 08/Jan/09 1 12 02/Feb/09 1 77 14/Feb/09 0 39 20/Feb/09 1 33 02/Mar/09 1 I would like a query that returns a running total of…
I'm trying to convert the date field from YYYY-MM-DD HH:MM:SS:MS to MM/DD/YYYY format in a view using Snowflake database with below condition: TO_VARCHAR(DATE(SRC_DATE),'MM/DD/YYYY') I'm able to convert the date to expected format with above condition, but when I try to…
I have two tables, from which I need to select the latest purchase of each customer from the US. The query must present the user_id and the purchased item columns: (I left out some of the records from both tables)…
Is it possible to add a comma between each character of a string on mysql. From my_table id name 1 hello To : id name 1 h,e,l,l,o
Is it possible to split a word into separate lines? All the examples I found were using something to refer to as a comma or something, but I would like to separate each letter from a word, eg: from (my…
This query works good but ignores the AND members.active='1' condition completely. It delivers always the same results, no matter if active is 1 or 0. Any idea? select amount, count(*) AS quantity from ( SELECT participations.member_number, COUNT(participations.member_number) AS amount FROM…
I want to change the column name with a descriptive name, like in my table I have a field name "job_title", I want to replace this heading with "what is your job title", and job_description with "Describe your job description"…
A table (phototag) consists of two foreign key columns (photoid, tagid). I want to get the most related photos based on their tags. There are 4 million photos with 5-10 tags. For example, the photoid 10009 has 6 tags. I…