From Python 3.9 i'm trying to do a MySql query like this select * from brand WHERE text='L'Orial'. It works fine from phpMyAdmin but fails from python for all text including quote "'" brand = "L'Orial" where = f"text='{brand}'" brand_pk_id…
CREATE TABLE `users`( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(75) NOT NULL, `password` VARCHAR(255) NOT NULL, `email` VARCHAR(100) NOT NULL, PRIMARY KEY `id` UNIQUE KEY `email` (`email`) )ENGINE = INNODB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =…
I am creating tables in PHPMyAdmin using Laravel Migrations. One of the things that I want to do is have a Question Table and Answers Table where 1 question can have 4 answers (Multiple choice). I want to link the…
Good morning all, I am on a project under symfony4 ' I made an association membership management application. Until now when I wanted to update my membership list with a csv file I did it directly in phpMyAdmin. I have…
I'm working on a table with a column, 'Expiry Date', as a varchar with all data formatted as DD/MM/YYYY. The creator of the table has used the wrong type for this expiry date column and now the client needs to…
this is my proc, and below is my error, apart form the numerous ; missing, what am I Missing on line 2?? CREATE PROCEDURE sp_insertOnReject @id int AS BEGIN START TRANSACTION; UPDATE content_manager.submission SET state = 'Rejected' WHERE id =…
I'm on Laravel 5.4, PHP 5.6, Ubuntu 18.04, MariaDB 10.4.8. When I run php artisan migrate, I get: In Connection.php line 647: SQLSTATE[HY000]: General error: 1005 Can't create table `test-kursach-backend`.`comments` (errno: 150 "Foreign ke y constraint is incorrectly formed") (SQL:…
I am trying to communicate to a MSSQL Server database with PHP from a woocommerce website (to fetch data like products, categories etc.). But I get no results, here is my code: $connectionInfo = array( "UID"=>$uid, "PWD"=>$pwd, "Database"=>$databaseName); $conn =…
My problem is: I need to insert two values from two different tables and one given one by the exercise into a third table. First, I figured I need the data from the two separate tables, therefore: SELECT tablename1.id FROM…
I get an error when I import sql file in phpmyadmin. Here is an error -- -- Indexes for table 'tbl_disposisi' -- ALTER TABLE 'tbl_disposisi' ADD PRIMARY KEY ('disposisi_kd'), ADD KEY 'fk_tbl_disposisi_tbl_berita_idx' ('arsip_kd') #1062 - Duplicate entry '2' for key…