Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Dashboard
Notifications
Mark all as read
Users Search
Help Sign In Sign Up
Q&A Code Reviews Meta
Q&A
Posts Tags Edits
Ask Question

Posts tagged sql

8 child tags

Use for questions about one or multiple Structured Query Language (SQL) flavours.

In order to get the most helpful answer your question should include the following:

- a specific SQL flavor tag (e.g. for MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2)
- table definitions
- sample data if needed
- expected result when query results are not what you expect

For general questions that are not targeting a specific SQL flavor, questions and answers should use ISO/IEC standard SQL.

This tag doesn't have a detailed wiki yet.

40 posts
Tag Only Tag + Children
66%
+2 −0
Q&A How to create a MySQL generated column that uses a join in a concat?

1 answer  ·  last activity 3 days ago by Alexei‭

Question mysql generated-columns
66%
+2 −0
Q&A How to start mysql in Manjaro from terminal?

1 answer  ·  last activity 14 days ago by Istiak‭

Question mysql linux manjaro start
60%
+1 −0
Q&A Is there any breaking change in regard to TrustServerCertificate property of System.Data.SqlClient for .NET 5?

1 answer  ·  last activity 15 days ago by Alexei‭

Question sql encryption .net-5 system.data.sqlclient backwards-compatibility
50%
+0 −0
Q&A When is information schema not needed and when is it indeed when migrating from one website hosting provider to another?

0 answers  ·  last activity about 1 month ago by JohnDoea‭

Question mysql database
66%
+2 −0
Q&A How to easily support time frame grouping in queries?

0 answers  ·  last activity about 1 month ago by Alexei‭

Question tsql sql-server grouping
75%
+4 −0
Q&A How to break infinite loop in CTE

3 answers  ·  last activity about 2 months ago by Peter Taylor‭

Question sql sql-server common-table-expression
81%
+7 −0
Q&A SQL timestamp for daylight saving day when clock goes 1 hour back.

1 answer  ·  last activity 3 months ago by hkotsubo‭

Question sql timestamps postgresql datetime timezone
66%
+2 −0
Q&A Is it possible to disable the "mysql: [Warning] Using a password on the command line interface can be insecure" warning?

1 answer  ·  last activity 4 months ago by Alexei‭

Question mysql
66%
+2 −0
Q&A What are the factors to consider when deciding to split ORM queries or use eager loading?

0 answers  ·  last activity 5 months ago by Alexei‭

Question entity-framework-core query-performance performance eager-loading
75%
+10 −2
Q&A What are the pros and cons of a composite primary key versus a unique constraint?

2 answers  ·  last activity 6 months ago by Alexei‭

Question sql primary-key unique-constraint
77%
+5 −0
Q&A Is it unsecure to use a password on the command line to run a MySQL script on Windows?

2 answers  ·  last activity 6 months ago by ghost-in-the-zsh‭

Question mysql windows
66%
+2 −0
Q&A How much memory is allocated for a MySQL VARCHAR variable in a stored procedure?

2 answers  ·  last activity 7 months ago by Alexei‭

Question mysql stored-procedures
85%
+10 −0
Q&A Are there best practices for sticking conditions in WHERE clauses vs the JOIN statement?

2 answers  ·  last activity 7 months ago by klutt‭

Question mysql join
75%
+4 −0
Q&A Is there a way to automatically fix MySQL tables where the auto_increment has fallen behind the correct value?

1 answer  ·  last activity 7 months ago by Alexei‭

Question mysql auto-increment
71%
+3 −0
Q&A In MySQL is there a limit to the number of keys in a IN() clause?

2 answers  ·  last activity 7 months ago by Alexei‭

Question mysql
71%
+3 −0
Q&A Iterating through a MySQL table with a LIMIT clause and PHP gets progressively slower

1 answer  ·  last activity 7 months ago by ArtOfCode‭

Question php mysql
71%
+3 −0
Q&A Why would an unique index get moved to the primary key after the underlying column is dropped?

1 answer  ·  last activity 7 months ago by Alexei‭

Question mysql database-index
77%
+5 −0
Q&A Is it possible in MySQL to require each row in a table have at least one foreign key record in a join table?

2 answers  ·  last activity 7 months ago by Alexei‭

Question mysql referential
50%
+0 −0
Q&A How to drop all stored procedures from a MySQL database

1 answer  ·  last activity 7 months ago by Peter Mortensen‭

Question mysql stored-procedures
71%
+3 −0
Q&A SID to login for access via a group

0 answers  ·  last activity 7 months ago by Alexei‭

Question sql-server login sql-server-2019
60%
+1 −0
Q&A How can I can I reduce the size of a SQL Server database after being restored and massive embedded files stripped?

1 answer  ·  last activity 8 months ago by Alexei‭

Question sql-server sql-server-2017
66%
+2 −0
Q&A How do I track down intermittent locks in a MySQL database?

0 answers  ·  last activity 8 months ago by Alexei‭

Question mysql database-locking
66%
+2 −0
Q&A In MySQL, is it possible to disable triggers for only certain queries or users?

1 answer  ·  last activity 8 months ago by Alexei‭

Question mysql database-trigger
80%
+6 −0
Q&A How are integers interpreted in contexts that expect a date?

1 answer  ·  last activity 8 months ago by Alexei‭

Question sql tsql sql-server
66%
+2 −0
Q&A Is an ORDER BY required when looping through MySQL records with LIMIT?

1 answer  ·  last activity 8 months ago by Canina‭

Question mysql
71%
+3 −0
Q&A How to calculate how much data is stored in a MySQL column?

1 answer  ·  last activity 8 months ago by Alexei‭

Question mysql
75%
+4 −0
Q&A Would a MySQL database run more efficiently with smaller varchar lengths?

3 answers  ·  last activity 8 months ago by manassehkatz‭

Question mysql performance varchar
71%
+3 −0
Q&A Error: 18456, Severity: 14, State: 5; SSMS > Network sever from PC

1 answer  ·  last activity 8 months ago by Alexei‭

Question sql sql-server sql-server-2014
77%
+5 −0
Q&A Is there a naming convention for table aliases?

1 answer  ·  last activity 8 months ago by Alexei‭

Question sql naming-conventions
75%
+4 −0
Q&A How can I generate documentation from comments in SQL DDL?

0 answers  ·  last activity 8 months ago by Monica Cellio‭

Question sql documentation tools
81%
+11 −1
Q&A Why would excluding records by creating a temporary table of their primary keys be faster than simply excluding by value?

2 answers  ·  last activity 8 months ago by Alexei‭

Question mysql sql notin query-performance
60%
+1 −0
Q&A What is the rationale of having Cascade as a DeleteAction in EntityFramework.Core?

1 answer  ·  last activity 8 months ago by Alexei‭

Question entity-framework-core sql-delete referential
75%
+4 −0
Q&A Is there an equivalent way of returning early in a MySQL stored procedure?

1 answer  ·  last activity 9 months ago by Moshi‭

Question mysql stored-procedures
60%
+1 −0
Q&A What is happening under the hood to the selected data in a MySQL cursor?

0 answers  ·  last activity 9 months ago by Charlie Brumbaugh‭

Question mysql
83%
+8 −0
Q&A Is there a way to estimate the execution time of a statement in MySQL?

1 answer  ·  last activity 9 months ago by meriton‭

Question mysql
60%
+1 −0
Q&A In a stored procedure, is it possible to get the total number or rows updated by different statements?

2 answers  ·  last activity 9 months ago by Alexei‭

Question mysql stored-procedures rows-affected
71%
+3 −0
Q&A How long in days is a MONTH in MySQL?

1 answer  ·  last activity 9 months ago by r~~‭

Question mysql
40%
+0 −1
Q&A How do I find all the tables in a database that don't have a specific column?

1 answer  ·  last activity 9 months ago by Charlie Brumbaugh‭

Question mysql
50%
+1 −1
Q&A How to temporarily disable a MySQL user?

2 answers  ·  last activity 10 months ago by Charlie Brumbaugh‭

Question mysql
71%
+3 −0
Q&A Can renaming a MySQL column be sped up by dropping indexes or foreign keys?

2 answers  ·  last activity 10 months ago by manassehkatz‭

Question mysql database-index table-column
Tag RSS feed
Featured
Newsletter #7 (May 2021)
Taking our design to the next level: feedback wanted
Hot Posts
Q&A — Validate All Object Properties with JSON Schema
Meta — Drupal tag is not in lowercase
Code Reviews — Counting Sundays without Python date module
Code Reviews — Balanced parentheses problem in Python
Q&A — Difference between puts and print for Array

This community is part of the Codidact network. We have other communities too — take a look!

You can also join us in chat!

Want to advertise this community? Use our templates!