Hi!
SQL Maestro Group announces the release of PHP Generator for MySQL
15.12, a powerful GUI frontend for Windows that allows you to generate
feature-rich CRUD web applications for your MySQL database.
http://www.sqlmaestro.com/products/mysql/phpgenerator/
Online demo:
I need help creating a select that returns 4 records that have
contiguous addresses that start on a bit boundary.
If 4 do not exist, I need a return of zero records.
I would like to do this in one statement and I do not have ownership of
this mysql server, so fancy views, temporary tables,
Hey gang,
I need the ability to produce this end result:
condition a) All clients who have had at least 2 appointments in the last 24
months
condition b) but have NO appointments in the last 6 months
I am able to get the clients with >= 2 appointments with this query
SELECT
c.client_id,
I should have said consecutive addresses, rather than contiguous.
I care about a set of consecutive addresses, and there is no guarantee
of record order.
On 12/17/2015 07:35 AM, John Stile wrote:
> I need help creating a select that returns 4 records that have
> contiguous addresses that start on
Hey gang,
I need the ability to produce this end result:
condition a) All clients who have had at least 2 appointments in the last 24
months
condition b) of the set of “condition a” rows, which of those have NO
appointments in the last 6 months
I am able to get the clients with >= 2
Hi Don,
On 17.12.15 16.14, Don Wieland wrote:
Hey gang,
I need the ability to produce this end result:
condition a) All clients who have had at least 2 appointments in the last 24
months
condition b) of the set of “condition a” rows, which of those have NO
appointments in the last 6 months
I have a solution.
SELECT start_bit_boundary FROM (
SELECT
min(address) as start_bit_boundary,
status, count(*) as CT
FROM MAC_addresses
WHERE status = 0
GROUP BY address >> 2
) AS _INNER
WHERE
_INNER.CT = 4
ORDER BY start_bit_boundary
LIMIT 0,1;
It returns the first of 4
Hello!
Hereis my mysqldump command line
mysqldump -u root --events --complete-insert --skip-opt
--single-transaction --add-drop-table --add-locks --create-options
--disable-keys --
extended-insert --quick --set-charset --routines --triggers --hex-blob
DB_NAME
But i see tons of Waiting for
