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.
Activity for Charlie Brumbaughâ€
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Edit | Post #278767 | Initial revision | — | over 3 years ago |
| Question | — |
Is an ORDER BY required when looping through MySQL records with LIMIT? Let's say I have a table with 10,000 rows and instead of selecting all of the rows at once I select 1,000 at a time like ``` LIMIT 0,1000 LIMIT 1000,1000 ``` etc. Without an ORDER BY statement the order of results in MySQL is not guaranteed, could I possibly miss records if I do not specify... (more) |
— | over 3 years ago |
| Edit | Post #278737 | Initial revision | — | over 3 years ago |
| Question | — |
What would the pros and cons of storing the compiled CSS output of SASS in version control? If one is using SASS to build a websites CSS and using version control one can either, - Keep both the SASS and the resulting CSS files in version control. - Only storing the SASS files in version control. What would the pros and cons of each method be? (more) |
— | over 3 years ago |
| Comment | Post #278292 |
@Alexei I don't think its the reports, but rather inserts crossing paths with the selects. The reports used to cause locks, but that was fixed by breaking the queries into chunks and then doing the calculations outside of the DB. (more) |
— | over 3 years ago |
| Edit | Post #278292 | Initial revision | — | over 3 years ago |
| Question | — |
How do I track down intermittent locks in a MySQL database? 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 that happens (accurate to the minute). The stored procedures on the other hand are logged to the millise... (more) |
— | over 3 years ago |
| Edit | Post #278281 | Initial revision | — | over 3 years ago |
| Question | — |
Is it possible to rebuild a STL file from gcode? 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 would need to move them off-center slightly. Would it be possible to turn the gcode back into a stl that ... (more) |
— | over 3 years ago |
| Edit | Post #278271 | Initial revision | — | over 3 years ago |
| Question | — |
Is there an equivalent way of returning early in a MySQL stored procedure? In programming instead of arrowcode where one has many layers of indented if statements, you can return a result as soon as possible. So instead of, ``` if if end if end if ``` It looks like ``` if return end if if return end if ``` A MySQL stored procedure does not retu... (more) |
— | over 3 years ago |
| Comment | Post #278211 |
We could create a category for self answers, it annoying when you self answer and then get comments on the question remarking how you should have done more research (more) |
— | over 3 years ago |
| Edit | Post #278209 |
Post edited: |
— | over 3 years ago |
| Edit | Post #278209 | Initial revision | — | over 3 years ago |
| Question | — |
What is happening under the hood to the selected data in a MySQL cursor? 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 happening under the hood while the cursor is looping through? Is the select discarded and the results ke... (more) |
— | over 3 years ago |
| Comment | Post #278207 |
The problem with doing it in a development environment first is that it doubles the time (more) |
— | over 3 years ago |
| Edit | Post #278208 | Initial revision | — | over 3 years ago |
| Question | — |
In MySQL, is it possible to disable triggers for only certain queries or users? 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 fact, but also makes operations slower. For changes that don't need an audit trail, would it be poss... (more) |
— | over 3 years ago |
| Edit | Post #278185 | Initial revision | — | over 3 years ago |
| Question | — |
Is there a way to estimate the execution time of a statement in MySQL? From time to time I will have large structural changes to make on my MySQL DB, things like adding columns, changing datatypes, adding indexes etc. These types of changes result in downtime and what I would like to be able to do is produce reasonable estimates of how long the changes will take before ... (more) |
— | over 3 years ago |
| Edit | Post #278068 | Initial revision | — | over 3 years ago |
| Question | — |
How long in days is a MONTH in MySQL? If one finds where the past number of months equals the past number of days like this, ``` select distinct DATESUB(now(), INTERVAL 92 DAY),DATESUB(now(), INTERVAL 3 MONTH) ``` The numbers that are currently returned are, - 1 month = 31 days - 2 month = 62 days - 3 month = 92 days - 4 mont... (more) |
— | over 3 years ago |
| Edit | Post #278035 |
Post edited: |
— | over 3 years ago |
| Edit | Post #278035 | Initial revision | — | over 3 years ago |
| Answer | — |
A: How do I find all the tables in a database that don't have a specific column? The select for finding tables without a specific column name is, ``` SELECT DISTINCT tablename FROM informationschema.tables WHERE tableschema = 'DATABASENAME' AND tablename NOT IN( SELECT DISTINCT TABLENAME FROM INFORMATIONSCHEMA.COLUMNS WHERE COLUMNNAME ='COLUMNNAME' AN... (more) |
— | over 3 years ago |
| Edit | Post #278034 | Initial revision | — | over 3 years ago |
| Question | — |
How do I find all the tables in a database that don't have a specific column? 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? (more) |
— | over 3 years ago |
| Edit | Post #277967 |
Post edited: |
— | over 3 years ago |
| Edit | Post #277967 | Initial revision | — | over 3 years ago |
| Question | — |
In a stored procedure, is it possible to get the total number or rows updated by different statements? 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 through MySQLWorkbench after it completes they will return a response of, ``` 5 row... (more) |
— | over 3 years ago |
| Edit | Post #277900 | Initial revision | — | over 3 years ago |
| Question | — |
How to protect the git respository for a public_html folder on a Linux server? On a Linux server, if you leave the .git folder unprotected in the publichtml folder, its possible that someone could download the folder and then gain access to your files. There are two ways I have seen of preventing this, - Move it up one level and then in the .gitignore ignore all folders ... (more) |
— | over 3 years ago |
| Edit | Post #277833 |
Post edited: |
— | over 3 years ago |
| Comment | Post #277833 |
@Monica I mean the solution works regardless of whether you are disabling a bunch or just one user (more) |
— | over 3 years ago |
| Edit | Post #277834 |
Post edited: |
— | over 3 years ago |
| Edit | Post #277834 | Initial revision | — | over 3 years ago |
| Answer | — |
A: How to temporarily disable a MySQL user? 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 condition here ``` To do this through MySQLWorkbench, - go to Management - Users and Pri... (more) |
— | over 3 years ago |
| Edit | Post #277833 | Initial revision | — | over 3 years ago |
| Question | — |
How to temporarily disable a MySQL user? 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 is temporarily locking out a single user if you are sure if that user is being used anymore. How can... (more) |
— | over 3 years ago |
| Edit | Post #277367 |
Post edited: |
— | over 3 years ago |
| Edit | Post #277532 | Initial revision | — | over 3 years ago |
| Answer | — |
A: How does the community feel about resource requests? I would like to see questions asking for help finding resources be considered on topic, but I would suggest creating a seperate category for them, like how Photography and Outdoors have one for Gear Reccomendations. We should also think about some community wiki style posts with links to tutorial... (more) |
— | over 3 years ago |
| Edit | Post #277511 | Initial revision | — | over 3 years ago |
| Question | — |
Is it unsecure to use a password on the command line to run a MySQL script on Windows? Its possible to execute a MySQL file from the command line like so, ``` mysql -u USER -pPASSWORD < FILENAME ``` which triggers a warning, ``` mysql: [Warning] Using a password on the command line interface can be insecure. ``` Given that its possible to go back through command line hist... (more) |
— | over 3 years ago |
| Comment | Post #277469 |
@Alexi alter table example change old_name new_name data_type; (more) |
— | over 3 years ago |
| Comment | Post #277470 |
The more data a table has in it, the longer it takes to rename the column (more) |
— | over 3 years ago |
| Edit | Post #277469 |
Post edited: |
— | over 3 years ago |
| Edit | Post #277469 | Initial revision | — | over 3 years ago |
| Question | — |
Can renaming a MySQL column be sped up by dropping indexes or foreign keys? 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 foreign key speed up the process? (more) |
— | over 3 years ago |
| Edit | Post #277455 |
Post edited: |
— | over 3 years ago |
- ← Previous
- 1
- 2
- 3
- Next →