I have a Magento shop (using MySql db) and just noticed that some developer introduced a custom db for capturing some structured data. Now I noticed that the tables are not linked via foreign keys with each other, but just…
I want to export all databases as separate .sql files but I get localhost.sql Can anyone here show me how we can accomplish this?
I am trying to insert some data with node.js. I installed MySQL support via npm, but It still seems to fail to input the right strings with INSERT INTO. (the row types in the database are tinytext and the strings…
Here i am again. Thank you so much for help. Here is my Old question on how i can select and display the grade of student in a junction table. Select and display all rows belonging to a specific ID…
I have Table student, student_subject and subject_bsit "student" ----------------------- |studentID | FullName | ----------------------- |1234 | John | |1235 | Michael | |1236 | Bryce | "subject_bsit" ----------------------------------- |subject_id| subject_name |grade | ----------------------------------- | 1 | Programming | 3 |…
I hosted Apache server with xampp and created local MYSQL database on my PC1. PC1 IS CONNECTED TO NETWORK1. I developed simple Java program which is connecting to the database this way: static final String USERNAME="[myusername]"; static final String PASSWORD="[password]";…
I have a table of records of wildlife sightings for different animals. Each row in the table is a record card containing columns for the different animals that it is possible to see, plus an ID column and a DateSeen…
Good Afternoon: I'm a chemistry teacher from Spain. I am not an experimented programmer, but I decided to create a small program to help my students with my subject. I am creating this small program in Java where I'm trying…
I am making a gallery website. I learnt from tutorials how to do each parts but i don't know if i should make different tables for user information / their profile pictures / and photos added to gallery by users.…
I have this input box on my form: <td contenteditable="true" class="date"></td> and I'm trying to add a date dropdown to it so what I did was: <td contenteditable="true" class="date"><input type="date"></td> And now when I hit send it won't save to…