hello i need help i was try but give up i have table shipping id order_id supplier_id shipping_cost 1 37575000001 2 20000 2 37575000001 2 40000 3 37575000001 10 20000 4 37575000001 10 30000 i want to calculate height shipping_cost…
There are 2 tables and I have to join both the tables. Table A has few columns but both tables have "city_code" column. Table A has unique records if we talk about "city_code". Only 1 "city_code" can be entered. But…
We are upgrading MySQL from 5.7 to 8.0. Table cuatom_shapes has column shape with SRID=0, in which few rows have data with GEOMETRYCOLLECTION and few other rows have data with POLYGON. Though column SRID is set to 0, for POLYGON…
I am new to containerization and I am trying to learn docker to create an e-commerce microservices Spring Boot application. I've set up a docker-compose file that defines a multi-container application that includes services for Mysql, MongoDB, Mongo Express, and…
I was testing the query below thinking it would get me around the "can't use LIMIT in subqueries" restriction. The query runs but the average is simply the average of all the records WHERE MScores.MemberId=1193 AND MScores.Div="FSO" It seems to…
Error: Access denied for user 'pool18'@'192.168.105.3' (using password: YES) │ │ at Packet.asError │ │ (C:UsersSomjiworkspace2024skymet_strapi_newnode_modulesmysql2libpacketspacket.js:738:17) │ │ at ClientHandshake.execute │ │ (C:UsersSomjiworkspace2024skymet_strapi_newnode_modulesmysql2libcommandscommand.js:29:26) │ │ at Connection.handlePacket │ │ (C:UsersSomjiworkspace2024skymet_strapi_newnode_modulesmysql2libconnection.js:481:34) │ │ at PacketParser.onPacket │ │ (C:UsersSomjiworkspace2024skymet_strapi_newnode_modulesmysql2libconnection.js:97:12) │ │ at…
I have this error: "MySqlException: Cannot add or update a child row: a foreign_key constraint fails" on my C# project, when executing this code: INSERT INTO networks (owner_name, name, password, ip, visible) VALUES ('alex', 'alex_net', '1234', '192.168.1.1', 1) ON DUPLICATE…
CREATE TABLE `test` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `month` timestamp NOT NULL DEFAULT '2018-01-01 00:00:00', `b` varchar(255) NOT NULL DEFAULT '', `c` varchar(255) NOT NULL DEFAULT '', `d` varchar(255) NOT NULL DEFAULT '', `e` varchar(255) NOT NULL DEFAULT…
I want find Students id that , must have (professorId = 3 And courseId = 4) And (professorId = 3 And courseId = 2) And (professorId = 5 And courseId = 8). sometime these parenthesis is one or more than…
I have a query like select C.customerId, C.firstName, C.LastName, R.IsActive from Customer as C Inner join Rider as R ON R.customerId = C.customerid where R.rideid = 'xyz' and R.rideareacode = 'abc' and R.isActive = 1 This is taking too much…