Click here to Skip to main content
14,138,178 members
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 3:10
adminChris Maunder16-Jul-09 3:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 16:30
adminChris Maunder10-Nov-05 16:30 
QuestionMongoDB Int Primary Key Pin
Kevin Marois17-May-19 8:41
professionalKevin Marois17-May-19 8:41 
AnswerRe: MongoDB Int Primary Key Pin
jschell18-May-19 7:09
memberjschell18-May-19 7:09 
GeneralRe: MongoDB Int Primary Key Pin
Kevin Marois20-May-19 6:21
professionalKevin Marois20-May-19 6:21 
QuestionMySQL Pin
Member 1437004615-May-19 3:07
memberMember 1437004615-May-19 3:07 
AnswerRe: MySQL Pin
Richard MacCutchan15-May-19 3:12
protectorRichard MacCutchan15-May-19 3:12 
GeneralRe: MySQL Pin
Member 1437004615-May-19 20:24
memberMember 1437004615-May-19 20:24 
GeneralRe: MySQL Pin
Richard MacCutchan15-May-19 21:17
protectorRichard MacCutchan15-May-19 21:17 
GeneralRe: MySQL Pin
Member 1437004615-May-19 20:25
memberMember 1437004615-May-19 20:25 
GeneralRe: MySQL Pin
Richard MacCutchan15-May-19 21:18
protectorRichard MacCutchan15-May-19 21:18 
QuestionMySql vs MariaDB Pin
DerekTP12315-May-19 1:25
professionalDerekTP12315-May-19 1:25 
Can I just run this past you guys, to check I'm not losing my mind... Confused | :confused:

I use a hosted webserver for a number of my sites, that each use a MySql database. Most use StoredProcs to access data. Yesterday, all the SP-based ones stopped working, with a variety of error messages. No code had changed. Trying to connect to the databases using HeidiSQL or MySql Workbench threw up warnings that the tools didn't support v10.2.24... now I thought I was on MySql 5.7 or something...?

Digging deeper reveals that v10.2.24 is the current MariaDB version. Checking with my hosting provider, and asking why they'd not only upgraded version but changed from MySql to MariaDB without telling anyone, I got this reply:
Quote:
MySQL 5.7 is the last version of MySQL to be called MySQL

MariaDB is the new name for what was MySQL, so thare is noting to move back to. [sic]
This is news to me!!!
I found the following (really useful) article from less than two weeks ago: MariaDB vs MySQL in 2019: Compatibility, Performance, and Syntax[^]
Please, tell me my hosting provider is talking rubbish!! D'Oh! | :doh:
Oddly enough, after giving more detail on the issue, everything started working normally again (but still reporting potential compatibility issues with 10.2.24 when using Workbench or Heidi). I'm guessing they'd not configured MariaDB to support StoredProcs (is that even an option?) but whatever they've done seems to have done the trick. But my confidence in them is very severely shaken, when they change d/bs without informing customers, and seem to think MariaDB 10.2.24 is just the new name for MySql 5.7 (and they don't even seem to know about MySql 8.0!) .... Sigh | :sigh:
AnswerRe: MySql vs MariaDB Pin
Richard MacCutchan15-May-19 3:15
protectorRichard MacCutchan15-May-19 3:15 
AnswerRe: MySql vs MariaDB Pin
jschell18-May-19 7:18
memberjschell18-May-19 7:18 
GeneralRe: MySql vs MariaDB Pin
DerekTP12319-May-19 7:23
professionalDerekTP12319-May-19 7:23 
QuestionWhat is an alias? Pin
Shraddha_Patel7-May-19 18:20
memberShraddha_Patel7-May-19 18:20 
AnswerRe: What is an alias? Pin
Richard MacCutchan7-May-19 21:23
protectorRichard MacCutchan7-May-19 21:23 
QuestionHow can you get the alternate records from the table in the SQL? Pin
Shraddha_Patel30-Apr-19 22:53
memberShraddha_Patel30-Apr-19 22:53 
AnswerRe: How can you get the alternate records from the table in the SQL? Pin
Richard MacCutchan30-Apr-19 23:07
protectorRichard MacCutchan30-Apr-19 23:07 
AnswerRe: How can you get the alternate records from the table in the SQL? Pin
CHill601-May-19 5:05
protectorCHill601-May-19 5:05 
AnswerRe: How can you get the alternate records from the table in the SQL? Pin
Santosh kumar Pithani4-May-19 2:31
professionalSantosh kumar Pithani4-May-19 2:31 
GeneralRe: How can you get the alternate records from the table in the SQL? Pin
CHill6014-May-19 2:30
protectorCHill6014-May-19 2:30 
SuggestionRe: How can you get the alternate records from the table in the SQL? Pin
Richard Deeming14-May-19 2:38
mveRichard Deeming14-May-19 2:38 
GeneralRe: How can you get the alternate records from the table in the SQL? Pin
CHill6015-May-19 2:36
protectorCHill6015-May-19 2:36 
JokeRe: How can you get the alternate records from the table in the SQL? Pin
Richard Deeming15-May-19 6:51
mveRichard Deeming15-May-19 6:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Cookies | Terms of Service
Web05 | 2.8.190518.1 | Last Updated 20 May 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid