Post has attachment
How to Install MariaDB on CentOS ? #javaTpoint
http://bit.ly/2BKZhNF

#InstallationonCentOS_#Programming_
#DevelopmentTools_#Database_#InstallMariaDB

Post has attachment
New MySQL GUI tool is out!
It comes with a new Enterprise edition, brand new exclusive functionality, including Copy Databases, Data Generator, and Database Documenter, updated and improved Data Import/Export, Data Comparison, Database Backup and Data Export, SQL Document features as well as introduced new connectivity possibilities, trial product activation, and much more.
To check out all the details and to try it over the next 30 days for free, go to 👉 https://goo.gl/xEXgCy
Company News
Company News
devart.com

Post has attachment

Post has attachment

Post has attachment
Our latest webinar, “Using MySQL Fabric for High Availability and Scaling Out”, will take place on June 29. DBA and DB developers, system admins, and more: register now and get ready to use MySQL Fabric for high-availability, improved sharding, and more! http://bit.ly/1PyTu03 #mysqlfabric
Photo

Post has attachment
HTML5 Tutorials - 4 - Part 1 - Audio Element in HTML5,Attributes of Audio Element,Web Development
https://youtu.be/FOLKPci1oc0

#Worldfreeapps #WorldfreeappsYouTube #YouTube #HTML #HTML5 #Tutorial #Audio #Elements #Web #Development #WebDevelopment #GaneshBagaria

Post has attachment

Post has attachment
MySQL Tutorial, insert into table
https://youtu.be/NCe6BSdDBfI

Post has shared content
Download the #WFAFlashlight App
From here: https://goo.gl/7fYI6Y
In which you can turn your smartphone into a flashlight with blinking effects
Developed by Ganesh Bagaria
And share it

Need to make a Comparable between the records of this table and take the total times the value calledstationid 42 preceded the value 34 (this is a system log table and calledstationid is not an auto-increment field).
I created this query but it presents some problems:

SELECT COUNT(*) FROM (
SELECT h.acctstarttime, h.acctstoptime, h.radacctid, h.calledstationid, ( SELECT MAX(sub.calledstationid) FROM radius.radacct_historical as sub WHERE sub.callingstationid = '54:9F:13:27:31:7F' AND sub.acctstarttime < h.acctstarttime ) as previous, h.callingstationid CASE WHEN h.calledstationid = 34 AND previous = 42 THEN 'yes' END AS goal FROM radius.radacct_historical AS h WHERE h.callingstationid = '54:9F:13:27:31:7F' ORDER BY h.acctstarttime ASC;
) as total WHERE goal = 'yes'

First problem:

SELECT h.acctstarttime, h.acctstoptime, h.radacctid, h.calledstationid, ( SELECT MAX(sub.calledstationid) FROM radius.radacct_historical as sub WHERE sub.callingstationid = '54:9F:13:27:31:7F' AND sub.acctstarttime < h.acctstarttime ) as previous,

The previous calledstationid is not returned properly, I get the correct value only in the first 2 results thereafter it seems that MySQL stores the value of the result in memory and does not update the subquery

Second problem:
CASE WHEN h.calledstationid = 34 AND previous = 42 THEN 'yes' END AS goal

The case does not identify who the previous in the query.

Does anyone have any light on how to do this?
http://www.sqlfiddle.com/#!2/774ff/42/1
Wait while more posts are being loaded