Category "mysql"

Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?'

I am using windows 10 command line for a django project using python34 however, I am facing difficulties with SQL. I have already installed mysqlclient using

Find all employees who earn more than the average salary of all employees of their company

I have the following database scheema. employee (employee-name, street, city) works (employee-name, company-name, salary) company (company-name, city) manages (

Apache won't bind to ANY port (OS 10048)

I can't get the Apache service to start. When I try to start it from services I get the following events in event viewer. The Apache service na

backup files to google drive using PHP

I have a server and a domain name on GoDaddy. I want to create a backup for my files to be uploaded on Google Drive So that all my files and my database have

Missing comma before start of a new alter operation. (near "CHARACTER SET")

Mysql - phpmyadmin What's wrong with this query? ALTER TABLE `invoices` CHANGE `status` `status` ENUM('paid','due','canceled','partial','cheque') CHARACTER SE

mysql many tables, multiple columns group by

The table I have configured is as follows. TABLE CAT{ ID number primary key, CATNAME varchar2, ... } <Many-to-Many> TABLE CAT_CHARR{ CATID number

SSL connection error when trying to connect to mysql Aurora via the mysql CLI

I will preface by saying I can connect to the DB instance when I'm not trying to go over SSL. I am following this guide here http://docs.aws.amazon.com/Amazo

Inno Setup Script For MySQL 5.7 silent install

I want to silent install MySQL 5.7 from Inno Setup so i have use this link, but this for MySQL 5.5 not for 5.7. I have MySQInstallerConsole form command prompt

How to use window functions to get the cumulative count of two columns based on the value from one column?

I'm trying to get the cumulative count of previous records for two player columns where the player ID exists in in one of the previous columns. As an example I'

How can Select date(dd/mm/yyyy) in ascending order in sql

I want To Select stockDate in ASC Order My Table Structure is.:-

Authentication plugin error when connecting to mySQL

I am learning PHP and just installed Sequel Pro. I am trying to make a connection but it is giving a long error but last line says MySQL said: Authentication p

Table doesn't exist After Creating a Temp Table

Hi I am creating a temp table and insert a record using CREATE TEMPORARY TABLE temp_table_extension_details ( `Id` int NOT NULL,

Retrieve last inserted id with Mysql

Good day, I am willing to retrieve the id value of a freshly inserted row in Mysql. I know there is mysqli_insert_id function, but: I can't specify the table Ma

Variable retrieved from json data doesn't seem right

I retrieve data from mysql server and one of the fields is an int value (1 or 0 ) and it's printed right (1 or zero ) but when I try to apply an if condition on

Single Large Transaction VS Multiple Small Transaction

I am designing a system where users can select/ insert/update/ delete multiple rows of multiple tables multiple times (n times in a loop based on some logic, th

WAMP Virtual Host not working

I am using a wamp version 2.5 My Apache is 2.4.9 PHP: 5.5.12 MySQL: 5.6.17 I have these configurations: On my httpd.conf # Virtual hosts Include conf/extra/h

failed to open file in mysql database

i downloaded employees database from github that recommend mysql in its website but it has error in importing . how can i fix it? i dont think it is corrupt dat

Sequelize does not include attributes (MySQL)

i am trying to create select with "custom" attribute. Everything is working fine except that the "custom" attribute is not included. Query is generated correctl

I'm trying to link between Firebase Authentication and MySQL using a new scenario

I want to take your opinion about this weird scenario before applying it. I'm using FirebaseUI. The users' table ID NAME EMAIL PHONE_NUMBER PHOTO_URL CREATED S

Can I put arbitrary text in SQL comments when using ODBC?

Consider a table defined by CREATE TABLE Example (id INTEGER) and an INSERT statement for adding tuples to Example, having a single quote in a SQL comment: