What is the column name of the greatest item in Postgresql SQL Select?
I have such table (simplified) id pos neu neg x 1 2 3 y 4 2 1 z 1 5 2 I use PostgreSQL and my goal is to get greatest value for each row, so i use next query:…
Should MySQL & Yii2 SQL migration overwrite newly changed records?
I'm trying to create a migration that changes the records I need in a table $sql = ''; $sql .= "UPDATE card_series SET Code = 903 WHERE ID = 1600;"; $cardsSeries1600 = CardList::find() ->where(['seriesId' => 1600]) ->orderBy('ID') ->all(); $cardNum =…
Can MySQL join 3 tables & aggregate each w/o a subquery?
There are 3 tables, A, B, C. Table A has an id column, and B & C integer column which represents money and a_id which reference id in table A. Below is an example of table A, B, C table…
“How do I JOIN, THEN WHERE, THEN LIMIT/OFFSET in MySQL?”
my_tickets +-----------+---------+ | ticket_id | user_id | +-----------+---------+ | 186 | 2 | | 187 | 2 | | 188 | 2 | | 253 | 33 | | 254 | 33 | | 256 | 33 | | 261…
Why does SQL query return 0 results when string in database row has unique font?
Im running this query: SELECT id FROM posts WHERE title LIKE '%CERTIFIED INSTALLER%'; The text in the database is stored as 'ᴄᴇʀᴛɪꜰɪᴇᴅ ɪɴꜱᴛᴀʟʟᴇʀꜱ' which is of a unique font. The above query returns 0 results, but whenever I change 'ᴄᴇʀᴛɪꜰɪᴇᴅ…
Can MySQL v5 extract multiple occurrences from strings?
Folks! I need some ideas, with the follow problem: I have a table in MySQL v5 that stores a string in a field, like the following: {"content":{"serviceResponse":{"state":{"code":"04","gloss":"CONTINUE"},"products":[{"product":{"productCode":"1" ,"subProductCode":"1"},"productAmount":{"amountGranted":1100000},"groupRisk":{"riskGroup":"A2"},"additionalinformation":{"franchiseTC":"3"," percentAdvance":"70.0"}},{"product":{"productCode":"2"},"groupRisk":{}},{"product":{"productCode":"7"}}]," client":{"newClient":"false","riskGroup":{"riskGroupCode":"A2"}}}} I need a MySQL v5 (version is important) SQL query…
What is the avg session length in PostgresSQL?
I need some help. I have a table in PostgreSQL with logs of user sessions. The table has 3 fields: id, action, and action_date in the timestamp format. The action field has 2 possible values: "page_load" or "page_exit". The action_date…
Can Javascript solve the Snowflake Problem of populating a table with dates and its attributes?
I have a problem statement: Write a Stored Procedure that populates a table with certain date attributes. The data would be populated for 1 year. For example the date 14-07-2020 is passed as an input parameter, then the stored procedure…
Why does MySQL say “relation does not exist” when it does?
I'm getting an error while attempting to populate my table with the following query: INSERT INTO d_table SELECT category.name, film_category.film_id FROM category INNER JOIN film_category.film_id ON film_category.category_id = category.category_id It returns an error "relation film_category.film_id does not exist" These are…
Is it better to have a SQL table w/ a column almost always empty or a separate table w/ a foreign key?
I am trying to save what type of data is on a field, text, number or list. If the type is text or number that is it, but if it is a list I need to save what options it…