I want to generate unique keys at run time across regions and the key generation will be owned by master region. I will have one table with one column(key) with
I'm a node beginner. Following is the code that I'm trying to execute using node mysql but it keeps giving me this error: error connecting: Error: ER_CON_COUNT
I have a website, which sends input data with AJAX via a PHP script to a MySQL database. The JavaScript/AJAX part is working but the PHP script doesn't get exec
I am running a crm application which uses mysql database. My application generating lots of data in mysql. Now i want to give my customer a reporting section wh
I have 2 tables. One table listing results of a run and a 2nd table with timestamps. table1 (not sure how to add another column to the table but table 1 has an
I am working on a project that has a FORM which should VALIDATE itself and then submit the data to the MySQL Database. But I am facing an error. This is the f
I would like to know how to handle this error error "#1044 - Access denied for user 'root'@'localhost' to database 'information_schema' " in order to delete a t
Consider me as laravel beginner The goal is: I have two colums, now I need the id to be prefixed with the component name of same row in the table. For Exampl
My database contains below table in parent child relationships:- Gender->Audit->Request(All are in 1:N Relationships) I want to fetch all Genders with cor
I am trying to connect my login page so that it fetches data from my users table in mysql and logs the user in but I am having some problems with my code Futu
I have build a Todo App with create-react-app. The store I'm using is based on Local Storage(JS attribute of object window). Now I created a MySQL databases and
I have made a web application with php and mysql in wamp server. Now i want to convert it into desktop application for windows platform which will run offline a
This is my php code of inserting data in mysql and displaying sweetalert after insertion but the sweetalert is not displayed. <?php if(isset($_POS
I am working on making a login section for my project website using PHP, but for some reason, verify_password won't return true, even when I am giving the corre
I want to export my database from phpMyAdmin to import it to another server. I go through the steps explained here and here but all I get is a 50kb .sql file th
I would like to have a database connection managing class which I can use for simple SQL commands like SELECT, INSERT etc. by simple calling something like this
When ordering things by Alphabetical Order, I'm left with this: S1 Episode 1 S1 Episode 11 S1 Episode 12 S1 Episode 2 S1 Episode 3 S2 Episod
I've improved my code a lot over the past few days but I'm finally stuck. My query is returning "unknown". I've attached the code and a screenshot of the databa
I have downloaded mysql ZIP from here https://dev.mysql.com/downloads/file/?id=467269 Then extracted it, renamed my-default.ini to my.ini, set basedir = D:\A
I'm trying to create an aggregated function MEDIAN() in MySQL like MIN(), MAX(), AVG() which takes the input the column name or string that has concatenated val