I have the following tables defined by: CREATE TABLE db.books ( id INT auto_increment not NULL, title varchar(100) NULL, category_id INT NULL, PRIMARY key (id) ) CREATE TABLE db.books_categories ( id INT auto_increment not NULL, category varchar(100) NULL, PRIMARY key…
I need to read the id from the label and write it to a global variable to render the content on a separate page. But since this label is generated by ItemControls, I don't know how to refer to it.…
i have to get the status of completion of the scrom package by students and i wrote a code that is displaying only the completed and incomplete students data, but i also want those students who are enrolled but not…
I have the following data which has two columns journal & published_year CREATE TABLE journals ( journal VARCHAR(255) NOT NULL, published_year INT NOT NULL ); INSERT INTO journals (journal, published_year) VALUES ('Journal A', 2022), ('Journal B', 2017), ('Journal A', 2021),…
The task is to exclude row by a group where the "word" field is NULL Tables CREATE TABLE `search_phrases` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `phrase` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `frequency` bigint NOT NULL, PRIMARY KEY (`id`), KEY…
My database : MySQL Project : Symfony 6 Table structure : 1 article may have many comments each article must have 1 article. Steps : 1 - I can list my articles filtered by user roles. 2 - I can…
I need to reduce query time from 1.3sec to 0.1sec. if I don't compare sum(amount) with sum(pd.amount_take) my query time is 0.03sec My Code sql: SELECT p.po_id, date_format(p.po_date,'%d-%m-%Y') AS po_date, p.branch_id, b.fullname as branch_send, p.branch_id2, bb.fullname as branch_recieve FROM tbl_po_branch…
I'm trying to move from cookie-based sessions to a database. I'm running this command. I get the error below. It's trying to connect to a local MySQL server. I do not have a local MySQL server. I have a dedicated…
I am solving the SQL problem from Leetcode: 178. Rank Scores.. The question of the leetcode is this: Write an SQL query to rank the scores. The ranking should be calculated according to the following rules: The scores should be…
First time i try to log in in my website the website crash with error " status on null" , sometimes when i refresh it lets . I cant find the error. public function authenticate() { $this->ensureIsNotRateLimited(); if (!Auth::attempt($this->only('email', 'password'),…