I've used mysql -u root and then create database 'whatevername' it results in Query OK, 1 row affected (0.002 sec) but nothing changes, no database added to the phpmyadmin solutions will very much be appreciated
So i'm trying to get "promo_type" value from mysql table to excel. However i need to use another table in order to get the value of this "promo_type". So this is the main table booking, which contains the value of…
from tkinter import * from tkinter import messagebox import mysql.connector from tkinter import Button def ok(): name = e1.get() salary = e2.get() dob = e3.get() mysqldb = mysql.connector.connect(host="localhost", user="root", password="", database="sahil") mycursor = mysqldb.cursor() try: sql = "INSERT INTO clients(ID,NAME,SALARY,DOB)…
SELECT * FROM userfeedback WHERE DATE LIKE '2020-07%' OR DATE LIKE '2020-08%' OR DATE LIKE '2020-09%' OR DATE LIKE '2020-10%' OR DATE LIKE '2020-11%' OR DATE LIKE '2020-12%' OR DATE LIKE '2021-01%' OR DATE LIKE '2021-02%' OR DATE LIKE '2021-03%'…
I have tried to create a table in a MySQL database with phpmyadmin. The problem occurred when I try to execute this following query: CREATE TABLE users( account_id INT(20) NOT NULL AUTO_INCREMENT DEFAULT '100001', PASSWORD INT(20) NOT NULL DEFAULT '0',…
Here's the scenario: I created a MySQL database on CPanel using CPanel's helper tool, also created a user for this database, and i run queries on this database using phpMyAdmin (which i also access through CPanel). I'm developing a Laravel…
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…
I have a mailing of 30000 emails to sent. Manish help me to implement a solution for which the main code is available below. When I execute this code I have the following error message. May you inform me how…
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…
Firstly, please do not link me to any of these posts as I have already read them in their entirety and nothing helped: mysql cannot grant privilege to user, getting error: ERROR 1819 (HY000): Your password does not satisfy the…