I have a table (datas): line account name email 1 1000 Reyes VonRueden Sr. [email protected] 1 1000 Dr. Elena Bartell V 1 1000 Lucio Wehner 2 1000 April Hansen 2 1000 Amy Waelchi [email protected] 2 1000 Tremaine Cassin 3 1000…
I have an archive table in which only the changes to a record are stored with a validity date. An example would be a price archive for products. And if you now want to select the status at a given…
I have Database table called tbl_emails like this id email 1 [email protected] 2 [email protected] 3 [email protected] 4 [email protected] 5 [email protected] 6 [email protected] 7 [email protected] 8 [email protected] 9 [email protected] 10 [email protected] I have about 5000 rows in the table. Now What…
I have this table: @Entity @Table(name = "t_tropical", uniqueConstraints = @UniqueConstraint(columnNames = { "name", "sign", "isRetro", "house", "lang"})) @Getter @Setter @AllArgsConstructor @NoArgsConstructor @Builder @ToString public class Tropical { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String name; private String…
i wanna get the reservations that their status aren't canceled or if status is canceled it check they have unread messages or not Can you help me? class Reservation extends Model { public function unreadMessages() { return $this->hasMany(Message::class, 'reservation_id', 'id')…
I have 2 tables. A Users table and a Token table. I am trying to join these tables to see who has verified their tokens and who hasn't. The token table has a foreign key with the user id in…
I have a form that submits author, context and images (recently added) in Angular. When I output the data sent over, I was able to get author and context, however I cannot get images (it always display null). === SpringBoot…
I'm trying to get all of a users completed habits, although I'm getting a syntax issue when using eloquent? What's going on here... syntax seems fine to me. Query: $completedHabits = Habit::query() ->where('user_id', auth()->user()->id) ->join('habit_goals', 'habits.id', '=', 'habit_goals.habit_id') ->whereHas('progressLogs', function($q)…
This is a pretty simple sql command: start transaction; insert into new_data(textvalue) values ("data1"); insert into new_data(brak) values ("data2"); commit; so the table new_data only has a field called "textvalue". "brak" doesn't exist. I think because I declare "start transaction"…
I following a tutorial and had this problem, but seems like it was only me.. Everytime i'm trying to run this i have the same output. Please help im trying to connecting backend to the database This is my server.js…