First off, we're using MySQL 5. I'd like to do something like the following: SET @fkcn = (SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = (SELECT DATABASE()) AND REFERENCED_TABLE_NAME = "ProviderOrder"); ALTER TABLE AuditProviderOrder DROP FOREIGN KEY @fkcn, DROP COLUMN ProviderOrderID;…
I'm trying to do some dynamic variable calculations on a select and reference those variables in the where statement. After searching the following is as close as I've been able to get thanks to Jonas's post here MySQL user-defined variable…
I have a table with these columns: event_time (date) event_data (json) player_account char() I'm trying to get all three fields from my query and groupBy by "player_account" field. The problem is doing this query: DB::connection('aa')-table('bb') ->where('event_time', ">", $date) ->select('event_time', 'event_data',…
I have table 1 and table 2, where Table 1 is master table and Table 2 is child table. Relationship of both table has been implemented by primary key of table 1(id) with table_1_id column in table 2. I need…
I am new in Java Spring. I created the default project by adding dependencies. Now I want the Weather database to be created when the application is launched, if it does not exist on the computer.I am using a mysql…
Trying to update a project to .NET 8.0. I updated all the related packages to match the 8.0 version. But it throws System.MissingMethodException: Method not found: 'Void CoreTypeMappingParameters..ctor at runtime. I tried to check the migrations in cli but most…
i am using vs code , jdk version(19), windows 10, java 17 for springboot ,mysql ,hibernate ,lombok etc . the project files are as follows; pom.xml <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>3.2.0</version> <relativePath/>…
I'm migrating my Laravel 10 project over to Sail. I'm running on Windows 10 and have WSL installed. Everything is working apart from connecting to the database. I keep getting: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select * from…
i have a sql query for summary my table, $this->where('kriteria =', 'fakir'); $this->where('zona !=', '0'); $this->select('surveyor,zona,kriteria,area'); $this->selectCount('surveyor', 'count'); $this->selectSum('nilai', 'nilai'); $this->groupBy('surveyor'); $this->groupBy('kriteria'); $this->groupBy('area'); $this->orderBy('kriteria', 'ASC'); $this->orderBy('zona', 'ASC'); $this->orderBy('count', 'DESC'); surveyor zona kriteria area COUNT RT06 RW07 1 FAKIR RUNGKUT 125…
I am trying to get a count of the below-noted SQL query. It will output the max value of the scan_freq column and I want to get a count of the rows of it. eg: The below query returned 1096…