PowerPoint slide to display data from MySql database? How?

MySQL
I have a powerpoint presentation running continuously. Is there a way to update one of the slides of this presentation automatically with data from a...
1 year ago

Use a sum of two values from different tables in MYSQL WHERE clause

MySQL
I know there are similar questions but I've been struggling with this for almost two days and can't make solutions given to questions to work. I have...
1 year ago

Rails: Find where an association doesn't exist and declare variable

MySQL
I'm going crazy trying to get this to work. I want to loop through a jointable called TriggersUser to see where the user doesn't have a Trigger record...
1 year ago

A single SELECT query showing all expressions being used (to be used as a guide)

MySQL
I've been looking for a single query which shows the order in which a basic SELECT query ought to be written. Having failed to find one, I am now atte...
1 year ago

mysqldump problems with restore error: 'Please DISCARD the tablespace before IMPORT'

MySQL
I run a daily backup mysqldump backup of the production database (mysql version 5.1.66): mysqldump --user=username --password=secret -C -e --create-o...
1 year ago

Are check constraints evil?

MySQL
My question is really simple: are sql checks evil? I mean, especially those checks that we can perform on the client. This is probably the shortest q...
1 year ago

mysql time to date conversion fetches null value

MySQL
The below mentioned query is returning null but my inner query is fetching values like SELECT CONCAT( FLOOR(HOUR(time_milis) / 24), ' ', MOD(HOUR(ti...
1 year ago

MYSQL Delete From Based on Multiple Distinct Columns

MySQL
I have this problem that's been killing me for a couple days now. So we have a table of all processed orders. We have a table for all orders that com...
1 year ago

How to store stable texts? like text or like integer which is specific for each text

MySQL
I want to store stable text which means only can be changed by owner of website for example: Example user will select options from select bar which ...
1 year ago

How to define a custom ORDER BY order in mySQL

MySQL
In MySQL how do I define a custom sorting order. To try to explain what I want consider this tabke: ID Language Text 0 ENU a 0 JPN ...
1 year ago

DatabaseError: (1071, 'Specified key was too long; max key length is 767 bytes')

MySQL
I have a django project and I would like to run some unit tests. When I try: python manage.py test it throws this error and I couldn't find much infor...
1 year ago

Add entries from one table to an existing one (Both tables have entries already)

MySQL
I want to add entries/rows from one table (y) to another (X) (match them): The columns (and the name of the columns) in both are completely equal. How...
1 year ago

How to know the list of connections open on a remote MySQL AWS RDS machine

MySQL
Where can I find the list of connections open on a remote MySQL AWS RDS machine netstat -n |grep 3306|grep ESTABILISHED|wc -l I do this to find con...
1 year ago

PHP, mysql_query just NOT working

MySQL
I'm ready to pull my hair out... This works perfectly: $link = mysql_connect('localhost', 'prototype_wp_usr', 'password') or die("Error: " . mysql_...
1 year ago

Mysql order by city, province and country

MySQL
Table: entity ╔════╦════════════╦═════════════╦════════════╗ ║ id ║ city_id ║ province_id ║ country_id ║ ╠════╬════════════╬═════════════╬═════════...
1 year ago

Use of `if( ... = ... )` in mysql?

MySQL
insert into foo_table (fname, lname, number) values ('John', 'Doe', if(123 = 456)); For the above MySQL query, can somebody kindly explain what the ...
1 year ago

MySQL DB Migration fail

MySQL
For a wordpress website I am trying to migrate the website and MySQL database. Although when I import it, it gives me an error. I no longer have acces...
1 year ago

Is there a way to sum a product of two columns in MySQL?

MySQL
Here are my tables: -- receipts | id | date | |----|------------| | 1 | 2016-12-20 | | 2 | 2016-12-20 | | 3 | 2016-12-21 | -- purchases | i...
1 year ago

MySQL driver type detail

MySQL
I am using MySQL as my backend and just curious to know that MySQL falls under which driver type in Java, I am confused with type 3 and type 4 driver....
1 year ago

Working with file pointers on a csv

MySQL
I was wondering how to change the code below to read x number of lines only process the sql insert statement then continue to read the file by x numbe...
1 year ago