i have 2 different table "anakelangs" and "absen" I want to retrieve data from both tables and show them in somekind of list result table Condition here is : get name (there are other columns in this table) from anakelangs…
I am using AJAX to automatically update text inputs and textareas and save them to the database. Everything works until there are two of form the same form. I figured out the AJAX function is taking the values from the…
CREATE PROCEDURE test() BEGIN SELECT 'hello, I am a Procedure' AS hi; END Error: ERROR: syntax error (example position: "SELECT") LINE 3: SELECT 'hello, I am a Procedure' AS hi; ^ ERROR: syntax error (example position: "SELECT") SQL state: 42601…
I do not know why this isn't working. Is it something about using parameters in the query twice? Using PHP 7.4.33, Postgres PostgreSQL 9.6.22. Error is: Warning: pg_query_params(): Query failed: ERROR: inconsistent types deduced for parameter $2 LINE 11: ,…
So my query is CREATE TABLE POSITION( ID INT AUTO_INCREMENT PRIMARY KEY, NAME CHAR(2) NOT NULL ); and if i try to run this creation i receive ERROR 1064 (42000): You have an error in your SQL syntax; check the…
I have a table CREATE TABLE IF NOT EXISTS club.climbers ( climber_id SERIAL PRIMARY KEY, climber_first_name VARCHAR(20) NOT NULL, climber_last_name VARCHAR(30) NOT NULL, climber_full_name TEXT GENERATED ALWAYS AS (climber_first_name || ' ' || climber_last_name) STORED NOT NULL, sex_id INTEGER NOT…
Im trying to create a table on mysql using php. i send an array containing the columnname and the actual data. the first position is the columnname and the rest is the actual data. Ive managed to create the table…
See the query below where I get the reputation value from direct addition without a function. SELECT "User"."id", "User"."name", "User"."title", "User"."about", "User"."location", "User"."isModerator", "User"."createdAt", ( -- question vote COALESCE(SUM("PostVote"."value" * 10) FILTER (WHERE "value" = 1 AND "Post"."questionId" IS NULL),…
I'm working on a Laravel project and I have a scenario where I need to enforce a unique constraint on multiple columns in a database table. Specifically, I want to ensure that the combination of column1 and column2 is unique.…
I need to converting a statement from MySQL to Postgres. The error is on this statement "INTERVAL $3 DAY". I am following a certain tutorial on building web apps using Go. MySQL - insrt:= INSERT INTO snippets (title, content, created,…