mysql | Development repository for the mysql cookbook | Infrastructure Automation library

I have a column in mysql which stores a column with json files and the the key of the json can contain any unicode characters. I have a query to calculate the cardinality of the specific key

I have been struggling with this error for quite sometimes and I am wondering if someone could help me get this running

I have

So I created a poll model in my Django app. I'm going thorugh the polling app tutorial posted on the Django website, however, I'm using a remote MySQL database rather than a SQLite database.

Given MySQL tables something like this¹:

First migration file:

I've created a simple VBA interface to connect Excel to a MySQL DB. The VBA part acts as a preview of data for the user to choose what item he wants to import to the Excel sheet.

Until now I've work with a very complete set of data, but I got to a Table which (because of the nature of the items) some fields are NULL.

Now every time I try to check the values in the VBA I get the Run-time error 13 Type mismatch in the listview component. At first I though it was a field with DECIMAL typing, but after changing it to a DOUBLE (for testing) the problem persisted, and it was until I notice that if only checks columns with no NULL value, the problem disappears. Off course I can't omit this values.

I tried some .Tostring functions but with no success. And I failed to implement a IF to check for NULL in the obj.

This is my code:

Dataset looks like this : This is a sample dataset for number of employee login activity named - activity

I need to calculate few metrics, was able to do in python data frames, but new in mySQL.

1. what is the average number of employee active per day for month of jan 2018 by dept ( was able to do somewhat half of it, but results coming are not correct.

2. number of unique active employee (login >0) per month for jan 2018 for each dept_id (was able to do it)

3. month over month growth for all dept_id from dec-2017 to jan 2018 where at least one employee was active (login >0) - no idea how to do this in sql

4. fraction of users who were active in each dept_id for dec 2017 and were also active in the same dept_id for jan 2018

5. how many employee login in on 3 or more consecutive days in jan 2018

Any help would be appreciated.

Query written for case 1:

Hi am trying to do a CRUD application am able to do the add user but i got stock with the edit user Actually for my edit user page i just copied the add user page there and then modified it

This is what my app has to do: normally when i enter the edit user page it has to show me the user's existing information then on my part i can now modify it if i wish and then it is stored in my mysql database but it doesn't return anything i actually console logged it to see if it returns anything but it doesn't

I am using express-session and express-mysql-session in my app to generate sessions and store them in mysql database. Sessions are stored in a table called sessions.