How to use MySQL JDBC driver in an SBT Scala project?

MySQL
When I run my project for the first time during an SBT session, it throws the following exception when trying to access to a MySQL database: java....
2 years ago

Write MapReduce ETL job

MySQL
I have a table of ~300GB of data in mysql. I want to add new column in table. When I alter table using alter command, it never completes and process d...
2 years ago

mysql JOIN query returns multiple times the same rows

MySQL
I'm trying to display all the generic slopes (from game_slopes) from sector 1 that are built (i.e. present in game_created_slopes) and status_id =1. ...
2 years ago

Applying HAVING clause condition depending on a column value

MySQL
I want to get some records from a table: HAVING COUNT(*) < n.dailyshow n.dailyshow is a number or letter (like u) When n.dailyshow = 'u', it me...
2 years ago

MySQL Check if any row has a date in the future

MySQL
(The following schema has been minified to reduce the problem) I'm having two tables Products: | ID | ProductName | AvailableDate (da...
2 years ago

iterate mysql table in python

MySQL
I have an array containning some mysql tables and I want to iterate and visualize. For example but the programm is not working tab=["spectreH20","...
2 years ago

How to get all records from two tables where doesn't exists in third

MySQL
I'm looking to find a way to display a list of users that have cancelled a booking today. The way my system works when a user cancels a booking is by...
2 years ago

Updated one column but 'published_at' column was also updated? [Laravel 5]

MySQL
In the database I have a table 'articles' with columns: 'title', 'body', 'published_at', 'image_name' (and there are also Laravel's 'created_at' and '...
2 years ago

From base 10 to base 26 only with letters so that 26 will be aa

MySQL
I have the CONV function in Mysql: mysql> CONV(26,10,26) -> 10 But I want something like this: mysql> CONV_LETTERS(26,10,26) ...
2 years ago

mysql SELECT IF statement with OR

MySQL
The following works - returns Y when chargeback equal to 1 else it defaults to N IF(fd.charge_back = 1, 'Y', 'N') AS charge_back however I cannot s...
2 years ago

Create a custom selected list

MySQL
Well im adding to database some records but i dont like the way i did and wanted to make something way easier for the user and better. What i did was...
2 years ago

MySQL Create DB If Not Exists With File Import Command Line

MySQL
So I'm using a command like: mysql db < db.sql But whenever I do this with a DB that doesn't already exist, it errors. Is there a command flag ...
2 years ago

Convert string to mysql datetime with AM/PM

MySQL
I am working on a WordPress plugin that allows the user to select a time using a jQuery dropdown script. The time is a string in the format of "5 : 34...
2 years ago

get all second highest values from a mysql table

MySQL
I have a table with two fields as follows, name score xyz 300 pqr 200 abc 300 mno 100 erp 200 yut 200 How can I re...
2 years ago

Multithreaded write on MySQL DB with JDBC and c3p0

MySQL
I have written a DAO class which allows several threads invoked by ExecutorServices to write to MySQL DB. EDIT: I am using c3p0 to create a JDBC Con...
2 years ago

How to use python mysqldb to insert many rows at once

MySQL
I have a list of lists, e.g [['a','b'],['c','d']]. I have a table called T and two fields F1, F2. The first item in the field list maps to F1, secon...
2 years ago

MYSQL Group rows and sort each group

MySQL
I have a mysql table for storing comments and subcomments with the schema: id,replyTo,text where replyTo may be null, if the comment is not a sub-comm...
2 years ago

Can't connect to MySQL server on 'localhost' (10055)

MySQL
I am running three perl scripts sequentially. Each of them connects to a Mysql database multiple times, and either selects or updates the information ...
2 years ago

Returning query value in OOP

MySQL
I am learning OOP. My question is based on below code. Each time the value is returned in index.php using $query_value->GetName() or $query_value-&...
2 years ago

1 to many select and concat

MySQL
I have two tables: [customer] id name [customer_photo] id customer_id photo I want to select all customers and their photos. This query is doing ...
2 years ago