Could you help me to calculate proportion of Table user_id attendance Date 1 1 01.01.2018 2 Null 01.01.2018 3 1 02.01.2018 4 …
Tag: database
Get list of SQL server databases which files have been deleted
My goal is getting list of SQL server databases which files have been deleted. In other words. I attach a db from mount, then close the mount so actually I have the attached db without files. At …
php query function repeating data
I am trying to make a facebook style chat page using php and mysql. But i have a problem with my query result. The chat table looks like this. And i write this function for getting the message for …
Update a field in a JSON column in PostgreSQL
I have a work_item table that has the following schema and a document_type table with the following schema: The data column is a json column that has a Type field. This is a sample column data: I need to update data columns whose data_type column value is DocumentModel and Type field values matches a value in…
Calculate time difference between two columns of string type in hive without changing the data type string
I am trying to calculate the time difference between two columns of a row which are of string data type. If the time difference between them is less than 2 hours then select the first column of that row else if the time difference is greater than 2 hours then select the second column of that row. It can be
Can somebody give a practical example of a many to many relationship?
I learned about many-to-many relationships in College, and I never really understood them. So far I’ve been working with one-to-many relationships which are easy to understand and deal with. Can somebody please give a practical example of a many-to-many relationship, and explain why we need a bridging t…
Copying tables from one database to another, in Firebird 2.1
I need to copy tables from one database to another in Firebird 2.1, but in some way which is pretty quick and you can run this on console. I used FBcopy but get the answer from boss that it is too slow. This must be done in more than one transaction because tables are quite big. Any ideas how I
MySQL 8 create new user with password not working
I am using MySQL for several years and the command for the creating the new user till the MySQL 5.x version is as follow: Recently I installed the MySQL 8. In that, this command is not working. It is throwing following error while firing above command: Is there any change of syntax in MySQL 8? What is the cor…
Suggestion for a contact management database design
I am currently designing a contact management database for a chamber of commerce. The goal of the database is to store all the person (except our own staff), all recorded companies (regular companies and member of the chamber), addresses of the person and companies, tasks that the staff are currently responsi…
Creating data entry form using button VBA
I am trying to create a basic data entry form, however, it is turning into more trouble than I anticipated.. I have the form created, now I am just trying to INSERT the data into the DB (TEST). I am receiving an “Object Required” error. Any suggestions? All of the txt boxes are verified to be corr…