MySQL Script for find finding missing entry from a specific group and then enter the missing row on that group
I have one table ClockIn which is as follows:
database
What should the Length/Value be for “DATE” data type in mysql?
I looked for the answer to this question before posting this but I couldn’t find it. I’m sorry if it has been asked before but I would like to know what I should enter for the Length/Value for “DATE” in mysql.
How to automate selection of a column from multiple tables
I have several tables at least 26 … i’m trying to select a column from all tables and displaying them as one
Laravel eloquent count total of participants that belongs to departments of one specific event
My current query can count the number of participants that belongs to each department:
how to add data in a mysql table
so i was creating a menu option where user enters some data and using a function all of that data is added to a MySQL table however the data table is not being updated properly
I have checked there is nothing wrong with the table created so I think the problem lies in the code somewhere
Is there any security vulnerabilities in running a local python file with a connection string to a database?
So I’ve been scowering the web for an answer, but haven’t found one that quite satisfies my curiosity/anxiety. I’m running a python script to insert data from a collection of XL files into a database. Is there any possibility of security breaches while running the script locally? I think my hesitation is derived from having to hard code the password into the connection string. Any insights would be much appreciated!
How to save html code with if condition in database
I have a rating field in the database. If the value of $rating>0, the button should be disabled otherwise button should be enabled.I am saving the HTML code to database to dispaly. What I have tried is : $user_notification->notification ="Delivery date <b>" .$date."</b> and delivery time <b> ".$time." </b> for the truck " .$truck_name. " … Read more
See how many rows have been added to MySQL from the beginning to now (even deleted rows)
I have a python code and a table that add a row and delete it after a few minutes.
I need to see how many row have been added from the beginning until now.
mid((user)from(-1)) meaning in mysql. what does from(-1) mean?
what does the following query mean in mysql?
What is the best way to store big data per user?
I just need some advice about what database should I use, and how should I store my data. Namely I need to store big chunk of data per user, I was thinking about storing everything in JSON data, but I thought that I could ask you first. So I am using Django, and for now … Read more
