314 questions
-1
votes
2
answers
705
views
SQL: Error: near "(": syntax error | primary key problem
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 ...
- 1
-2
votes
1
answer
129
views
AUTOINCREMENT vs No AUTOINCREMENT in SQLite
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 ...
- 42.7k
-1
votes
2
answers
57
views
Indexes needed for user advanced filter?
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, ...
- 618
0
votes
1
answer
1k
views
How to put the constrain of duplicated entries in DynamoDB?
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 ...
- 1,446
0
votes
1
answer
162
views
How to create database table based on the type of the users
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 ...
1
vote
4
answers
207
views
How do I limit my PL/SQL query to search only relevant tables?
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)...
- 2,039
0
votes
1
answer
5k
views
How to Modify the data inside database table for existing record in ABAP?
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 ...
- 59
0
votes
1
answer
2k
views
Query to select data from row into column in SQL Server [duplicate]
I have example table like this :
type value
-----------------------
Name | John
Gender | Male
Address | New City
Phone | 62813
etc... | etc...
I want to make ...
0
votes
1
answer
410
views
Check if a certain Table in MYSQL Database is empty C# (skeleton table)
My application starts with the login menu, a user provides his login credentials and the process of comparing passwords (hashed) goes on, logged in if everything is fine and error handlers kick in if ...
- 137
0
votes
1
answer
837
views
Creating Sub-Tables within a Table in PHPMyAdmin
I have this Menu for a restaurant with food categorized into different groups i.e.:
For the Breakfast (food here)
Salads (food here)
Cold Beverages (drinks here)
Hot Beverages (drinks here)
etc. ...
...
- 137
0
votes
1
answer
654
views
Cross-platform way to check if "DUAL" table exists in SQL
I have an application that has the potential to use either an Oracle, MySQL, or SQL Server. In a few queries, I need to use the "DUAL" table, for example:
SELECT (CASE WHEN EXISTS (SELECT 1 ...
- 3,968
1
vote
2
answers
91
views
Difficulties with creating a function to delete data from the database
I created a button in the table to implement the function of deleting data on the site, I did everything according to the video tutorial and after I did everything refreshing the page I got an error:
...
- 51
3
votes
1
answer
373
views
How to amend my script to add row call back function in database tables
I would appreciate any help in ammending my script to add row call back function in database tables.
Using datatables I want to show the row number. I have found the code provided by @Pehmolelu
in ...
user14762984
0
votes
1
answer
492
views
How to pass large set of datas from one activity to another activity in android using database
I have a json file which contains a large size of data such as place id, latitude, longitude and date. I want to pass this data from one activity to another. When I am doing this same with Intent the ...
0
votes
2
answers
2k
views
Transaction isolation level for a table in Microsoft SQL Server
It's more a confirmation of what I thought rather than a question. Can one change the isolation level on a table-basis in SQL Server or can it only be defined/changed on a session level as by the ...
- 692
1
vote
1
answer
5k
views
Hive one line command to catch SCHEMA + TABLE NAME info
Is there a way to catch all schema + table name info in a single command through Hive in a similar way to
SELECT * FROM information_schema.tables
from the PostgreSQL world?
show databases and show ...
- 5,015
0
votes
0
answers
400
views
How to create a separate table for each user/store user specific data using sqlite3
I am using sqlite3 for python to build a notes management application using tkinter. I wanted to know how can I create a separate table to handle each user's data (contains id, tags and memo for each ...
0
votes
1
answer
1k
views
How to select multiple tables in single query mysql? (some tables have no data yet)
I have 3 tables called patients, customers and deliveries. Those tables are in the same database called db.
All the tables equally have id, first_name, last_name, gender and only deliveries table has ...
- 406
-3
votes
1
answer
3k
views
Which SAP table do I need to find annual sales? [closed]
I don't know much about SAP but I need the annual sales (the total amount of what was sold in a certain year) for DSO calculation. In which SAP table is this stored? VBAK?
Also for this calculation ...
- 1
1
vote
0
answers
765
views
Compare columns in CSV with columns in database table in JAVA
I have a CSV with 44 columns and I have a table with 21 columns. Need to check of the columns in CSV along with the data matches with columns and data in database table
I have created 2 class (one ...
- 117
1
vote
1
answer
402
views
Count rows in all schemas (with permission granted) in all tables
I'm trying to count the rows in all the tables in the database. Since the answer I'd like to get must differentiate between different schemas I also take into account the schema that a particular ...
- 1,467
0
votes
0
answers
909
views
What does WALInitSync actually mean?
I am using postgresql and pgadmin. I had a table (about 12 million rows) from another database which I wanted to transfer to a table in a new database. So I created a custom backup of that table and ...
- 379
0
votes
3
answers
59
views
SQL GROUP BY with two tables involved
Could you guys help me to make SELECT query for my simple case:
Table A:
UserID UserName
10 John
11 Mike
12 Matt
Table B:
SessionID UserID SessionTime
124 ...
- 364
3
votes
1
answer
2k
views
approximate count of rows in postgresql django
I have a postgresql database connected to with django. In database there is lots of big tables which I want their row count. Because of large size of tables this takes a lot of time to execute.
I ...
- 2,218
1
vote
1
answer
569
views
Monitoring progress of a SQL script with many UPDATEs in MariaDB
I'm running a script with several million update statements like this:
UPDATE data SET value = 0.9234 WHERE fId = 47616 AND modDate = '2018-09-24' AND valueDate = '2007-09-01' AND last_updated < ...
- 5,515