Recent questions tagged SQl

0 votes

448 views

1 answer

sql update - Is there any way to rollback after commit in MySQL?

I did a big mistake that I updated a table without 'where' clause in MySQL :'( It is auto-committed. Is there any way to rollback from it? See Question&Answers more detail:os...

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

0 votes

301 views

1 answer

sql - Anonymizing customer data for development or testing

I need to take production data with real customer info (names, address, phone numbers, etc) and move it into ... samplenames ORDER By NEWID()) See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql - How to treat MAX() of an empty table as 0 instead of NULL

I try to select max value from table SELECT MAX(cid) FROM itemconfiguration; However when table itemconfiguration is empty ... treat NULL as 0 ? See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql server 2008 - Select, Modify and insert into the same table

What's the easiest way to select a row, modify couple of columns and insert it to the same table? I'm trying ... a new row based on another. See Question&Answers more detail:os...

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

0 votes

263 views

1 answer

sql - UPDATE with CASE and IN - Oracle

I wrote a query that works like a charm in SQL Server. Unfortunately it needs to be run on an Oracle db. I ... is just dumped into the query. See Question&Answers more detail:os...

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

0 votes

437 views

1 answer

sql - Upgrading a varchar column to enum type in postgresql

We have a varchar column in a table, that we need to upgrade to enum type. All the values in the varchar ... to achieve this? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql server - hash a SQL row?

Is there a way to md5sum a row in a SQL table to check whether any column has been modified? I would like ... . EDIT: Just md5sum-ing each row See Question&Answers more detail:os...

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

0 votes

497 views

1 answer

sql server - Geometry column: STGeomFromText and SRID (what is an SRID?)

I'm playing with the new geography column in SQL Server 2008 and the STGeomFromText function. Here is my code (works ... me? What is the SRID? See Question&Answers more detail:os...

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

0 votes

450 views

1 answer

sql - Sum columns with null values in oracle

I want to add two numbers together but when one of those numbers is null then the result is null. Is there a way around ... 1 9 B 1 8 B 2 9 See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql - What is the MySQL equivalent of PostgreSQL's EXPLAIN ANALYZE

I'd like to get a detailed query plan in MySQL similar to EXPLAIN ANALYZE shows in PostgreSQL. Is there an equivalent? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - Each GROUP BY expression must contain at least one column that is not an outer reference

What am I doing wrong here? I am getting this error on: SELECT LEFT(SUBSTRING(batchinfo.datapath, PATINDEX('%[0 ... the group by and having. See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql server 2008 - How do I perform a case-sensitive search using LIKE?

I'm trying to find records that contain a string of 6 or more alpha-numeric characters in uppercase. ... perform this case-sensitive search? See Question&Answers more detail:os...

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

0 votes

401 views

1 answer

sql server - Drop Foreign Key without knowing the name of the constraint?

I have created one table using below command: create table Table1( Id int Not Null Foreign key references Table2(Id ... there any way? Pls help. See Question&Answers more detail:os...

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

0 votes

359 views

1 answer

sql - How do I catch a query exception in laravel to see if it fails?

All I'm trying to do is verify a query. 'SELECT * from table_that_does_not_exist' Without that erroring out, I' ... exist" or the generic error. See Question&Answers more detail:os...

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

0 votes

412 views

1 answer

sql - How can I get the raw query string from Laravel's query builder BEFORE executing the query?

I have a complex query created by a few conditions, and I would like to get the final SQL query from the builder ... to execute. Can I do that? See Question&Answers more detail:os...

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

0 votes

350 views

1 answer

sql - String to timestamp in MySQL

Is there any way to convert string to UNIX timestamp in MySQL? For example, I have the string 2011-12-21 02 ... to be in Unix timestamp format. See Question&Answers more detail:os...

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

0 votes

473 views

1 answer

sql - Update only Time in a mysql DateTime field

How can I update only the time in an already existing DateTime field in MySQL? I want the date to stay the same. See Question&Answers more detail:os...

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

0 votes

343 views

1 answer

sql - How to combine results of two queries into a single dataset

I have two queries : Queries Simplified excluding Joins Query 1 : select ProductName,NumberofProducts (in inventory) from ... want to see. ) See Question&Answers more detail:os...

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

0 votes

294 views

1 answer

sql - How to hint the index to use in a MySQL select query?

I have a MySQL query (running MySQL 5.0.88), which I'm trying to speed up. The underlying table has multiple ... 88, which I can't change.) See Question&Answers more detail:os...

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

0 votes

554 views

1 answer

sql server 2005 - UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'

I am having a problem with an update stored procedure. The error is: UPDATE failed because the following SET ... issue in the first place. See Question&Answers more detail:os...

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

0 votes

520 views

1 answer

sql server - How to retrieve records for last 30 minutes in MS SQL?

I want to retrieve records for last 30 minutes in a table. How to do that? Below is my query.. ... and DatePlayed > (CURRENT_TIMESTAMP-30) See Question&Answers more detail:os...

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

0 votes

352 views

1 answer

sql - Is the 'as' keyword required in Oracle to define an alias?

Is the 'AS' keyword required in Oracle to define an alias name for a column in a SELECT statement? I noticed ... column alias in the latter way. See Question&Answers more detail:os...

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

0 votes

290 views

1 answer

sql - SQLite Like % and _

I can't figure out what the underscore character does in an SQLite like statement. The wildcard character, %, is ... does the _ character do? See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql server - Get the time of a datetime using T-SQL?

How to get the time for a given datetime value? I have a datetime in database like this: 2010-09-06 17:07 ... a function for that or something? See Question&Answers more detail:os...

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

0 votes

257 views

1 answer

sql - VBA New Database Connection

How to change the code below to prevent what you see in the screenshot. I am running a macro with the following code Dim ... <<<<<----- End With See Question&Answers more detail:os...

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

0 votes

247 views

1 answer

sql - PostgreSQL window function: partition by comparison

I'm trying to find the way of doing a comparison with the current row in the PARTITION BY clause in a WINDOW ... e2.date ASC, e2.id ASC See Question&Answers more detail:os...

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

0 votes

444 views

1 answer

sql - Selecting contiguous block of records in mysql

I have a table in MySql 5 of phone numbers. The simple structure is Accounts id varchar(32) NOT NULL ... 27100070016 | NULL 27100070043 | NULL See Question&Answers more detail:os...

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

0 votes

422 views

1 answer

sql - Running Sums for Multiple Categories in MySQL

I have a table of the form Category Time Qty A 1 20 B 2 3 A 3 43 A 4 20 B 5 25 I need a ... GROUP BY or a similar construct to achieve this. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags