Recent questions tagged SQl

0 votes

237 views

1 answer

sql - How to find "related items" in PHP

we often see 'related items'. For instance in blogs we have related posts, in books we have related books, etc. ... ' tag. Anyone has any idea? See Question&Answers more detail:os...

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

0 votes

242 views

1 answer

sql - Compare Columns Where One is Similar to Part of Another

I'm trying to write a Select statement where I can see if one column is like part of another. tblNames ID ... %' not like Fullname Any ideas? See Question&Answers more detail:os...

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

0 votes

234 views

1 answer

sql execution plan - Performance of SQL "EXISTS" usage variants

Is there any difference in the performance of the following three SQL statements? SELECT * FROM tableA WHERE ... all statements behave equal? See Question&Answers more detail:os...

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

0 votes

388 views

1 answer

sql - Android SQLite Query - Getting latest 10 records

I have a database saved in my Android application and want to retrieve the last 10 messages inserted into the DB. When I ... as - 21,22,23...30 See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - SQLite3 UNIQUE constraint failed error

I am trying to create a database which allows users to create 'to do' lists and fill them with items to ... Any help would be appreciated! See Question&Answers more detail:os...

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

0 votes

280 views

1 answer

sql - How to get the value of autoincrement of last row at the insert

I have googled this problem one week and no thing useful I think am not using the correct word I am ... begin end transaction and select max See Question&Answers more detail:os...

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

0 votes

239 views

1 answer

sql - How to use update trigger to update another table?

I am new to triggers and want to create a trigger on an update of a column and update another table with that ... table2.ID = table1.ID END See Question&Answers more detail:os...

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

0 votes

266 views

1 answer

sql - MySQL Multiple Where Clause

I have a table like this: id image_id style_id style_value ---------------------------------- ... with Google but couldn't fine any solution. See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

sql - insert multiple rows into DB2 database

I want to insert multiple rows into a DB2 table. I have a query that looks like this insert into tableName ( ... useful to insert my test data. See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql - Laravel Eloquent Select CASE?

Is there anyone with experience in PHP & Laravel Eloquent who can help me resolve this statement? I'm trying to inject a ... ', 'asc') ->get(); See Question&Answers more detail:os...

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

0 votes

234 views

1 answer

sql server - SQL - How do I get only the numbers after the decimal?

How do I get only the numbers after the decimal? Example: 2.938 = 938 See Question&Answers more detail:os...

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

0 votes

365 views

1 answer

sql - How to hide result set decoration in Psql output

How do you hide the column names and row count in the output from psql? I'm running a SQL query ... but nothing for hiding extraneous output. See Question&Answers more detail:os...

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

0 votes

230 views

1 answer

sql server query running slow from java

I have a java program that runs a bunch of queries against an sql server database. The first of these, which ... . thanks for all the help. See Question&Answers more detail:os...

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

0 votes

305 views

1 answer

sql - mysql unique number generation

I want to generate a unique random integer (from 10000 to 99999) identity just by clean mySQL; any ideas? I ... solution in a mySQL query. See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql server - SQL Datediff - find datediff between rows

I would like to query a database using sql to show the difference in time between id 1,2,3 and so on. basically ... 02/03/2011 10:34 14 Thanks! See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql - What is good C# coding style for catching SQLException and retrying

I have a method that calls a SQLServer function to perform a free text search against a table. That function will ... ; } } } return results; See Question&Answers more detail:os...

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

0 votes

241 views

1 answer

sql - why can't I access my CTE after I used it once?

My stored procedure looks like: WITH MYCTE(....) AS ( ... ) UPDATE ... (using my CTE) DELETE ( using my CTE ... 't exist Can I only use it once? See Question&Answers more detail:os...

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

0 votes

214 views

1 answer

sql server - Using GROUP BY with FIRST_VALUE and LAST_VALUE

I'm working with some data that is currently stored in 1 minute intervals that looks like this: CREATE TABLE ... or the GROUP BY clause. See Question&Answers more detail:os...

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

0 votes

397 views

1 answer

sql server - Rollback the inner transaction of nested transaction

suppose I have following sql statement in sql server 2008: BEGIN TRANSACTION SqlStatement1 EXEC sp1 ... SqlStatement3 actually executed? See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql server - Bulk Record Update with SQL

I have two tables in a SQL Server 2008 environment with the following structure Table1 - ID - DescriptionID - Description ... me how to do this? See Question&Answers more detail:os...

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

0 votes

231 views

1 answer

sql server - T-SQL: How do I create a unique key that is case sensitive?

How do I create a unique constraint on a varchar field that is case sensitive (SQL Server ... syntax. COLLATE SQL_Latin1_General_CP1_CS_AS See Question&Answers more detail:os...

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

0 votes

223 views

1 answer

sql - how to use LIKE with column name

Normally LIKE statement is used to check the pattern like data. example: select * from table1 where name like ' ... column data in like query? See Question&Answers more detail:os...

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

0 votes

300 views

1 answer

sql - How to insert into a table with just one IDENTITY column?

(Came up with this question in the course of trying to answer this other one) Consider the following MS-SQL table ... SQL 2005 or SQL 2008 here. See Question&Answers more detail:os...

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

0 votes

481 views

1 answer

sql - Applying the MIN aggregate function to a BIT field

I want to write the following query: SELECT ..., MIN(SomeBitField), ... FROM ... WHERE ... GROUP BY ... The ... of the bit values in a field.) See Question&Answers more detail:os...

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

0 votes

213 views

1 answer

sql - Add a column to a table with a default value equal to the value of an existing column

How to add a column to a SQL Server table with a default value that is equal to value of an existing ... . Column names are not permitted. See Question&Answers more detail:os...

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

0 votes

581 views

1 answer

sql - how to clear/flush mysql innodb buffer pool?

I'm perf tuning a large query, and want to run it from the same baseline before and after, for comparison. ... like to avoid this if possible See Question&Answers more detail:os...

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

0 votes

221 views

1 answer

sql - connect by clause in regex_substr

I cant get the understanding of this statement - not eveN after googling around pv_no_list :='23,34,45,56'; SELECT ... , 1, LEVEL) IS NOT NULL See Question&Answers more detail:os...

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

0 votes

375 views

1 answer

sql - Execute table-valued function on multiple rows?

Given a table-valued function such as dbo.Split() from "T-SQL: Opposite to string concatenation - how to split ... myColumn is a varchar(max). See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags