I'm trying to bind an array in a raw WHERE IN query in the Laravel DB example: $arr = [1,2,3]; DB::select(DB::raw("select * from test1 WHERE id IN ? "), [$arr
I'm trying to draw a graph with some arrays. I got 4 arrays (Time,Temprature,Speed,Water). I want to add Time array on AxisX. The others are going to be on Axis
I retrieve data from mysql server and one of the fields is an int value (1 or 0 ) and it's printed right (1 or zero ) but when I try to apply an if condition on
I am a beginner making use of a Roomdatabase. Mostly using it to load in and pass items between tables using simple relationships. package com.example.allin
I have database size is more than 125 GB . and every 1 hour the database is not respond . the message is every time say (The transaction log for database MESP_2
I'm trying to export a dictionary of words in sqlite made up only of words that start with, contain, or end with specific filters. If one filter was 'ment' and
In my project, using Quarkus, Angular and PostgreSQL DB, when I run the backend & and the frontend in dev Mode, I can connect to the DB (which is postgreSQL
I want to create an admin panel where I can change almost everything of the pages. Should we save every menu-item and its children in a different table in the d
My model: class Course(models.Model): language = models.ForeignKey(Language) name = models.CharField(max_length=50, unique=True, default='course')
I have searched for this answer on stack overflow, but I couldn't find any questions on this. I am new to Liquibase and want to learn Why Liquibase? When exactl
I am a Vb nooby and I have trouble to add specific Items to my Listview from a database. I would like to compare the value of a combobox with a column value of
Difficult to find this information for ElastiCache (for Redis) - if we can use databases with it such as 0, 1, 2 ... like it's possible in Redis.
When I used H2 database the database files are stored at C:\Users\MyName\TestDataBase.db directory. The H2 path is jdbc:h2:~/TestDataBase. This is default H2 da
I have a client side code, which is multi-threaded, calling updateInfo rpc method to the grpc server to update the information(Eventually will updata data in SQ
I'm trying to update a single column in multiple rows by appending the string '999': UPDATE integration.ol_orders SET order_id = ((SELECT order_id
I'm trying to sort multiple records for a model based on a field and store their ranks in DB. Like below: $instances = Model::orderBy('field')->get(); $ran
As per my knowledge, SYSDATE(), NOW(), CURRENT_TIMESTAMP, and CURRENT_TIMESTAMP() in MySQL are synonyms for one another. They all returns
I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to conn
Android, SQLite : I want to insert rows in between other rows in myTable using SQLite in android. For this, I am trying to increment ids of the all rows startin
I am pulling data from an online database using SQL/postgresql queries and converting it into a Python dataframe using Pandas. I want to be able to change the d