Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Posts by Charlie Brumbaugh
I need to rename one column in 170 tables in a MySQL database and its going really slow. The columns all have an index plus a foreign key on them, would dropping the index/temporarily removing the...
I am considering either removing some columns or changing the datatypes if I could significantly reduce the amount of storage that is currently used by those columns. Some of the columns are ints a...
Currently, we have a CRUD plus reporting application that talks to one MySQL database. Intermittently users will report locks when searching, currently, I can only get the approximate time of when ...
If one finds where the past number of months equals the past number of days like this, select distinct DATE_SUB(now(), INTERVAL 92 DAY),DATE_SUB(now(), INTERVAL 3 MONTH) The numbers that are curre...
For my purposes, it is secure enough to use passwords to execute MySQL commands on the command line, what I would like to do is disable the warning that says, mysql: [Warning] Using a password on ...
On this question https://software.codidact.com/questions/279097 there are two code blocks, but the color of the text is different. I directly copied and pasted the code so I don't see why some o...
In a stored procedure let's say I have a VARCHAR variable, DECLARE example_variable VARCHAR(100); how much memory is allocated to it and is that independent of the length of the data in the var...
Almost every table in my DB has triggers that fire on INSERT, UPDATE, DELETE and write the changes to a separate read only DB. This makes it possible to track changes and undo things well after the...
On a Linux server, if you leave the .git folder unprotected in the public_html folder, its possible that someone could download the folder and then gain access to your files. There are two ways I h...
The select for finding tables without a specific column name is, SELECT DISTINCT table_name FROM information_schema.tables WHERE table_schema = 'DATABASE_NAME' AND table_name NOT IN( SELECT DI...
I have a number of MySQL stored procedures that use a cursor to go through a select and then pass the results to other stored procedures one row at a time. This can take a while to run, what is hap...
I have a bunch of stored procedures that look like something this CREATE PROCEDURE example() BEGIN UPDATE STATEMENT A; UPDATE STATEMENT B; UPDATE STATEMENT C; END// When I run them thr...
The easy way is to run this query. SELECT concat('DROP PROCEDURE IF EXISTS example_database.',routine_name ,';') FROM INFORMATION_SCHEMA.Routines WHERE ROUTINE_SCHEMA = 'example_database'; F...
The easiest way to temporarily disable a MySQL user is to the change the value of the Host column in the mysql.user table to an invalid host. UPDATE mysql.user SET HOST = 'blocked' WHERE #your cond...
I have a couple of 3d example projects in gcode for my printer but the printer bed has a couple of bumps in the center (where things are printed by default) and in order to print the objects I woul...
I need to drop all of the stored procedures from my MySQL database before I recreate them. How can I do so?
Sometimes I will need to temporarily lock out other MySQL users when I am making large structure changes and want to make sure that nobody else is inputting or changing the data. The other use case...
I need to add one column with the same name to all of the tables in my database, how can I find which tables don't currently have a column with that name?
- ← Previous
- 1
- 2
- Next →
