I have multiple tables inside my database: Is there a way to keep the columns of all the tables in sync with each other? What I mean is that when I add a new column named ‘last-edit’ inside the first table, this column will duplicate to all the other tables. But the data inside the columns will o…
Tag: phpmyadmin
Error => #1242 – Subquery returns more than 1 row
I am selecting order data from my orders table with that I also need the order product’s count which contains a specific word Account TopUp 200, Account TopUp 500, Account TopUp 1000, The order contain multiple product means one order contains both(Account TopUp 200, Account TopUp 500) and other product…
I can’t get the correct output when I use / ORDER BY from my SQL example?
I was playing around SQL sample that I wrote and I’m quite surprised that I couldn’t get the correct output when I use less than, greater than or ORDER BY. for example, select player_name, jersey_number from Players order by ‘jersey_number’ desc; it should give players name and jersey …
Node.js rounds my sql result. how do i prevent this?
I am requesting a bigint from my database. However, Node.js alters the value of my request, so that my program doesn’t work. Here’s my code: The console logs: However, if i run the same statement in PHPmyAdmin, it looks like the following: it returns: Why does Node.JS round the value up and how do…
SQL: set trigger to get the sum of rows
This is the results table: I want to create a trigger that will sum up the rows get_ca1 + get_ca2 …+ get_exam and store the total in the get_total column. When the rows get_ca1, get_ca2,… get_exam are inserted, the trigger should calculate the total and store in the get_total column. I just learnt…
Insert selected columns from one table to another SQL
I have two separate databases in the same host (localhost:3306). I have one table from the first database and a second from the other database. Here is 2 screenshots to become more clear I need to match: Is there any automatic way with a software? Need I to write some specific query to copy these 4 columns fr…
Update user id by looking up two other tables
I have a table/sql issue I don’t know how to solve. I need to update/create a table of user ids with order ids. Therefore I have to get a new user_id, by searching for the email in an old list. With the email adress I need to look up the new user id. So the logic is like: order_id ->
How to not have time be a bind parameter in SQL, but have a parameter be bound?
I wish to select orders from after 23:00:00 but have a prompt for date selection, but when I use bind parameters the time is recognised as a parameter for binding since it contains “:”, what is a workaround for this? I need just OrderDate to be a bind parameter. Screenshot showing bind parameters …
Php – cannot create new database record because primary key is null (autoincrement)
There are two tables: address and person. person_id (primary key, autoincrement) is a foreign key to address. I am trying to add an address record and person record from the same form but am getting this error. Uncaught Error: Attempt to assign property “person_id” on null in C:xampphtdocsappcontr…
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…