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
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.

34 posts
Tag Only Tag + Children
81%
+7 −0
Q&A SQL timestamp for daylight saving day when clock goes 1 hour back.

1 answer  ·  last activity 12 days 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 about 2 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 2 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 4 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 4 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 7 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 7 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 7 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 7 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 7 months ago by Charlie Brumbaugh‭

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

2 answers  ·  last activity 7 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 8 months ago by manassehkatz‭

Question mysql database-index table-column
Tag RSS feed
Hot Posts
Meta — Codidactyl game and code - creation process and obfuscation
Meta — Why do I, a logged in user, have to solve a captcha to post?
Q&A — How to properly deal with impersonation in a Web application? (security vs. usefulness for tech support)
Q&A — Backendly redirecting a user from a contact form webpage to a success webpage
Q&A — yyyy/mm/dd instead expected dd/mm/yyyy format in PHP-created-HTML output

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!