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">' .…
I have a table with the following columns: ClientID, Amount, etc. The problem is that some clients have two or more rows with Amount = 0, and I want to remove these rows. I've searched some information but only found…
I have a table of entries in a mysql table: script lastRun processed ________________________________ scriptA 1663695633 0 scriptB 1663695647 1 scriptA 1663695776 0 scriptB 1663695799 1 scriptC 1663695950 1 scriptA 1663695957 0 scriptB 1663695959 1 I am trying to get…
This is the table I am working with: +---------------------+----------- | Field | Type | +---------------------+--------------+ | ID | binary(17) | | MiscSensor_ID | binary(17) | | rawValue | varchar(100) | | RawValueUnitType_ID | int | | timestamp | timestamp |…
Description To test our updates, we compare an old, updated database schema with a fresh installation. The two schemas should be identical. We use SHOW CREATE TABLE to find the differences. However, we noticed that with MySQL 8 we find…
As you can see below I have Name column. I want to split it by / and return the value in array. MyTable Id Name 1 John/Warner/Jacob 2 Kol If I write a query as Select Id, Name from MyTable…
I have the following SQL database details: import sqlalchemy as sch from config import Config db_uri = os.environ["SQLALCHEMY_DATABASE_URI"] + os.environ["DB_NAME"] in the env file I have these SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://*****:*****@instance-amazonaws.com:3306/' DB_NAME = 'DB_NAME' Now db_engine = extrac_db.create_engine(Config.db_uri) db_connection = db_engine.connect()…
select * from `attendance_marks` where exists (select * from `attendables` where `attendance_marks`.`attendable_id` = `attendables`.`id` and `attendable_type` = 'student' and `attendable_id` = 258672 and `attendables`.`deleted_at` is null ) and (`marked_at` between '2022-09-01 00:00:00' and '2022-09-30 23:59:59') this query is taking too…