I only need id data from a table for an insert data for another table. But I don't know how? So I created search data request $iduser = User::where('username','like','%' . request('username') . '%')->get(); I can't use $iduser->id or some similar…
The information found in the official MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html does not match the information shown in the manual at https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html for version 8. First link says that the 64kb limit was dropped, the 2nd link says it exists. It…
I would like to add some SUMs from subqueries in the SELECT into another new field. Here is the query that I am currently using: SELECT DAYNAME(date) AS day, DATE_FORMAT(date, "%d-%m-%Y") AS date, (SELECT SUM(qty) AS product1_shift1 FROM bill_details JOIN…
I have created a vertex student: test=# SELECT * FROM cypher('graph', $$ CREATE (s:student{name:"Muneeb", courses: ["OOP", "DS", "Programming", "Android"]}) RETURN s $$) as (student agtype); ---------------------------------------------------------------------------------------- student ---------------------------------------------------------------------------------------- {"id": 3377699720527873, "label": "student", "properties": {"name": "Muneeb", "courses": ["OOP", "DS", "Programming", "Android"]}}::vertex…
I have a form(title, description, images, etc...), in this form I pick multiple images and store them in a list, I want to insert this list of images in the database and also fetchAndSet the data later on. since we…
I have been struggling for days trying to find if a conversation exists between two users using Sequelize. I have relationships between conversation, message, user and userConversations. Here is how a table can look like: Here is my userConversations table,…
I wrote this code and it works: SELECT d1.*,d3.* FROM bdir_programmation.d_program AS d1 JOIN ( SELECT d_program.id,MAX(id_reg) AS maxv FROM bdir_programmation.d_program GROUP BY d_program.id) AS d2 ON d1.id=d2.id AND d1.id_reg=d2.maxv JOIN bdir_programmation.d_infra_progra d3 ON d1.id=d3.id; But when I want to…
I am working on an application that performs bulk insertion(~12k but it can be more than that) in the Oracle database. Below is the SQL script:- DECLARE errstr VARCHAR2(4000) := ''; errors NUMBER; i NUMBER; er NUMBER; bk1 acct_common.type_tabnumber; bk2…
The backend is built with node js and the frontend React. The number of images is not very low not very high. Should I store the images in the database (MongoDB)? , on the cloud like Amazon?, or in the…
I am not sure what I need to do. Every time I try to run the mongo shell on Linux I get an error asking me to stop the database before running MongoDB with start-noauth. I am not sure how…