I need a result of an array that is flattenened like this: $result = ["1", "2", "3", "4", "5", "6", "7"]; I have a DB result of this query: $articles = DB::table(‘articles’) ->where(‘is_published’, ‘true’) ->get() ->pluck(‘category’); When I do this with this result: $unflattened_array = $articles->toArray(); dd($unflattened_array); The result looks like this: And when I… Read More How to flatten a collection with items of array in Laravel

I have a table like this librarylog patronName bookId dueDate John 24 2024-01-14 Sam 42 2024-01-07 Bob 13 2024-01-07 I’m trying to create a SQL query which updates all the dueDate values and increases them by a week. This is what I had: UPDATE librarylog SET dueDate = DATE_ADD((SELECT * FROM (SELECT dueDate FROM librarylog)tblTmp),… Read More Run UPDATE mySQL Query on Multiple Rows

I just barely started learning JavaScript by myself and have a question to ask. I have a JSON database I created, and a JavaScript file connecting to this same db, on another js file I have a function that I call with a button, how can I get the data from my JSON database into… Read More Export a JSON database to use in JavaScript

I’m trying to divide two count using where conditions (SELECT COUNT([Main_Status]) FROM [V_Incidents_Combined] WHERE [Main_Status] = N’open’) / (SELECT COUNT([Main_Status]) FROM [V_Incidents_Combined] WHERE [Main_Status] = NT’Closed’) I get this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near ‘/’ >Solution : You have two subqueries, but you’re not doing anything with the… Read More Sum of count with where query

I am trying to delete a row from my database but nothing worked. here is my code: import mysql.connector mydb = mysql.connector.connect(host="localhost",user="user",passwd="1",database="workers") mycursor = mydb.cursor() query = "DELETE FROM `workers` WHERE id = %s" # connect to the database server # execute the query mycursor.execute(query, (1,)) mysql.commit() # You need to commit the transaction Note:… Read More python mysql – can not delete row from database

So I have this piece of code in a recent migration: public function up(): void { Schema::table(‘chirps’, function (Blueprint $table) { $table->string(‘message’); $table->foreignId(‘user_id’)->constrained()->cascadeOnDelete(); }); } and I have this in my User model: public function chirps():HasMany { return $this->hasMany(Chirp::class); } I want to understand the difference between a model and a the actual database (which… Read More How are migrations seperate from models in Laravel

I am a beginner in Java programming.I want to start from basic to learn Java and due it’s higher learning curve I want to know the easiest way to solve this thing done I am a beginner in Java programming.I want to start from basic to learn Java and due it’s higher learning curve I… Read More How do I print a message to the console in Java?

How to drop NAMMIK with backquote ? It was accidentially added by CALL sys.create_synonym_db; mysql> show databases; +——————–+ | Database | +——————–+ | information_schema | | `NAMMIK` | | NAMMIK | | mysql | | nammik | | performance_schema | | sys | +——————–+ mysql> DROP DATABSE `NAMMIK`; ERROR 1064 (42000): You have an error… Read More How to DROP a database with character '`' in its name?

I’m working on a data processing project in Python where I need to handle a large dataset containing millions of records. I’ve noticed that my program’s memory usage keeps increasing as I process the data, and eventually, it leads to MemoryError. I’ve tried using generators and iterating over the data in chunks, but it doesn’t… Read More Optimizing Memory Usage in Python for Large Dataset Processing

First, I am new to database management, so my terminology might be slightly incorrect. I have data I believe would best fit into a many-to-many bidirectional database (I am using SQL with Java). I am trying to represent the relationship between employees and job positions. Each employee, identified by a unique id, can hold one… Read More How to think about and organize a Many-to-Many bidirectional database