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 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…
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.…
I have a table with a column with repeating values, and I want to add another column that has unique values for each distinct value in the first column.Here is a sample: temp Postal 1 42420 2 90032 3 60610…
I am trying to write a stored procedure in MariaDB/MySQL that will return table names, if any, within the schema that matches a pattern provided by the parameters. Guessing this is accomplished by querying the information_schema table, but any advice…
Let's take this sample HTML: <div class="card custom-card mt-3"> <div class="card-body" id="default"> <div class="row"> <div class="col-lg-8"> <input type='text' name="project_code" placeholder="Dear Client," class="form-control" onkeyup="setvalue(this)" id="text" /> </div> </div> </div> </div> <script> var counterSection = 0; function init() { dragula([document.getElementById('default')]).on('drag', function (el)…
With this following schema CREATE TABLE test ( id INT , is_true BOOL ); INSERT INTO test (id,is_true) VALUES (1,FALSE); INSERT INTO test (id,is_true) VALUES (2,FALSE); INSERT INTO test (id,is_true) VALUES (3,TRUE); INSERT INTO test (id,is_true) VALUES (4,FALSE); I make…
I have the following table (offer_properties) in MYSQL for an e-commerce website: +----------+-------------+---------+ | offer_id | pkey | pvalue | +----------+-------------+---------+ | 63 | shoesize | shoe_47 | | 63 | sport | walking | | 63 | color |…
I have table: id topic subjectId content 1 Topic1 5 con... 2 topic2 6 con... 3 topic3 6 con.... 4 Topic4 5 con... 5 topic5 6 con... 6 topic6 5 con.... currently I selected id 4 which have subjectId 5,…