Software Development - Posts tagged mysql

75%

+4 −0

Q&A Is an ORDER BY required when looping through MySQL records with LIMIT?

1 answer · posted 1y ago by Charlie Brumbaugh‭ · last activity 29d ago by Canina‭

Question mysql

50%

+0 −0

Q&A How to to make a store tree view cart

0 answers · posted 1mo ago by Fyoni‭ · edited 1mo ago by Alexei‭

Question php mysql pdo treeview

71%

+3 −0

Q&A How to create a MySQL generated column that uses a join in a concat?

1 answer · posted 6mo ago by Charlie Brumbaugh‭ · last activity 6mo ago by Alexei‭

Question mysql generated-columns

66%

+2 −0

Q&A How to start mysql in Manjaro from terminal?

1 answer · posted 6mo ago by deleted user · last activity 6mo ago by deleted user

Question mysql linux manjaro startup

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 · posted 7mo ago by JohnDoea‭ · edited 7mo ago by JohnDoea‭

Question mysql database

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 · posted 10mo ago by Charlie Brumbaugh‭ · last activity 10mo ago by Alexei‭

Question mysql

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 · posted over 1 year ago by Charlie Brumbaugh‭ · edited 12mo 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 · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y ago by Alexei‭

Question mysql stored-procedures

86%

+11 −0

Q&A Are there best practices for sticking conditions in WHERE clauses vs the JOIN statement?

2 answers · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · edited 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y ago by Alexei‭

Question mysql referential

50%

+0 −0

Q&A How to drop all stored procedures from a MySQL database

1 answer · posted 1y ago by Charlie Brumbaugh‭ · edited 1y ago by Peter Mortensen‭

Question mysql stored-procedures

71%

+3 −0

Q&A How do I track down intermittent locks in a MySQL database?

0 answers · posted 1y ago by Charlie Brumbaugh‭ · edited 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · edited 1y ago by Alexei‭

Question mysql database-trigger

71%

+3 −0

Q&A How to calculate how much data is stored in a MySQL column?

1 answer · posted over 1 year ago by Charlie Brumbaugh‭ · last activity 1y ago by Alexei‭

Question mysql

75%

+4 −0

Q&A Would a MySQL database run more efficiently with smaller varchar lengths?

3 answers · posted over 1 year ago by Charlie Brumbaugh‭ · last activity 1y ago by manassehkatz‭

Question mysql performance varchar

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 · posted over 1 year ago by Charlie Brumbaugh‭ · edited 1y ago by Alexei‭

Question mysql sql notin query-performance

75%

+4 −0

Q&A Is there an equivalent way of returning early in a MySQL stored procedure?

1 answer · posted 1y ago by Charlie Brumbaugh‭ · edited 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · edited 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y 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 · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y ago by r~~‭

Question mysql

33%

+0 −2

Q&A How do I find all the tables in a database that don't have a specific column?

1 answer · posted 1y ago by Charlie Brumbaugh‭ · last activity 1y ago by Charlie Brumbaugh‭

Question mysql

50%

+1 −1

Q&A How to temporarily disable a MySQL user?

2 answers · posted over 1 year ago by Charlie Brumbaugh‭ · edited over 1 year 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 · posted over 1 year ago by Charlie Brumbaugh‭ · last activity over 1 year ago by manassehkatz‭

Question mysql database-index table-column

Communities

Posts tagged mysql