Tag: database

How to insert data from one table to another in laravel?

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 new rows won’t be reflected

MySQL get attribute which is not present for all possible values of another attribute

database mysql sql

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’

database mariadb sql

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

database mysql php sql

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:39 01190301 2021-02-06 14:37:08 01190301 2021-02-06 07:57:42 01190301 2021-02-05 17:29:00 01190301 2021-02-05 08:09:54 01190301

How do I create an automated calculated column?

database sql sql-server

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 changes. Answer Use Inserted table inside the Trigger to find the recently

How to insert into a SQL table column using SELECT query?

database join sql sql-server

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

database mysql phpmyadmin sql

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 after is