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
I have a problem with making discord bot on repl.it, my list is 'ObservedList' and i dont know what to do with this, when I watch some tutorials its always just
We are currently moving the DB to another Server but we got a problem. Our Database is quite big and when we want to Import it to our new MariaDB Server with Ph
I am trying to set up MS SQL Server Express 2019 to listen on TCP/IP and connect to it through IP address instead of shared memory. I am currently connecting th
I'm currently studying Python by reading the book "Head First Python 2nd Edition" and it is really helpful and well-written, but I think it is a little anachron
My data in database: My objective is to retrieve all data of company collection (MongoDB) data from the database. The company collection holds one or many truc
I'm trying to design a database that would save matches and players in a 3v3 game. So far my models look like this : class Player(models.Model): user = mode
I'm trying to backup/restore a PostgreSQL database as is explained on the Docker website, but the data is not restored. The volumes used by the database image
I want to insert data in MySQL from a dataframe in R. I managed to connect without problems from R to MySQL using dbConnect, however when I try to insert my dat
I've just finished this tutorial for my app. But my problem is that even after I insert the data, my database is still empty. I checked that by viewing it in a
I want to insert data in MySQL from a dataframe in R. I managed to connect without problems from R to MySQL using dbConnect, however when I try to insert my dat
Here's my table like below p_no type name value ------------------------ 1 A Tomy 1 1 A Nick 2 1 B Tomy 3 1 B Nick 4 1
I have been asked this question in several interviews and I am looking for answers in the terms of how do we choose between MySQL database and NoSQL database fo
it's me again. I have a problem saving data to the database from the input form that I made. Here is my web route: Route::get('/admin/data-karyawan', [BasicKary