Recent questions tagged SQL

0 votes

772 views

1 answer

sql - How to change string date to MySQL date format at time of import of CSV using MySQL's LOAD DATA LOCAL INFILE

I'm using MySQL's LOAD DATA LOCAL INFILE SQL statement to load data from a CSV file into an existing database table. ... Feb-10', '%d-%b-%y') See Question&Answers more detail:os...

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

0 votes

465 views

1 answer

sql server - What does a timestamp in T-Sql mean in C#?

I'm trying to develop a model object to hold a Sql Server row, and I understand perfectly how to do this except ... to mark as the Answer. Sigh. See Question&Answers more detail:os...

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

0 votes

703 views

1 answer

sql - MySQL subquery returns more than one row

I am executing this query: SELECT voterfile_county.Name, voterfile_precienct.PREC_ID, voterfile_precienct.Name, COUNT(( ... syntax error. See Question&Answers more detail:os...

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

0 votes

658 views

1 answer

sql - Difference between === null and isNull in Spark DataDrame

I am bit confused with the difference when we are using df.filter(col("c1") === null) and df.filter ... me to understand the difference. Thanks See Question&Answers more detail:os...

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

0 votes

492 views

1 answer

sql - Grant SELECT permission on a view, but not on underlying objects

I often read that one purpose of a VIEW is security: to allow some users access to the underlying table, ... expose the underlying objects too? See Question&Answers more detail:os...

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

0 votes

458 views

1 answer

sql server - mysql equivalent data types

I'm coming from a SQL Server background. What would the equivalent data types be for the following in MySQL: ... for very long text documents See Question&Answers more detail:os...

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

0 votes

596 views

1 answer

sql - Getting warning: Null value is eliminated by an aggregate or other SET operation

I have this schema create table t(id int, d date) insert into t (id, d) values (1, getdate()), (2, NULL) ... Why and what can I do about it? See Question&Answers more detail:os...

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

0 votes

451 views

1 answer

sql server - How to autoincrement a varchar

Can I make a primary key like 'c0001, c0002' and for supplier 's0001, s0002' in one table? See Question&Answers more detail:os...

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

0 votes

518 views

1 answer

sql server - How to schedule SSIS package to run as something other than SQL Agent Service Account

In SQL Server 2005, is it possible to schedule an SSIS package to run something other than the SQL Agent ... context. Is that possible? See Question&Answers more detail:os...

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

0 votes

467 views

1 answer

sql - pseudo_encrypt() function in plpgsql that takes bigint

I'm working on a system that generates random ids like in answer #2 here. My problem is, that the ... immutable; Can somebody check this? See Question&Answers more detail:os...

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

0 votes

412 views

1 answer

sql - Spark replacement for EXISTS and IN

I am trying to run a query that uses the EXIST clause: select <...> from A, B, C where A.FK_1 = B.PK and ... = C.PK and A.ID = exist_clause.ID See Question&Answers more detail:os...

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

0 votes

427 views

1 answer

sql - Create Computed Column using data from another table

I have a SQL Server 2008 R2 database. This database has two tables called Pictures and PictureUse. Picture table ... been clicked.any help ? See Question&Answers more detail:os...

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

0 votes

481 views

1 answer

sql server - FOR XML PATH(''): Escaping "special" characters

This code basically translates characters based on position in one string to the character at the same position ... row values together. See Question&Answers more detail:os...

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

0 votes

471 views

1 answer

sql - Why MySQL is giving error "Not allowed to return a result set from a function"?

I am trying to create a MySQL function using phpMyAdmin and getting this error. #1415 - Not allowed to ... suggestions? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

865 views

1 answer

sql - PostgreSQL ORDER BY issue - natural sort

I've got a Postgres ORDER BY issue with the following table: em_code name EM001 AAA EM999 BBB EM1000 CCC To ... Any idea how to select EM1000? See Question&Answers more detail:os...

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

0 votes

605 views

1 answer

sql - Is there a postgres CLOSEST operator?

I'm looking for something that, given a table like: | id | number | | 1 | .7 | | 2 | 1.25 ... t find any documentation suggesting that it does. See Question&Answers more detail:os...

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

0 votes

473 views

1 answer

sql server - Finding a Top Level Parent in SQL

I have got two tables as following Table Person Id Name 1 A 2 B 3 C 4 D 5 E Table RelationHierarchy ... SQL that can help me accomplish this See Question&Answers more detail:os...

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

0 votes

868 views

1 answer

sql - MySQL How to INSERT INTO [temp table] FROM [Stored Procedure]

This is very similar to question 653714, but for MySQL instead of SQL Server. Basically, I have a complicated ... TABLE tmp EXEC nested_sp(); See Question&Answers more detail:os...

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

0 votes

611 views

1 answer

sql - MySQL full text search with partial words

MySQL Full Text searching appears to be great and the best way to search in SQL. However, I seem to be stuck on ... , it may be less desirable." See Question&Answers more detail:os...

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

0 votes

650 views

1 answer

sql - Equivalent function for DATEADD() in Oracle

I have to get a date that is 6 months from the system date in Oracle. And I have to get it by ... SQL have an equivalent function in Oracle? See Question&Answers more detail:os...

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

0 votes

547 views

1 answer

sql - Using LIKE in an Oracle IN clause

I know I can write a query that will return all rows that contain any number of values in a given column, like so: ... '%val2%', 'val3%',....) See Question&Answers more detail:os...

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

0 votes

624 views

1 answer

sql - How do I edit a table in order to enable CASCADE DELETE?

I have a table representing users. When a user is deleted I get: DELETE statement conflicted with the REFERENCE ... ideas how to do this? See Question&Answers more detail:os...

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

0 votes

425 views

1 answer

sql - Can I use a MySQL database with an App Engine application

I know that App Engine has its own datastore. This is great for most cases and fairly easy to used. However, we ... that show how to do it? See Question&Answers more detail:os...

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

0 votes

418 views

1 answer

sql - How to write a constraint concerning a max number of rows in postgresql?

I think this is a pretty common problem. I've got a table user(id INT ...) and a table photo(id BIGINT, ... the best way of writing this? Thx! See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

sql - Get month from DATETIME in sqlite

I am trying to get extract the month from a DATETIME field in SQLite. month(dateField) does not work as well as ... '%m', dateStart). Any ideas? See Question&Answers more detail:os...

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

0 votes

442 views

1 answer

sql - Average of multiple columns

I have a table called Request and the data looks like: Req_ID R1 R2 R3 R4 R5 R12673 2 5 3 7 10 R34721 3 ... the average? Where am I doing wrong. See Question&Answers more detail:os...

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

0 votes

571 views

1 answer

sql - How to get rid of "Error 1329: No data - zero rows fetched, selected, or processed"

I have a stored procedure which does not need to return any values. It runs smoothly and without any problem ... my_cur_loop; CLOSE my_cur; END See Question&Answers more detail:os...

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

0 votes

421 views

1 answer

sql - PostgreSQL Where count condition

I have following query in PostgreSQL: SELECT COUNT(a.log_id) AS overall_count FROM "Log" as a, "License" as b ... for calls in a specific month. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags