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.
Search
This is possible in two steps by using a dynamic SQL: SET @nextId = (SELECT MAX(id) + 1 FROM `CustomTable` ); SET @sql = CONCAT('ALTER TABLE `CustomTable` AUTO_INCREMENT = ', @nextId[]()); PREPA...
Yes, you can achieve this using UNWIND and CALL, in the following pattern: UNWIND ['Canada', 'Europe'] AS region CALL { WITH region query } RETURN * You can replace RETURN * with any o...
I have a big Cypher query that is depending on a variable. Example: With REGION = 'Canada' query I want to execute this query several times based on different values on a list and return the UN...
In PHP one can either use include or require to include files, the difference is that if the file doesn't exist it will emit a fatal error and halt with a require and only emit a warning with inclu...
According to the documentation for the MySQL IN function: The number of values in the IN() list is only limited by the max_allowed_packet value. The default value for it is 67108864. So, you...
There have now been two questions about Cypher, the Neo4j query language. Highlight.js doesn't support Cypher syntax highlighting out of the box, but they do offer a drop-in highlightjs-cypher modu...
I have a PHP program that does a SELECT and then updates some of the values based on an algorithm. Rather than updating one row at a time UPDATE example_table SET COLUMN_A = 1 WHERE primary_k...
I have a very large table that I need to iterate through with a PHP script and I can't do all of the results at once so I do it in sections with a LIMIT like for ($x = 0; $x < 10000000; $x += 1...
Microsoft.Build.Evaluation.Project seems to have some rather odd ideas of what values to use when loading projects. In particular, I have a number of projects with the following dependency: <Pa...
The problem described below occurs in Windows 10 and Chrome 87.0.4280.66 (64 bits, JavaScript enabled). I could post this question only in mobile (Chrome/iOS 14.2), where the problem doesn't occur....
So I had a table with a primary key and a bunch of different columns. Columns A, B, and C were all unsigned ints (like the primary key column) and each column had a unique constraint I dropped the...
YES or NO: It all depends on the storage engine Fairly universally, though IIRC from looking at PostgreSQL a while back, PostgreSQL may not even do that, there is a difference between CHAR/VARCHAR/...
Consider using look-up tables to increase execution speed (at the cost of some 200 bytes .rodata use). For example this: static const char specifiers[] = "diouxaefgcspAEFGX"; could be replaced wit...
Put it in a comment if it's just "It's fine, no problems here". As with most answers that aren't substantial enough to warrant their own answer post, I'd say to just leave a comment. As you said, k...
I have a query that returns the owner of jobs on an SQL instance, select s.name as JobName , s.owner_sid , ISNULL(L.name,'AccessViaGroup') as LoginName --Trying to figure out how to turn that ...
That... looks like a funny bug. I started writing an answer, containing mostly the number "1", because that would be an (not really helpful, but correct) answer to your question. To test, whether t...
I can provide an answer based on Stack Overflow experience. SO offered watches by tags. By using a general tag along with a more specific tag, users interested in [sql] will also get the question i...
Just looking at your code, I think you'll need to look at a few nasties in scan sets: %[^]%a-z] stops at the second ], not the first, for example, and I think your code would misconstrue the %a ...
I would create three repository, let's call them dev, doc and shared for simplicitiy. Then I would add shared as a dependency to the other two by using submodules. In this way you will not only tra...
questions asking for implementing a certain feature (or homework). You should include your (partially working) trials in the post asking to explain what a certain code does. A great many questi...
This will be community dependent - e.g., Software Development, Outdoors, Cooking, etc. might each have a different rule. IMHO, there are two issues here: How helpful is such information, compared ...
One of the benefits of having the compiled CSS in the revision history is that it enables you to see changes if you have other steps in the compile process besides SCSS -> CSS. One example is if...
As far as I can tell, there are no tags yet for the main Q&A. I suggest setting an initial group of tags which help organize questions. Two groups I think would be particularly helpful are lang...
The default Swing look and feel can be set in $JAVA_HOME/conf/swing.properties What else can be set in this file? I can't find any other documentation of it.
I would simply turn off foreign key checks: SET FOREIGN_KEY_CHECKS=0; and make all the changes, and then turn foreign key checks back on: SET FOREIGN_KEY_CHECKS=1;
