Recent questions tagged SQL

0 votes

284 views

1 answer

sql - Retrieve client ip address in mysql

I'm trying to get with a simple SQL statement the IP address of the client. I do not want to use PHP or ... plain IP? Thanks a lot in advance. See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql server - Database design: one huge table or separate tables?

Currently I am designing a database for use in our company. We are using SQL Server 2008. The database ... partitioning in Standard Edition. See Question&Answers more detail:os...

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

0 votes

283 views

1 answer

sql - Join statement order of operation

Given the following 3 way join select t1.* from t1 left join t2 on t1.fk = t2.pk join t3 on t2.fk = t3 ... the former failed. How does it work? See Question&Answers more detail:os...

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

0 votes

360 views

1 answer

sql server - Get all parents for a child

I want to retrieve the parentid of an id, if that parentid has a parent again retrieve it, and so on. ... simple question(though not to me) See Question&Answers more detail:os...

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

0 votes

251 views

1 answer

sql - Why can't I perform an aggregate function on an expression containing an aggregate but I can do so by creating a new select statement around it?

Why is it that in SQL Server I can't do this: select sum(count(id)) as 'count' from table But I can ... the first block of code isn't allowed? See Question&Answers more detail:os...

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

0 votes

367 views

1 answer

sql - Oracle row count of table by count(*) vs NUM_ROWS from DBA_TABLES

Looks like count(*) is slower than NUM_ROWS. Can experts in this area throw some light on this. See Question&Answers more detail:os...

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

0 votes

458 views

1 answer

sql - How to create sequence if not exists

I tried to use code from Check if sequence exists in Postgres (plpgsql). To create sequence if it does not exists. ... ('myseq')::int as nr; See Question&Answers more detail:os...

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

0 votes

452 views

1 answer

sql - How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, DATE_CREA, ... How can I solve it? See Question&Answers more detail:os...

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

0 votes

389 views

1 answer

sql - how to find out number of days in month in mysql

I have several dates in mysql tables, using those dates I need to find out the number of days in the month. ... date days_in_month 2003-2-3 28 See Question&Answers more detail:os...

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

0 votes

319 views

1 answer

sql server 2008 - How to select last one week data from today's date

How to select week data (more precisely, last 7 days data) from the current date in the fastest way as I ... a table having millions of rows ? See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - How to delete a range of records at once on MySQL?

I have rows over 60000 in my table. How can I delete rows from 40000 to 50000 at once? See Question&Answers more detail:os...

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

0 votes

342 views

1 answer

sql - Difference between DECIMAL and NUMERIC

What's the difference between the SQL datatype NUMERIC and DECIMAL ? If databases treat these differently, I' ... drivers interpret these types? See Question&Answers more detail:os...

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

0 votes

268 views

1 answer

sql - Three table join with joins other than INNER JOIN

I am learning SQL and am trying to learn JOINs this week. I have gotten to the level where I can do ... explore the space as much as possible See Question&Answers more detail:os...

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

0 votes

492 views

1 answer

sql - mysql recursive(tree) parent child category

I am new in mysql. This is my table: category table: id | name | prent ----------------------- ... in form of active record in a PHP framework. See Question&Answers more detail:os...

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

0 votes

439 views

1 answer

sql - Are Dynamic Prepared Statements Bad? (with php + mysqli)

I like the flexibility of Dynamic SQL and I like the security + improved performance of Prepared Statements. So what I ... need to be aware of? See Question&Answers more detail:os...

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

0 votes

252 views

1 answer

sql - How can I delete duplicate rows in a table

I have a table with say 3 columns. There's no primary key so there can be duplicate rows. I need to just keep ... how to do this is Sql Server? See Question&Answers more detail:os...

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

0 votes

292 views

1 answer

sql - difference before and after trigger in oracle

Can somebody explain difference between "before" and "after" trigger in oracle 10g with an example ? See Question&Answers more detail:os...

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

0 votes

440 views

1 answer

sql server - Group All Related Records in Many to Many Relationship, SQL graph connected components

Hopefully I'm missing a simple solution to this. I have two tables. One contains a list of companies. The ... parents/children. SQL Server 2012 See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql server - SQL UPDATE statement to switch two values in two rows

I'm using SQL Server to swap two values in two rows. Let me show: [ord] [name] 1 John 4 Jack 7 Pete ... to write an SQL UPDATE statement for it. See Question&Answers more detail:os...

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

0 votes

281 views

1 answer

sql - "Merge" style operation with literal values?

I have a table containing a student-grade relationship: Student Grade StartDate EndDate 1 1 09/01/2009 NULL 2 2 ... be afraid to point it out. See Question&Answers more detail:os...

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

0 votes

401 views

1 answer

sql - Strange MySQL AVG() anomaly NULL values

What I'am doing : create table sample (id INT(10) PRIMARY KEY AUTO_INCREMENT,name varchar(255),marks INT(10)); ... allowed to be NULL. Thank you See Question&Answers more detail:os...

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

0 votes

261 views

1 answer

sql server - Add row number to this T-SQL query

How can I add ROW numbers to this query result? SELECT DISTINCT VehicleSpecs.SubmittedById, COUNT(VehicleSpecs. ... ORDER BY NumCars DESC See Question&Answers more detail:os...

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

0 votes

262 views

1 answer

sql - Oracle select for update behaviour

The problem we try to solve looks like this. We have a table full of rows which represent cards. The purpose ... would be the correct solution? See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql - Can I use COUNT() and DISTINCT together?

I would like to count the number of rows from a mysql table and not to include duplicate entries, Could I use distinct with count()? See Question&Answers more detail:os...

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

0 votes

409 views

1 answer

sql - Limit results from joined table to one row

Here is a simplified table structure: TABLE products ( product_id INT (primary key, auto_increment), category_id INT ... BY p.product_title ASC See Question&Answers more detail:os...

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

0 votes

461 views

1 answer

sql - How do I create a conditional WHERE clause?

I need to have a conditional where clause that operates as so: Select * From Table If (@booleanResult) Begin ... Any help would be appreciated. See Question&Answers more detail:os...

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

0 votes

313 views

1 answer

sql - MySQL - SELECT AS in WHERE

For some reason, this doesn't work: select substring(rating, instr(rating,',') +1, +2) as val from users where ... clause' How do I do it then? See Question&Answers more detail:os...

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

0 votes

722 views

1 answer

sql - OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries

I want to import data from Excel to SQL Server using queries, not by using a wizard. I tried this query: ... showing me the same error... See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags