Software Development - Posts tagged mysql

25%

+0 −4

Q&A PHP code not connecting to mysql. [closed]

0 answers · posted 12d ago by cuzzo‭ · closed 9d ago by Alexei‭

Question php mysql mysqli

71%

+3 −0

Q&A Conditions which always matches returns no result with CTE

1 answer · posted 7mo ago by artaxerxe‭ · edited 7mo ago by Alexei‭

Question mysql common-table-expression

77%

+5 −0

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

1 answer · posted almost 2 years ago by Charlie Brumbaugh‭ · edited 8mo ago by Alexei‭

Question mysql sql-order-by sql-limit

50%

+0 −0

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

0 answers · posted 11mo ago by Fyoni‭ · edited 11mo 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 over 1 year ago by Charlie Brumbaugh‭ · last activity over 1 year ago by Alexei‭

Question mysql generated-columns

66%

+2 −0

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

1 answer · posted over 1 year ago by deleted user · last activity over 1 year 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 over 1 year ago by deleted user · edited over 1 year ago by deleted user

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 over 1 year ago by Charlie Brumbaugh‭ · last activity over 1 year 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 2y ago by Charlie Brumbaugh‭ · edited almost 2 years 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 almost 2 years ago by Charlie Brumbaugh‭ · last activity almost 2 years 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 almost 2 years ago by Charlie Brumbaugh‭ · last activity almost 2 years 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 almost 2 years ago by Charlie Brumbaugh‭ · last activity almost 2 years 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 almost 2 years ago by Charlie Brumbaugh‭ · last activity almost 2 years 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 almost 2 years ago by Charlie Brumbaugh‭ · last activity almost 2 years 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 almost 2 years ago by Charlie Brumbaugh‭ · edited almost 2 years 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 almost 2 years ago by Charlie Brumbaugh‭ · last activity almost 2 years ago by Alexei‭

Question mysql referential

50%

+0 −0

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

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

Question mysql

75%

+4 −0

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

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

Question mysql

50%

+1 −1

Q&A How to temporarily disable a MySQL user?

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

Question mysql database-index table-column

Communities

Posts tagged mysql