I would like to insert multiple rows in a table. All of these rows will have the same values. The number of rows is not fixed but come from an input label in the frontend ($Num variable). How can I…
I have a table of users who have subscribed to different plans of a streaming services and other data about the said users. Something similar to this, Name Plan Status Subscription Date Cancel Date Ajax 5-user Active Jan 2021 -…
Suppose I have a table 'results' that looks like this: student | score | passing_grade 1 | 50 | 70 1 | 30 | 50 2 | 90 | 50 2 | 80 | 100 I want to count, for…
Is there a way to set at the time of creating a table a custom ID with some character as prefix and the rest are numbers which is auto incremented so that the first time a record is inserted the…
Probably it's super simple but i've been stuck some hours on this. I have a column called "Publish_Date" which is a varchar, but my date shows like this: 17.01.11 (year.day.month) and I want to convert it to a date (at…
cust_id state 1 CA 2 IL 3 SC 1 PA 3 IA 4 MO 5 VA 4 NY Can any one please advise on SQL Query that return the cust_id that belong to two states as below: The output should…
I experimented if non-repeatable read and phantom read occur or not with SERIALIZABLE on MySQL but against my expectation, both non-repeatable read and phantom read actually occurred with SERIALIZABLE. These below are the definitions of non-repeatable read and phantom read:…
CREATE TABLE products ( id int not null auto_increment PRIMARY KEY, Name varchar(30) not null, Reliability int default 0, date timestamp default now(), expiration timestamp default (now()+31536000) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; I'm trying to add an expiration date for products…
I'm writing a script to create 5 tables, but cannot seem to get the SQL DDL part of the statement to work. I get a syntax error " unexpected 'table' ", and I've tried the SQL statement with execute immediate…
Here is my PHP block. The get functions all work fine. <?php function getTitle() { $connection = new PDO('mysql:host=x.x.x.x;dbname=x;charset=utf8', 'x', 'xxxx'); $query = $connection->query("SELECT `value` FROM `services` WHERE `type` = 'title';"); $data = $query->fetchAll(PDO::FETCH_COLUMN); echo '<textarea id="services-title" name="services-title" rows="1">' .…