Subscribe to RSS

Question 1

The professor asked us to create two tables and alter them. create table student ( name varchar(25) not null, std_num int(12), std_num(primary) ); When I click "Run SQL", it ...

Question 2

So recently i started a project on Python with Flask as a newbie and wanted to create a "Register and Login Page" everything was going well. But when I arrived to create a table in database ...

Question 3

I put and did not put AUTOINCREMENT for id in person table as shown below: CREATE TABLE person ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT # ↑↑↑↑↑↑↑↑↑↑↑↑↑ ); CREATE TABLE person ...

Question 4

I need help creating database tables from html tables. Right now I'm just manually doing it. I have a html doc that has all the data but I don't know what the best way to extract the data. <html ...

Question 5

ASP.NET MS SQL table: tblPets ID (123456789) AnimalType (Dog, Cat, Goldfish...) AnimalName (Rudolf, Ben, Harold...) CountryCode (US, AU..) StateCode (CA, NY...) CityCode (AK, LA...) IsMammal (True, ...

Question 6

I'm trying to get the columns name from "users" table in my database using detFieldNames function in codeigniter 4 but something went wrong. Here is the error: Error Model class: class ...

Question 7

I am using DynamoDB under Python environment and I would like to use the following DynamoDB as an example: id time value 1 1 1 2 2 3 1 2 4 1 3 4 1 4 6 I would like to have a table that has unique id ...

Question 8

I would like to store upwards of 100 time series in DynamoDB for each user. The data is aggregate monthly counts and is used for comparing monthly usage to permitted usage under varying subscription ...

Question 9

I have two types of users. For example: Male 2 Female Now I have created a table of 'users' that holds all the common information and 'males' and 'females' will hold specific information related to ...

Question 10

On SQLite, I displayed the table "user" as shown below but "Null" is not displayed so I cannot differentiate between "Null" and Blank(Empty String): sqlite> .header on ...

Question 11

I'm trying to write a PL/SQL script that searches the entire database for a string and report the tables and columns it finds it in. It looks like this: DECLARE ncount NUMBER; vwhere VARCHAR2(1000)...

Question 12

I have 2 tables i.e employee details and employee designation history. Employee details table - EMPID , Name , Age ,Gender. (EmpID - Primary Key) Designation history table - EMPID , Startdate , ...

Question 13

I have created database table ZSP_EMP_DET inside which I am performing CRUD operations by providing values through screen . So I have tried to find if record is already present in table or not and if ...

Question 14

Question 15

Collectives™ on Stack Overflow

SQL: Error: near "(": syntax error | primary key problem

Solution on SQLAlchemy 3 on creating tables with flask-shell or Python shell [duplicate]

AUTOINCREMENT vs No AUTOINCREMENT in SQLite

Create database tables from html tables

Indexes needed for user advanced filter?

Error Call to a member function getFieldNames() on null in codeigniter 4

How to put the constrain of duplicated entries in DynamoDB?

Table design for monthly (time series) counts/stats in DynamoDB

How to create database table based on the type of the users

How to display `Null` (SQLite)

How do I limit my PL/SQL query to search only relevant tables?

I want to add multiple job roles for different durations in designation history table . how can i get it in ABAP?

How to Modify the data inside database table for existing record in ABAP?

Display empty value when there is no data on the table

Query to select data from row into column in SQL Server [duplicate]

Hot Network Questions