I have two tables, visitors and in. visitors contains columns, Name, Number, Purpose, and Datetime. in contains Name, Number, and InTime. I want to fetch all the values from the visitors table into in. I have tried copying the data from visitors to in, however, if I add new rows into the visitors table, those…
Tag: database
MySQL get attribute which is not present for all possible values of another attribute
Assume there is a table with columns fieldA and fieldB (Primary Key:fieldA, fieldB). A program keeps inserting entries to this table with the same fieldA value, say constant_for_A, and some arbitrary …
i cant view all data when i using Datepicker on ‘WHERE’
hy, please help me,, i cant view all data from emp0003 to checking all employee absence.. emp0003 table NIK Name 01190301 Susan 01190302 Jamed dvc0004 table’s NIK Enroll 01190301 2021-02-03 08:…
How to count “Sunday” of the month to count absent employees
I have a problem calculating employee absenteeism in a month. In my query it still counts the day of the ‘sunday’ in this month, which shouldn’t count. This is an sample database used : emp0003 table’s NIK Name 01190301 Susan dvc0004 table’s NIK Enroll 01190301 2021-02-08 07:20:3…
How do I create an automated calculated column?
Help me create a column, that shows the company’s budget. Let’s say we have three tables: Budget, Purchase, and Sale. When we selling products, the budget increases, when buying raw materials, it decreases. That is, automatically when you add a value to these tables, the budget value immediately c…
How to insert into a SQL table column using SELECT query?
I have tables A, B, and C. I want to insert UserRoleName values in table C, into UserRoleName column in table A for the corresponding UserId. UserId in Table A, is a foreign key from Table B. UserRoleId is a foreign key in table B from table C. How can I do that? I tried using this query, But this
How to mirror auto increment value and combine with value in another column in mysql
I have an auto increment column id in a table, this works fine but I am trying to create an order_id column that combines the account_id of a user with the auto increment value of id. So the values inside order_id look for example like this: Where the number before the dot is the account_id and the number aft…
Should the column used to order results be included in the index of a postgresql table?
I am creating indexes for a PostgreSQL database. I would like to know whether the column(s) used to order results in a PostgreSQL statement should be included in the index. Assume I have created a …
SQL Query Inactive Users with last end date
This is a follow up from a question I asked about a year ago Old thread The answers I got then have worked fine but now I discovered that I need to tweak the query to be able to get the latest end …
Ask a SQL about “ select … join … ”
There are two tables. Table A : id name 1 nameX 2 nameY Table B : id aId name 1 2 Foo 2 2 Bar Ask a SQL: when search ‘nameY’, get A.id A.name B.id B.aId B.name 2 nameY when search ‘Bar’, …