Questions tagged [sql]

SQL is known as Structured Query Language and serves as a powerful tool for querying databases. When asking questions about SQL, it is recommended to provide comprehensive information such as code examples, table structure, sample data, and the specific DBMS implementation being used (e.g., MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2, etc.). If your question specifically pertains to a certain DBMS with its own unique extensions or features, be sure to include that particular tag. It's crucial to note that answers provided for SQL-related questions should adhere to the ISO/IEC standard SQL.

← Prev 1 2 3 4 5 6 Next →

Divergent outcomes observed in MSSQL between SSMS and Node JS script

Recently, I encountered an issue with a SQL query that retrieves customer transaction headers based on their card_number. The query should return an audit_number column. Surprisingly, when executing the query in SSMS software, the results are correct; howe ...

Generating JSON using a column as a key in Azure SQL

In my SQL server table, I have the following data: Name Value ValueHash city 111 zzz address 333 yyy email [email protected] xxx name 222 www I need to retrieve the JSON format shown below using a SQL query { "address": { ...

sql json sql-server azure-sql-database

'middle' designation is set as 'None', as per the anticipated value

Having trouble with my import.py, check50 is returning 5 out of 6. Issues occur when the 'middle' name is returned as 'None' instead of without single quotes. I'm unsure how to fix this problem. Below is the code from my import.py ...

python sql cs50

typeorm querybuilder: retrieve nested relations only

Among the entities I'm working with are: Group { id: number; name: string; persons: Person[]; } Person { name: string; items: Item[]; } Item { name: string; active: boolean; } What I have at my disposal: an array containing ...

sql node.js nestjs typeorm

When querying a table for JSON_VALUE, it often returns null instead of the expected value

JSON data is stored in a column called 'DataJson' within a table [{ "KickOffDate": "1-Jan-2019", "TeamSize": "11", "ClientEngineer": "Sagar", "WaitingPeriod": "16.5" }] A query is performed to extract specific values from the JS ...

sql json sql-server json-value

Eliminate redundant data from a large database using Laravel

I am currently facing an issue with a table containing 5 million records, which has duplicate rows that I need to remove. Here is the code I have been using: $userRoles = Model::groupBy('phone','user_id','name')->get(); $userRolesId = array_column($user ...

php sql laravel

Working with Express for Database Queries

Seeking assistance to retrieve a specific row from the database table when id = 1 (or another value). Attempting localhost:3000/product/1 in a browser, but encountering issues. The code snippet is as follows: const { query } = require('../db/db'); const ...

sql postgresql express

No results were returned when querying MySQL with Node.js

I am currently facing an issue with retrieving query results from a MySQL database in Node.js. The 'results.affectedRows' always returns undefined for me. I am using a Mac operating system. If anyone could help me solve this problem, I would greatly appr ...

mysql sql node.js express

Troubleshooting NodeJS Express Inner Join Problem

Currently, I am utilizing NodeJS in combination with Express and attempting to run an inner join statement. Here is the code snippet: getAllGrades: function(callback) { var sql = "SELECT * FROM questions INNER JOIN questionanswers ON (questions.qu ...

mysql sql node.js express

Looking to implement a condition that prevents the echoing of HTML code when a certain template ID is selected?

Struggling with inherited PHP MVC code for a website, I encounter an issue on a specific page where unwanted code is echoed out. To prevent this, I aim to skip the echoing when a specific templateID (which I set as default) is selected. However, I'm unsure ...

php html sql

Retrieve all tag values from the field and store them in an array

UPDATE : I require obtaining all values in the tags field! MY Query : $query = db_select('node', 'node'); $query->fields('tagsdata',array('name')); $query->fields('node', array('nid')); $query->leftJoin('field_data_field_tags', 'tags', 'tags.en ...

php sql drupal

Using Yii2 Active Record to find records where a field value is divisible

When working in SQL, I was able to select records where their IDs are divisible by 4 using the following query: SELECT id FROM table_name WHERE id%4 = 0; However, when attempting this in Yii2 active record, it resulted in an error: $model = Verses::find() ...

php sql activerecord yii2

What is the best way to retrieve the following record that is greater than or equal to the current one in Symfony?

Check out the code snippet below: $c = new Criteria(); $c->addAscendingOrderByColumn(ItemPeer::ITEM_DATE); $c->add(ItemPeer::ITEM_DATE, $item->getItemDate(), Criteria::GREATER_THAN); $this->next = ItemPeer::doSelectOne($c); The code functions ...

php sql symfony-1.4 propel

Error occurred during JSON parsing: String in the JSON object is not properly terminated

Can someone help me with this problem I'm facing? I am trying to fetch a JSON object from my Node.js backend that is the result of a MySQL operation. Here's the code snippet: app.get('/get_events/:playgroundId', cors(), function(req,res){ var playgr ...

mysql sql json reactjs react-native

Querying a JSON field in BigQuery yields empty results

Once more, I am struggling with my SQL query on a JSON field in bigquery. This JSON data can be found at this link - The specific record I am working with has an id of 1675816490 Here is the SQL statement I am using: SELECT ##JSON_EXTRACT(jso ...

sql json google-bigquery unnest

Converting Phone Numbers, Fax Numbers, and Zip Codes for Input into a Database

I'm facing an issue with masked inputs for Phone, Fax, and Zip Code on my webpage. The Phone and Fax numbers are currently formatted as (999) 999-9999, while the Zip Code is in the format 99999-9999. However, when I submit the page, the database requi ...

php jquery sql maskedinput

How can I retrieve the output of an Insert query?

I'm facing a straightforward query here - I am currently working with two tables, where the second table has a foreign key column referring to table A. Table A: id Name ---------------- 1 Name1 2 Name2 Table B: id Name P ...

php sql mysql

Using Pandas in Python to filter and group data based on specific criteria

Consider a dataset that contains both categorical and numerical columns, such as a salary dataset. The columns can be categorized as follows: ['job', 'country_origin', 'age', 'salary', 'degree','marital_status'] There are four categorical columns and two ...

python sql pandas group-by

Embracing Laravel for Enhanced Functionality on an Established Website

During my internship at a company, I have been tasked with updating the database by adding new features and forms directly through editing PHP files on the network using notepad++ and FileZilla for the past two weeks. Some users suggested I try Laravel t ...

php mysql sql database laravel

Seamless Integration of Full Calendar Functionality with SQL Database

I'm currently experiencing difficulty in utilizing FullCalendar's impressive jQuery calendar plugin for my application, specifically in generating events from SQL Server. Here is the code snippet: First JS $(document).ready(function() { var date = ...

php jquery sql sql-server fullcalendar

Retrieve the row based on the user_id and also include any rows that have the same event_id as that entry

I have a table with the following structure: _______________________________ | event_id | user_id | username | |-------------------------------| | 30 | 1 | user1 | | 30 | 2 | user2 | | 30 | 3 | user3 | | 31 ...

mysql sql node.js json

Extracting data from JSON column using a variable element name

I have a database table with JSON data that I need to decode and store in a relational database. The table is for an Oracle DB 19.0 and it looks like this: CREATE TABLE J_PAGE ( PK_PAGE_ID NUMBER ( 10 , 0 ) , FK_RESP_ID NUMBER ( 10 ...

sql json oracle

Sorry, but we are experiencing difficulties processing your request at the moment. HTTP ERROR 500: We are unable to locate the

My code seems to be functioning correctly when connecting to the database, but I'm encountering an error. Here is the code snippet: <?php include 'header.php'; ?> <!DOCTYPE html> <html> <head> <t ...

php html css sql

What are the steps for generating a derived table by combining data from two separate tables?

I am working with two base tables TABLE_1 and TABLE_2. My goal is to create a third table that combines the ID columns from both tables. I am in need of an SQL query to generate the new table called NEW_TABLE where ID_1 and ID_2 are combined to form a pri ...

php mysql sql

PHP PDO property array management features

php sql arrays pdo

Enhance and append data to MySQL output

Is it achievable to include a custom key value pair to the existing SQL result? <?php require_once "dbaccess.php"; $json = array(); $access = new DatabaseAccess(); $sql = $access->Connect(); $stmt = $sql->prepare("select * f ...

php mysql sql json pdo

The sum function in MySQL only seems to work accurately for the first row, but can often give

Here is the SQL query I am using: SELECT `cuenta`.`reservaId`, sum(`cuenta`.`tarifaTotal`) FROM `check`,`cuenta`,`comanda`,`reserva` WHERE `comanda`.`id`=`cuenta`.`idComanda` AND `comanda`.`tipo`=0 GROUP BY `cuenta`.`reservaId` ORDER BY `check`.`id` Howe ...

php mysql sql

What are the various categories for the ASP.NET AJAX accordion menu?

I have encountered an issue with my SQL tables, specifically Categories and Posts. When I try to select the top 5 records for each category and display them in an accordion menu, it shows the category names for each post repeatedly. Below is a snippet of ...

sql ajax asp.net-ajax accordionpane

Retrieve data from two tables in PHP and display the table name

My current PHP code is designed to retrieve data from two different tables in MySQL using the UNION statement. $sql=" SELECT 'ticket_updates' as rowTable, sequence, ticket_seq, notes as displaydata, date ...

php mysql sql pdo

Making changes to a specific JSON value within a JSON Array in SQL

I am looking to make changes to an existing JSON value within a JSON array. I have the ability to add a new JSON object to the array using JSON_MODIFY. For example, if my JSON looks like this: [{"id":"101","name":"John"}, {"id":"102","name":"peter"}] How ...

sql json sql-server t-sql

How can I fetch data from SQL using JavaScript based on a specific value in PHP?

My application is built using the Yii2 framework. Within my application, there is a view.php file that consists of an element and a button. The element, <div id="userId">, contains the user's login ID, and I aim to use the button to re ...

javascript php jquery sql yii2

PHP script inadvertently revealing sensitive information from MySQL database

Currently, I am working on a project that requires extracting flight information from a database. My desired output format is as follows: 01 Nov 2017 - Eastern Airways 7601 Departing from Southampton, Eastleigh (SOU) at 0840 However, when I run my code ...

php mysql sql

Calculating the mean rating for each shop with MySQL

I am trying to combine the shop table with the rating table in order to fetch a list of all shops along with their individual ratings. However, my current query only returns shops that have ratings in the rating table. I want to display a rating of 0 for s ...

php mysql sql codeigniter join

Update columns from a separate DataFrame and fill in any missing values with "NA

My goal is to conditionally fill missing values and update the information from another dataframe. I need to update the data in the values column of the smalldf dataframe by filling in missing values based on conditions. The condition specifies that if t ...

python sql pandas dataframe

What factors should you consider when deciding between NoSQL and SQL databases?

Here's my query: I am interested in learning Node.js/Express and creating a basic web project. The project would involve setting up a database with tables for users, video games, and categories. The website will simply display a list of games (for demonst ...

sql node.js mongodb express nosql

Verifying JSON array compatibility in PostgreSQL database

I am facing a challenge with a JSONB array in my postgres database. It is structured as follows: { "id" : 22323, "details" : [ { "status" : "stage1", "timestamp" : "201 ...

sql json postgresql

Creating a query in SQL

After developing a scoring system that ordered users by their points in descending order, I initially stored ranks in a separate column. To update the rank, I ran through this loop: $i = 1; $numberOfRows = mysql_query('SELECT COUNT(`id`) FROM sector0_ ...

php mysql sql

Find the total of the first two entries in a table using PHP SQL

Is there a way to calculate the total sum of the daily_rate_price field from only the first two rows in the daily_rates table? daily_rate_id daily_rate_date daily_rate_price daily_rate_reservation 1480 2021-11-18 280.00 320 1481 2021-11-19 280.00 ...

php sql

Insert multiple text box values as a new entry in an SQL database

Currently, I am implementing a code snippet to incorporate additional text boxes within a form. The main purpose is to enable users to input multiple languages they are proficient in. <script> jQuery(function($) { var i = 0; ...

javascript php jquery sql ajax

I am eager to retrieve and showcase the images stored in the database

When I execute the code below, it displays encrypted symbols in the output like this [[�ѥ��1}j�i�Ƥ�^i�췼ܨ5��l�r�Ejק�r:��}=��""]�Q[n�C6��ZVv{��!��Y�j��>|�2��o��#�T ...

php sql database

Step-by-step guide to showcasing and refreshing input values retrieved from the database in Laravel

How can I allow users to update their profile information displayed in input fields pulled from the database? Controller.php // Display user details in input field Public function userDetails() { $id = auth()->id; $details = Users::where('id', ...

php sql laravel database eloquent

Having trouble with executing Athena query using athena-express when using req.body as input

Seeking guidance on querying specific data from AWS Athena using req.body parameters. When attempting to execute the query with req.body in postman, encountering the following error: Error: SYNTAX_ERROR: line 1:1: Incorrect number of parameters: expected 1 ...

sql node.js amazon-web-services amazon-athena

Guide for displaying SQL data in an HTML table

I am currently working on transferring my SQL data to an HTML format. The code I have so far is not functioning as expected. I attempted to include HTML within my PHP code, and now I am considering if it would be better to do it the other way around (emb ...

php html mysql sql

Visualize data from ajax call in tabular format

I want to display the results of an SQL query in a table using AJAX. I have written code that executes the query during the AJAX call, but when I try to display these values in a table, it shows null values on the div tag. What could be the reason for this ...

javascript html sql ajax

Tips for effortlessly adding a JSON object to a table

Let's imagine we have a table structured like this: id| name | family ---+------+--------- 1 | iman | marashi 2 | mike | ... 3 | john | ... 4 | | Now, we also have a JSON object that we want to add to the table: {"name ":"will","family":"smith ...

php mysql sql json sql-insert

Show a hierarchical representation of the tree structure from the object up to the second level only

Here is the table structure I am working with: |human_id | parent_id | name | I want to display the data in a tree-like format. For example: Alisa --Robin --Miranda --Mark Max Robin --Robert --John The current select statement I have includes joins and ...

php mysql sql

Can I sort the outcomes based on a particular meta key's value?

I am attempting to display the total value of all orders in specific status that have the payment method "ppec-paypal". I have experimented with using the AND function to filter by meta.meta_value. add_shortcode( 'show_total_pp', 'show_tot ...

php sql wordpress woocommerce shortcode

Error Encountered: Attempting to invoke a method on a variable that is not an

function finishGame($outcome) { $query = "UPDATE stats SET outcome = ? WHERE id = ?"; $statement = $this->connection->prepare($query); $statement->bind_param("si", $outcome, $this->currentSession);//Issue here $statement-& ...

php sql mysql prepared-statement

What is the proper way to integrate a PHP variable containing an SQL query into an already existing SQL query using the $db->updatePhoneNumbers() method?

I'm currently developing a database for Users where each user can have multiple phone numbers. To accomplish this, I've implemented a JavaScript function in the form that generates new input fields and stores the information in a nested array. My approach ...

php mysql sql arrays

Making the MySQL Select & Update command easier

I have implemented a basic messaging system on my website for logged-in members to send messages to each other. I am utilizing two tables, 'authors' (which is essentially my users table) and 'messages'. Here are the details of each: Authors: aId int(20) ...

php mysql sql select sql-update

I am encountering an issue with my PHP code that is causing an error

Whenever I try to submit my form, I keep encountering this error message. Can anyone offer some assistance with this issue? Error: Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/u378761662/ ...

php html sql database forms

Tips for updating a column with just one button in AngularJS

On my list page, there is an Unapproved button. I am new to angular and struggling to figure out how to retrieve the post's id and update the corresponding column in the database to mark it as approved. Can someone provide guidance on how to accomplish thi ...

javascript sql forms angularjs sql-update

Iterate over an array in JavaScript and include the elements as parameters in an SQL query

Can I set an SQL string to a variable in JavaScript and populate part of it by looping through an array? Here is the initial SQL: var tag = ["fun", "beach", "sun"]; var sql = "SELECT * FROM myTable " +"WHERE id > 5" //... // L ...

javascript sql loops

Does the SQL query ignore the 'where' clause when the variable is false?

I'm dealing with a situation that's leaving me puzzled. I have the solution to my problem, but the why behind it is eluding me and starting to drive me a bit insane. Controller DB::connection()->enableQueryLog(); $transfer = Transfer::where ...

php mysql sql laravel

Azure Function: Eliminate duplicate data in JSON from two many-to-many relationships into a single table

I am facing an issue where I have multiple many-to-many tables mapping to a single table, resulting in duplicate data that needs to be removed from the JSON output. Additionally, the Ingredients and Conditions are displayed as lists, causing duplication of ...

c#sql json azure-functions

What is the best way to display the output after retrieving an array?

Database : --> product table P_id P_name P_uploadKey 1 Cemera 7365 2 Notebook 7222 3 Monitor 7355 4 Printer 7242 --> buy table B_id P_id B_nam ...

php html sql

What is the best way to execute a SQL query within a JavaScript loop or map function?

I have a task at hand: Iterate through an array of objects using the map function Execute multiple SQL queries based on each object Append the query results to the respective objects The array I'm looping through contains offers, which are objects with a ...

sql node.js postgresql async-await

Does MySQL JSON_OBJECT maintain the value order?

I'm encountering an issue with a query that returns a JSON object. I need the formatted_criteria to display the values in a specific order - first 'Location' and then 'Radius'. However, it seems like the results are sticking to the original order of the cr ...

sql json mysql-5.7

What is the best way to change the orientation of column names from vertical to horizontal?

I have a simple code snippet below that currently displays all 75 column names in a vertical format. However, I need these column names to be displayed horizontally with a period between each one. I have tried different approaches, but they all seem over ...

php sql

PHP/SQL - Error: Integrity constraint violation in SQL statement [23000]

Warning: Array to string conversion in C:\Users\Caleb\PhpstormProjects\barberspoint-flakkee\appointment.php on line 75 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint ...

php mysql sql

What are the steps to integrate a database into my Next.js application?

While I was experimenting with integrating postgresql into a nextjs project, I encountered an error 405 when trying to create an account. Below is the error message in the browser console: page.tsx:14 POST http://localhost:3000/api/auth/ ...

sql typescript next.js prisma next.js13

The outcomes of PHP and SQL interactions

Resolved: the issue was that it wasn't allowing me to run SQL injection, so redefining the $conn under mysqli resolved it. $conn = new mysqli('IP', 'Database', 'Password', 'Username'); $query = "SELECT Auth FROM users WHERE userId = ".(int)$_SESSION['user ...

php mysql sql

What is the best way to find the maximum value of a string in a group by operation in

python sql dataframe group

How should I organize mySQL code within a nodejs application?

Lately, I've been working on a project and utilizing node.js as my backend. Instead of using MongoDB, I've opted for MySQL as my DBMS due to specific requirements in my project. However, I'm facing challenges in structuring my MySQL queries effectively and ...

mysql sql node.js express relational-database

SQL - Struggling to Define Relationships Without Filtering Too Many Results?

I am relatively new to SQL coding and I have encountered an issue with grouping Company names with route IDs from 4 different tables. The code snippet I am currently using is returning more records than expected and mixing up company names with route IDs i ...

php sql phpmyadmin

What is the best way to transfer specific data from one field within a JSON column to another in PostgreSQL?

Let's say we have a table named users with a JSON column called "foo". The values in that column are structured like this: "{ field1: ['bar', 'bar2', 'bar3'], field2: ['baz', 'baz2', 'baz3&apo ...

sql json postgresql

What is the correct way to designate a column as tinyint(4) using the Sequelize ORM framework?

I am in the process of defining my table with the following structure: CREATE TABLE `test` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `o_id` int(11) unsigned NOT NULL, `m_name` varchar(45) NOT NULL, `o_name` varchar(45) NOT NULL, `customer ...

mysql sql node.js sequelize.js

Extracting Values from JSON in SQL Server Made Easy

My database in SQL Server contains a table with two columns: ID and JSON. The JSON column holds JSON-formatted text. I have access to functions like ISJSON, JSON_VALUE, and JSON_QUERY, but unfortunately not OPENJSON. I'm attempting to write a query t ...

sql json sql-server

Tips for performing calculations on JSON data within Postgres

I have AdWords report data stored in a Postgres database. Each report is saved in a table called Reports with a jsonb column named 'data'. The 'data' field of each report contains JSON that looks like this: [ { match_type: "exact ...

sql json postgresql jsonb

Retrieving Response Data from a SQL Callback Function in Node.js

Currently, I am working on a node.js application that includes a registration function. Within this function, the challenge lies in verifying whether a username has already been taken or not. My issue arises from the fact that the SQL module in node only a ...

sql node.js functional-programming

determining the percentile for a vast dataset

My database holds student information related to test codes and the marks they achieved for each test. I am looking to recalculate percentile marks for students corresponding to each test code. Although I have a code for a series of test codes, it is not ...

php sql percentile

Tips for combining tables and outputting as JSON format?

I currently have PostgreSQL set up with the following table structure: CREATE TABLE "objs"("number" Integer,"name" Text NOT NULL, "price" Text NOT NULL ); CREATE TABLE "users"("name" Text NOT NUL ...

sql json postgresql

What is the process for importing a .sql file into Selenium in order to run various scripts simultaneously in the Selenium environment?

Is there a way to run multiple commands in selenium, such as inserting, updating, and selecting * from employee? How can I accomplish this task? ...

mysql sql selenium selenium-webdriver

Removing the key from the output of FOR JSON PATH in SQL 2016: A step-by-step guide

Lately, we have incorporated the usage of FOR JSON PATH in our SQL code for various reasons. However, I am currently facing a slight issue in a specific scenario. My aim is to obtain a JSON string containing a list of OrderItemIds. Instead, what I am getti ...

sql json sql-server

Adding PHP SQL to a WordPress environment is a great way to enhance the functionality

I am facing an issue with my PHP code which is working fine. However, I need help in converting this code to work in a WordPress environment. I have looked into WordPress SQL but find it confusing. Can someone please assist me in rewriting this code to f ...

php sql wordpress select

← Prev 1 2 3 4 5 6 Next →

Newtab Q&A