Recent questions tagged SQL

0 votes

321 views

1 answer

sql - Finding the next available id in MySQL

I have to find the next available id (if there are 5 data in database, I have to get the next available insert ... max value it didn't update. See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql - Case statement in MySQL

I have a database table called 'tbl_transaction' with the following definition: id INT(11) Primary Key action_type ... accomplish this. Cheers! See Question&Answers more detail:os...

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

0 votes

276 views

1 answer

sql server - Can you call a webservice from TSQL code?

Is there a way to call out from a TSQL stored procedure or function to a webservice? See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql server - SQL Error with Order By in Subquery

I'm working with SQL Server 2005. My query is: SELECT ( SELECT COUNT(1) FROM Seanslar WHERE MONTH(tarihi) = 4 ... use ORDER BY in a sub query? See Question&Answers more detail:os...

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

0 votes

600 views

1 answer

sql server 2005 - Disadvantages of MARS (Multiple Active Result Sets)?

Does anyone know of any disadvantages of MARS (Multiple Active Result Sets)? Does anyone know of any reason why ... are more useful then MARS. See Question&Answers more detail:os...

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

0 votes

443 views

1 answer

sql - Drop all tables command

What is the command to drop all tables in SQLite? Similarly I'd like to drop all indexes. See Question&Answers more detail:os...

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

0 votes

282 views

1 answer

sql - How to renumber primary index

I have got a simple MySQL table and primary index (id) is not numbered one by one (1, 31, 35, 100 etc.). ... I just want to tidy up the table. See Question&Answers more detail:os...

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

0 votes

339 views

1 answer

sql - sqlplus statement from command line

Is it possible to do something like this? $ sqlplus -s user/pass "select 1 from dual" or $ echo " ... create a file just to satisfy sqlplus See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

sql - Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed

I am getting following error in my SQL server 2008 R2 database: Cannot use a CONTAINS or FREETEXT predicate on ... is not full-text indexed. See Question&Answers more detail:os...

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

0 votes

421 views

1 answer

sql - How to get other columns when using Spark DataFrame groupby?

when I use DataFrame groupby like this: df.groupBy(df("age")).agg(Map("id"->"count")) I will only get a ... I do when use groupby in Spark? See Question&Answers more detail:os...

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

0 votes

559 views

1 answer

sql - unresolved reference to object [INFORMATION_SCHEMA].[TABLES]

I've created a UDF that accesses the [INFORMATION_SCHEMA].[TABLES] view: CREATE FUNCTION [dbo].[CountTables] ( ... can I resolve this warning? See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql - How do I alter the position of a column in a PostgreSQL database table?

I've tried the following, but I was unsuccessful: ALTER TABLE person ALTER COLUMN dob POSITION 37; See Question&Answers more detail:os...

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

0 votes

266 views

1 answer

sql - Slow simple update query on PostgreSQL database with 3 million rows

I am trying a simple UPDATE table SET column1 = 0 on a table with ~3 million rows on Postegres 8.4 but ... UPDATE myTable SET generalFreq = 0; See Question&Answers more detail:os...

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

0 votes

402 views

1 answer

sql - Bulk/batch update/upsert in PostgreSQL

I'm writing a Django-ORM enchancement that attempts to cache models and postpone model saving until the end of ... run faster because of that. See Question&Answers more detail:os...

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

0 votes

253 views

1 answer

sql - Sequence vs identity

SQL Server 2012 introduced Sequence as a new feature, same as in Oracle and Postgres. Where sequences are preferred ... do we need sequences? See Question&Answers more detail:os...

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

0 votes

206 views

1 answer

sql server - Access is denied when attaching a database

I am using SQL Server 2008 developer edition. I was trying to attach the AdventureWorks2008 database. When I tried to ... be logged in as sa? See Question&Answers more detail:os...

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

0 votes

274 views

1 answer

sql - Normalization in plain English

I understand the concept of database normalization, but always have a hard time explaining it in plain English ... the interviewers looking for? See Question&Answers more detail:os...

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

0 votes

659 views

1 answer

sql - How create json format with group-concat mysql?

How create json format with group-concat mysql? (I use MySQL) Example1: table1: email | name | phone ------ ... :"Dan",phone:"8768768"} Thanks See Question&Answers more detail:os...

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

0 votes

368 views

1 answer

sql - EXISTS vs JOIN and use of EXISTS clause

Below is the code sample: CREATE TABLE #titles( title_id varchar(20), title varchar(80) NOT NULL, type char(12 ... and where exactly to use? See Question&Answers more detail:os...

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

0 votes

268 views

1 answer

sql - Is it possible to GROUP BY multiple columns using MySQL?

Is it possible to GROUP BY more than one column in a MySQL SELECT query? For example: GROUP BY fV.tier_id AND 'f.form_template_id' See Question&Answers more detail:os...

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

0 votes

248 views

1 answer

sql server - Optimized SQL for tree structures

How would you get tree-structured data from a database with the best performance? For example, say you ... perspectives are interesting too. See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql - What are projection and selection?

What is the difference between projection and selection? Is it: Projection --> for selecting the columns ... horizontal slicing respectively? See Question&Answers more detail:os...

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

0 votes

248 views

1 answer

sql - How to store a list in a db column

I would like to store an object FOO in a database. Lets say FOO contains three integers and a list of "Fruits". ... the fruit list in a column? See Question&Answers more detail:os...

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

0 votes

264 views

1 answer

sql - How do I delete a fixed number of rows with sorting in PostgreSQL?

I'm trying to port some old MySQL queries to PostgreSQL, but I'm having trouble with this one: DELETE FROM ... , the joys of legacy systems! See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql server - How to select date without time in SQL

When I select date in SQL it is returned as 2011-02-25 21:17:33.933. But I need only the Date part, that is 2011-02-25. How can I do this? See Question&Answers more detail:os...

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

0 votes

251 views

1 answer

sql - How to select multiple rows filled with constants?

Selecting constants without referring to a table is perfectly legal in an SQL statement: SELECT 1, 2, 3 The result ... 3 rows and 3 columns. See Question&Answers more detail:os...

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

0 votes

412 views

1 answer

sql - Drop all tables whose names begin with a certain string

How can I drop all tables whose names begin with a given string? I think this can be done with some ... SQL and the INFORMATION_SCHEMA tables. See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

sql - How to round an average to 2 decimal places in PostgreSQL?

I am using PostgreSQL via the Ruby gem 'sequel'. I'm trying to round to two decimal places. Here's my code ... know what I am doing wrong? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags