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 =…
I've a query SELECT COUNT(*) AS mock_test_count FROM mock_test WHERE isActive = 1 AND id NOT IN ( SELECT mock_test_id FROM mock_tests_given_by_students WHERE student_id = 2 ) I'm using prisma orm. already gone through the docs of nested query in…
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…
my_tickets +-----------+---------+ | ticket_id | user_id | +-----------+---------+ | 186 | 2 | | 187 | 2 | | 188 | 2 | | 253 | 33 | | 254 | 33 | | 256 | 33 | | 261…
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 'ᴄᴇʀᴛɪꜰɪᴇᴅ…
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…
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…
Trying to connect with MySQL server with my SpringBoot application but facing above issue, can someone suggest? spring.datasource.url=jdbc:mysql://localhost:3306/myblog spring.datasourse.username=Admin spring.datasourse.password=Admin spring.jpa.properties.hibernate.dailect=org.hibernate.dialect.MySQLDialect spring.jpa.hibernate.ddl-auto=update Error as per below java.sql.SQLException: Access denied for user 'hp'@'localhost' (using password: NO) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) ~[mysql-connector-j-8.0.33.jar:8.0.33] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)…
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…
Im building a java microservice that uses AWS Aurora Mysql for some operations. the code connects to the database fine and the first 3 queries I had were throwing a similar error till I realized I was missing semicolons. The…