so i have this tables with their own attributes BOOK TABLE BOOKSHELF TABLE STORE TABLE LOCATION TABLE id_book id_bookshelf id_store id_location name name_bookshelf name_store name_location author id_store id_location id_bookshelf And i wanna show this kind of table TABLE_EXAMPLE id_store name_store…
As far as I know, Spark executors handle many tasks at the same time to guarantee processing data parallelly.Here comes the question. When connecting to external data storage,say mysql,how many tasks are there to finishi this job?In other words,are multiple…
This the example of the table name is merchant_point_log : id created_date merchant_id point_value recent_point status 1 2022-01-02 1 5000 5000 earn 2 2022-01-02 2 3000 3000 earn 3 2022-01-02 1 3000 3000 redeem i would like to show logging…
I swear I tried everything I could but with no success, I read every answer in the whole platform but I can't get rid of duplicates (or loop repetitions) My tables are: items item_id (primary, AI, unique), it_title, etc. (the…
I have a purchase table and user_id is a foreign key. If there is user_id in the purchase table, it returns 1, I want to return 0 if there is none. I tried using the case statement, but it returns…
I have a MySQL table with floats in it. In PHPMyAdmin, they're listed as e.g. "55.123" I used to pull them out using $sql = "SELECT latitude,longitude FROM table WHERE id=" . $id; $conn->query($sql); When I print my floats, I…
Low-level MySQL question for you: we are storing UUIDs as bin(16) in the DB and are using them as a primary key. We are in the process of changing the UUID stored to time-based. We want to optimize clustered index…
More detailed question. I have a table called CALCS with the structure: code is the record identifier (not unique) value1, value2, value3,value4 are different values to sum price is the cost of work I must return price+value1+value2+value3+value4 for all records.…
Hello, I have an adminController as below. Even though I checked the status box, it comes to the database as zero. I can't figure out why if/else block doesn't work. If I use debug i can see "on" value for…
I have a column in my database table where the default needs to be 'int 0' but also null can be provided due to legacy. I have attached a picture to show what I am trying to do. The problem…