Using LB4 + MySQL DB through loopback-connector-mysql to create tables on DB. A {id: string, name: string} id names 0007bc40-814b-11ec-8128-4df48bd1ae4d John 0
I have a table of wind directions and strengths over a 24 hour period, sample data at the bottom of this question. only directions that have strengths are store
thank you in advance for the help. I am using nodejs v16.13.1 and mysql 5.7.37-cll-lve. my nodejs app is currently on my local machine and my mysql db is on a r
table -- > qt qstnId tagId 1 1 1 2 2 3 2 4 2 2 table --> question qid 1 2 qid is primary key and qstnId is Fk now when i'm running query --> mysql&
I tried to count rows with from 2 different table. the scenario is If status on tbl_task waiting, this job will not yet got the sales_id from tbl_sales. Once th
I am asking for a hint. I searched the internet for a long time for a solution to the problem, but I'm already desperate. I would like the update operation to u
I started to learn MySQL recently and I have a 2015 MacBook Air. After installing MySQL server, I ran pip install MySQL-connector-python. Everything worked perf
I have an MYSQL database table of student info and their test scores per subject and I am trying to fetch each student's highest score in all subjects using the
I used node js to connect mysql server and it is working good. I used the API developed in node js and used in the local macOS app. The problem is querying the
This is my data retrieving query: $admin_students=DB::select("select students.*,application_record.*,gender_record.*, application_record.id as app_primary_id,ap
I want to build a login form : users access the welcome page using their passwords.
I found an issue when delete some data, so I isolated the code Route::get('v1/testapi', function (Request $request) { return [ DB::table('attendances')->
I found an issue when delete some data, so I isolated the code Route::get('v1/testapi', function (Request $request) { return [ DB::table('attendances')->
How show mysql query without NULL? I want to show my quary where "LAG(title) OVER(PARTITION BY emp_no)" IS NOT NULL, I need only titles.emp_no = "LAG(title) OV
this is my candidatController.php the error is in the line before the last line($prev_canditure->etat="archifé";) $candidat_nw=Candidat::orderby('crea
this is my candidatController.php the error is in the line before the last line($prev_canditure->etat="archifé";) $candidat_nw=Candidat::orderby('crea
Using DataJoint Python (0.12.9) on Ubuntu with MySQL 5.7 . Am running into an error with what I believed to be a fairly standard operation. Have a table named T
Using DataJoint Python (0.12.9) on Ubuntu with MySQL 5.7 . Am running into an error with what I believed to be a fairly standard operation. Have a table named T
Thanks for reading my post. I wanna know, what is the difference between length (1-256) and (0-256) in sql and how to store them in database?. I was asked to de
I wanted to select values from one table according to another table I have a booking system with 'user' information table and 'appointment table', they have col
pyelasticsearch