Advertisements im having the same issue a lot of people are having that the server exits as soon as i try to run it. i tried following the advice from this stackoverflow but no luck: Why does my Spring Boot App always shutdown immediately after starting? its literally a new server so not sure what… Read More my spring boot app shuts down as soon as i open it

Advertisements Good day coders, I need to make a query where I find a manufacturer.name (For example: "Logistics") only when the name is contained inside a string (For instance: "Logistics spa"). How can I do this? This is my manufacturer table model: id name 0 Logistics 1 TE CONNECTIVITY My database Engine is ISAM, and… Read More I need to find if a string value is contained in a string in SQL

Advertisements I am trying to update a field in a table using a SELECT query, when I execute I see the errors: 08:10:16 UPDATE TABLE `Tesla-20240105` SET `state`=1 WHERE `id` IN (SELECT `id` FROM `Tesla-20240105` WHERE `state` IS NULL LIMIT 10) Error Code: 1064. You have an error in your SQL syntax; check the manual… Read More MariaDB, UPDATE with SELECT, LIMIT in subquery

Advertisements I have a MariaDB table with 28 million rows. I need to update all the rows (locally) with a new value in a column. This is the code in Python to batch update: update_query = "UPDATE table SET column = %s WHERE `index` = %s" %time cursor.executemany(update_query, update_data) column has an index, and index… Read More Are there any obvious bottlenecks in my MariaDB UPDATE?

Advertisements I’m struggling trying to query a database inside of a PHP class. I’m getting an error when trying to echo out the email address. I’m new to classes and can’t seem to get this to work but if I do a normal PHP function, it works fine. // using composer autoload.php $user = new… Read More Uncaught PDOException: Syntax error or access violation: You have an error in your SQL syntax

Advertisements I am trying to create a table in mariadb, but each time I try adding a foreign key it returns an error message. When I try to create the table without the foreign key it works. Here is the code without the foreign key that executes. create table countries( country_id int(249) auto_increment primary key,… Read More How do I add foreign Key to mariadb?

Advertisements I need to convert values of $.fonts_size json property to float. Currently there are integer values such as 1 and I need them to become 1.0 to make my app treat them as double. In this case json like: { "fonts_size": 1 } Should be converted to: { "fonts_size": 1.0 } Is that possible… Read More How to convert integer value to float in json column in MariaDB?

Advertisements I Have a next SQL Query: const val INSERT_OR_UPDATE_ITEM_SQL = "" + "INSERT INTO `items` (owner_id, object_id, item_id, count, enchant_level, item_location, item_location_data, custom_type1, custom_type2, duration_left, create_time)" + "VALUES (?,?,?,?,?,?,?,?,?,?,?) " + "ON DUPLICATE KEY UPDATE owner_id=?,object_id=?,item_id=?,count=?,enchant_level=?,item_location=?,item_location_data=?,custom_type1=?,custom_type2=?,duration_left=?,create_time=?" And this is preparation of PreparedStatement: statement.setString(1, item.ownerId) statement.setInt(2, item.objectId) statement.setInt(3, item.template.id) statement.setInt(4, item.count) statement.setInt(5, item.enchantLevel) statement.setString(6, item.itemLocation.name)… Read More Java, JDBC INSERT ON DUPLICATE KEY UPDATE wild cards

Advertisements I have created a docker image for my spring boot application but i am not able to get that to run. Kindly help me figure this out java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:address=(host=localhost)(port=3306)(type=primary). Connection refused . . 2023-04-25T13:04:41.969Z WARN 1 — [ main] o.h.e.j.e.i.JdbcEnvironmentInitiator : HHH000342: Could not obtain connection to query metadata… Read More spring boot application is running but its docker image cant connect to maria DB which is installed localy

Advertisements I got into a problem with the SQL IF statement. And I tried a few another statement, but it doesn’t work too. I got my code here: DELIMITER $ BEGIN NOT ATOMIC IF user = ‘test’ THEN SELECT fox FROM conv WHERE user = test; ELSE INSERT INTO pending_conv (pending) VALUES (‘test’); END IF;… Read More How can I fix this IF statement error in sql