I have a form which is used to search the database. The form consists of four fields, including two date fields: (Col1, Col2, Datefm, DateTo). Users have the option to fill the values in these fields. They may fill the…
I have table firebaseTokens with columns userId and tokenValue. When a user logs in, my ReactJS frontend grabs the device token and assigns it to the logged in user via the userId column. A user may have many tokens, and…
I have a query that looks for the highest value of a given name in a table and returns that number. It works great in the SQL console. But, I am trying to get that value and then create radio…
I needed to run the following on MySQL, but it doesn't allow FULL OUTER JOINs: SELECT COALESCE(t0.date, t1.date, t2.date, t3.date) AS date, COALESCE(t0.hits1, 0) AS hits0, COALESCE(t1.hits2, 0) AS hits1, COALESCE(t2.hits3, 0) AS hits2 COALESCE(t3.hits3, 0) AS hits3 FROM t0…
I have 4 tables: Table user with id, email, first_name, last_name, country, activated Table assets with id, serial, model_id, assigned_to Table models with id, name, category_id Table categories with id, name Table status_labels with id, name & I want to…
Having the following table mysql> desc customer; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | id | char(36) | NO | PRI | NULL | | | firstname | varchar(255) | YES…
CREATE TABLE payment.payment_details ( customer_id INT NOT NULL AUTO_INCREMENT, amount INT NOT NULL, mode VARCHAR(50) NOT NULL, payment_date DATE NOT NULL DEFAULT CURRENT_DATE(), PRIMARY KEY (customer_id)) ENGINE = InnoDB; Operation failed: There was an error while applying the SQL script…
Currenty I have records like below : name|score| tony|23| john|32| eddy|25| mark|21| nick|26| alex|27| nick|23| I want to request table with only name like : tony, john, eddy, mike, paul using this query below ; SELECT name, name FROM a_team…
The calculation of the total price of products with their quantity. the total price exists in the order migration table with a default of 0 value, and I want to put the $res value in the total_price column. public function…
I am having a form which contains some field(language,Datefrom,Dateto,Status).There is a submit button.I want to fetch the data based on the value filled on these field.My query to ignore the field which is not filled.How can i write the query.…