Category "database"

Redirect wordpress website to another site

I moved my wordpress website with updraftpluse backup plugin to another domain and now when I open new domain website redircet to Previous domain. what can I do

Pre-define the number of rows in mysql

I am making a cinema booking system for my dbms project. for the bookings table , I only want a certain number of inserts in a table to be possible. How can i a

Bloom Filters with the Kirsch Mitzenmacher optimization

I have recently started playing around with Bloom Filters, and I have a use case in which this calculator suggests to use 15 different and unrelated hash functi

Is the logic and the implementation of this query correct?

So i have a table that logs users using certain apps. It has the fields below id time app user server type (can be IN or OUT) So a user starts using a certain

Django many-to-many relations

I'm trying to create a web app in which users can participate in some groups (every user can be part of multiple groups), and I want to be able to make both que

Learning MySQL with PopSQL and wanted to carry on with a tutorial but I cant connect to my database. Error 1049 No connection

I opened PopSQL and the there is a red dot at my connection. If I go into it and test it, it tells me Unknown database 'giraffe'. I opened mySQL and typed 'show

Initializing an hyperarray parameter agent attribute from a database

I am similar problem to this Initializing an array agent attribute from a database but Im having a problem as it brings back the whole row of data and not only

print multiple return from void to multiple textboxes in c#

i'm trying to build a question-solving module, so i want to randomly print the "correct answer" data i got from the database, i use a void to get the data, i wa

Sorting and getting position or row nth number of sqlite database for Android studio

I have this table of students public void onCreate(SQLiteDatabase db) { String createTableStatement= "CREATE TABLE " + STUDENT_TABLES + " (" + ID_COL + "

Improve insert performance for a C# application into SQL database

I need to improve the performance of my insert in my C# application. I first go out and get data from a view. Then I go through a FOREACH loop to insert into a

JSON Database doesn't work correctly as per REST technique

I created a JSON server and this is the data that I'm using. However, when I'm trying to query the examlist and relate it to the students (i'd like to receive t

ngIf display button if a field has certain value in Database

I need to have a button (by ngIf) when a field in Db has certain value, Any Idea? Do I need store procedure and.. Thanks

What are the rules for collection names in SOLR?

What is the naming ruleset for collections that should be followed, or in other words what are the inacceptable characters for a collection name? (for example,

app.post('\pageNameOrCanBeAnyRandomName')?

I have a page called createEmployee.js which includes 2 functions (fetchData and createNewEmployee) ... see below: const fetchData = async() => { c

Set and get Image in objectbox

I want to set and get image from local storage, but I have no idea how to do this.

Python sqlite3.OperationalError: no such table:

I am trying to store data about pupils at a school. I've done a few tables before, such as one for passwords and Teachers which I will later bring together in o

Can associative entities be inherited?

Suppose in the ER diagram there is an associative entity named makes call which connects the entities External entity and Internal entity. Is it possible for th

SQL Error when using Order By for SQL database query in PowerBI Desktop

Getting this error when using Get Data with PowerBI Desktop to connect to SQL database Microsoft SQL: The ORDER BY clause is invalid in views, inline functions,

Connecting Delphi to a online database

I have a project where we need to create a application for capture infomation from a 'tournament', for example a soccer knock out tournament where you have to

Looking for an arabic names database :

I want a free database having all arabic names in english spelling (like : Ahmed, Oussama ,Fatima.... ) I've looked in internet but i did found this : https://w