The in-built Auto-Increment in MySQL doesn't meet my requirement so I'm thinking about making a new one. Here is my requirement: Create an increment serial num
I'm wanting to use the rust implementation of LMDB but I can't seem to find whether it would always maintain a copy of whats in memory also in the disk and vice
I was trying to solve problem in Hackerrank SQL Practice section and stuck in Problem 'Weather Observation Problem 20'. To find Median, I though of the followin
I have MySQL installed on an Ubuntu machine. When I run use TWEETDATA command it shows me following error ERROR 1049 (42000): Unknown database 'tweetdata' Bu
I created the django model "User" with "null=True" as shown below: # "myapp/models.py" from django.db import models class User(models.Model):
I have a set of HTML files and a SQLite database, which I would like to access from the browser, using the file:// scheme. Is it possible to access the database
Here is my schema using sqlite, I am not sure if this is a good way to create tree structure in sql as I have to traverse many time to obtain the entire tree, a
I want to query my mongodb to perform a non-match between 2 collections. Here is my structure : CollectionA : _id, name, firstname, website_account_key, emai
In documentation there's deleteMany() method Character.deleteMany({ name: /Stark/, age: { $gte: 18 } }, function (err) {}); I want to remove multiple documents
Can the UPDATE query be used without a WHERE clause? And if so in what conditions?
I cannot figure out a solution for exporting data from the Teradata database in a parquet format. I am using tdload and tbuild method which required tpt script
In some cases, running an UPDATE statement in production can save the day. However a borked update can be worse than the initial problem. Short of using a test
How would I find duplicate fields in a mongo collection. I'd like to check if any of the "name" fields are duplicates. { "name" : "ksqn291", "__v" : 0
I have my ORACLE table with structure as desc extraction_log1 Name Null
I have a table with a column like this that is currently live: name NVARCHAR(128) NOT NULL DEFAULT '' I am altering the column like this to make it nullable:
I need to make a survey for my website. I have this: Route: Route::resource('survey','surveyController'); Controller: public function index() { $show=surve
I am looking for an ETL solution that has all the necessary components with limited hand-coding that helps to migrate data from Oceanbase DB to AWS aurora. I tr
I am revising for a Database course and I have the following question from a past assignment: The database schema is as follows: LIKES(drinker,beer); FREQUENTS
All the Solutions I found for this Problem don't work for me. I'm just loading one Dataset and after approximate 150 Request I get this Error: Error: Packets o
I'm pretty new in angular. i created a modal window to user share story and after that show it in body: html <button class="btn btn-primary new-story" n