Although I probably.

 
Shafran: Okay so the DECIMAL field I was gonna use for this. column declaration. hmm. DECIMAL5,2 means I can do -999.99 to 999.99. if I change this to DECIMAL7,3 I’d get -9999.999 to 9999.999 ?

Baggio: Jeffreylevesque: nope, no one at all uses mysql

Quastad: Can someone tell me why mariadb/mysql failed to install, and how to correct this – https://bpaste.net/show/04ec4f1b6cfb via travis – https://github.com/jeff1evesque/machine-learning/blob/acfc65f8cc1c68e620703c0b7d2549d9ace26401/.travis.yml

Fiedtkou: Jeffreylevesque: use the mariadb addon in travis – e.g. https://github.com/PyMySQL/PyMySQL/blob/master/.travis.yml

Lugg: Danblack: do i need the matrix attribute?

Mccarthy: Does it go directly under install – https://github.com/jeff1evesque/machine-learning/blob/acfc65f8cc1c68e620703c0b7d2549d9ace26401/.travis.yml#L13?

Shutte: I don’t know what tox is

Tabicas: Jeffreylevesque: just add the matrix: include: and then the addon bits for the mariadb and purge out your hand written install.

Beausoleil: Is that installing mariadb client, server, and the connector with python

Kuczma: Skip the bits with DB=5. because i couldn’t bother walking you though it

Bishel: It installed mariadb client and server. you’ll still need to pip install the python connector

Wydryck: Failing that refer to the travis docs

Lambrukos: Danblack: DB=5 for every addons

Samples: Ignore it. leave it out.

Catchings: So, ignore DB=5 all together, entirely?

Schumans: Include a FLASK version in each matric branch

Monzon: Jeffreylevesque: No, we will not spoonfeed you. We’ll give you pointers, man pages, general guidelines, even web pages that you *actually* have to read. But don’t expect use to spoonfeed you. You can allways employ a MySQL Consultant for that.

Sprowls: Asking the same question to something i’ve already answered 3 times is a sure way to **** me off.

Lowthert: Hi, I am trying to write a MySQL query, and am not sure about two parts of it: 1 I only want matches where any of the numbers in an array do not appear in either of two columns of the same table one column itself as an array of numbers, but separated by commas, 2 with these results, I want to append a string to one of the columns

Durning: Intent: http://gtowey.blogspot.com/2009/12/how-to-fix-comma-separated-list-of-doom.html

Maril: Danblack I can’t do anything about the table structure

Kummerow: Ugh, I thought there was a factoid something like “are you asking us a question that you have been ***igned as homework?”

Kummerow: Intent: do you have a query so far?

Reuben: I shall prepare one and return to these depths

Kummerow: When you do, post it and your example schema to sqlfiddle.com

Kummerow: It’s a useful tool for query exploration

Sliney: Life_in_4k: how’s this look: RENAME TABLE? FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘database’ & TABLE_NAME ‘wp’ LIKE ‘wp_’

Sliney: Anyway, how does this query look if I’m trying to find and rename database table prefixes for wp?

Sliney: I don’t know how to start it off

Sliney: Got it! SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘database’ OR TABLE_NAME = ‘wp_’ LIKE ‘wp_’;

Sliney: Well, not 100% correct but w/evs

Kujath: My insane pile of game code just got simplified to THIS thanks to MySQL. 😀

Erchul: Volund: it does. especially when you use it like a relational database.

Yendell: Danblack: I’m probably using it like a mess.

Lavallee: Granted, much of what I’m doing is not crazy enough to need advanced trickery yet

Galang: Some of my tables do have Foreign Keys and I DO use a few joins here ‘n there. that’s about it.

Mccreadie: Although I’m going to have to rethink something.

Petrunger: Although I probably shouldn’t worry too much about hammering the SQL server at this level of data being used, hrm.