Recent questions tagged SQL

0 votes

573 views

1 answer

sql server - Primary and Foreign Key at the same time

Would it be possible in SQL Server 2008 to have a table created with 2 columns that are at the same time ... searched and came up with nothing. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

287 views

1 answer

sql - How to find a string inside a entire database?

I have one specific string, such as "123abcd" for example but I don't know the name of the table or ... statement to do something like this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

336 views

1 answer

sql - Update with two tables?

I am trying to update table A with data from table B. I thought I could do something like: UPDATE A SET A.name = ... idea of how I can do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

533 views

1 answer

sql - How do I delete multiple rows with different IDs?

I want to do something like this: DELETE FROM table WHERE id IN (SELECT ....) How can I do that? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

670 views

1 answer

sql - ROW_NUMBER Without ORDER BY

I've to add row number in my existing query so that I can track how much data has been added into ... . Please provide the better solution. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

372 views

1 answer

sql - Is varchar(MAX) always preferable?

Regarding SQL Server, I understand : var means the memory is lazy allocated, meaning it fits to the data exactly ... enforce on this DB column? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

408 views

1 answer

sql - Store select query's output in one array in postgres

My code is: SELECT column_name FROM information.SCHEMA.columns WHERE table_name = 'aean' It returns column ... need to initialize colnames? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

550 views

1 answer

sql - How to sort the result from string_agg()

I have a table: CREATE TABLE tblproducts ( productid integer, product character varying(20) ) With the rows: INSERT ... using PostgreSQL 9.2.4. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

409 views

1 answer

sql server - Docker SQL bind: An attempt was made to access a socket in a way forbidden by its access permissions

Error-message when creating container in Docker for SQL-server (with Admin-rights): " Error response from daemon: ... under "netstat -abn" ) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

365 views

1 answer

sql server - How to select similar sets in SQL

I have the following tables: Order ---- ID (pk) OrderItem ---- OrderID (fk -> Order.ID) ItemID ( ... for any similarity would be preferable. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

395 views

1 answer

sql - How to take backup of functions only in Postgres

I want to take backup of all functions in my postgres database.How to take backup of functions only in Postgres? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

322 views

1 answer

sql - No indexes on small tables?

"We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all ... on these tables. Correct? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

377 views

1 answer

sql - Finding rows with same values in multiple columns

I am trying to find rows that have duplicate values, but only based off of a select number of columns, ... values same rows from single table See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

368 views

1 answer

sql - SQLite ORDER BY string containing number starting with 0

as the title states: I have a select query, which I'm trying to "order by" a field which contains numbers, the ... " convert it like C's atoi? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

556 views

1 answer

sql - Android Room database file is empty - .db, .db-shm, .db-wal

Using room in android for database. When I tried to see the data in sqlviewer then no tables found in ... /data/packageName/databases/Myapp.db See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

559 views

1 answer

sql - What is the meaning of grave accent (AKA backtick) quoted characters in MySQL?

I was wondering why some tutorials and other MySQL management tools use grave accent (`) in their queries like ... , FieldB, FieldC FROM TableA See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

551 views

1 answer

sql - Difference between INT PRIMARY KEY and INTEGER PRIMARY KEY SQLite

Is there any difference between INT PRIMARY KEY and INTEGER PRIMARY KEY when defining a schema for a table? ... the first and second variants? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

539 views

1 answer

sql - Changing precision of numeric column in Oracle

Currently I have a column that is declared as a NUMBER. I want to change the precision of the column to ... between the transfers and drops. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

835 views

1 answer

sql - How to get input file name as column in AWS Athena external tables

I have external tables created in AWS Athena to query S3 data, however, the location path has 1000+ files. So ... ways to achieve the same. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

349 views

1 answer

sql - adding a column description

Does anyone know how to add a description to a SQL Server column by running a script? I know you can add a ... for the column is also added? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

426 views

1 answer

sql - Selecting rows where remainder (modulo) is 1 after division by 2?

There is a column in options that hold an integer. I want to select the row only if that value % 2 = 1. I know ... is it possible to do it in 1? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

359 views

1 answer

sql server - How to write "not in ()" sql query using join

Could some one please provide how to write following sql query using joins. I do not want use not in as well as ... ) I am using SQL Server 2008 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

546 views

1 answer

sql - Can I add a not null column without DEFAULT value

Can I add a column which is I specify as NOT NULL,I don't want to specify the DEFAULT value but MS-SQL ... , if No please specify the reason. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

524 views

1 answer

sql - Tinyint vs Bit?

I don't want to touch-off a religious war here, but there seem to be two schools of thoughts in how to represent ... " you need to values > 1? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

563 views

1 answer

sql - PostgreSQL: Remove attribute from JSON column

I need to remove some attributes from a json type column. The Table: CREATE TABLE my_table( id VARCHAR(80), ... table would be enough, too. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

556 views

1 answer

sql - How to drop multiple tables in PostgreSQL using a wildcard

When working with partitions, there is often a need to delete all partitions at once. However DROP TABLE tablename ... command with a wildcard? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

661 views

1 answer

sql - MySql: ORDER BY parent and child

I have a table like: +------+---------+- | id | parent | +------+---------+ | 2043 | ... I hope). Is it possible withoug adding a sort-field? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

309 views

1 answer

sql - Different approach of using IN clause in MySql

Today I have posted an answer with a query like this SELECT * FROM table_name where column_name IN (val1,val2,.. ... use on IN in queries. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags