MySQL

What i'm trying to do is have a scheduled event run in MySQL every dayThe task sounds simple

I insert map coordinates from a txt file into my databaseMy table:

I have a MySQL db to store some equipment IP address, vendors and service status with the following structure (simplified for illustration):

I am using WordPress and my Control-Panel allows me to use phpMyAdmin to access my MySQL database

I am designing a website where beekeepers can register there shop details to a website and after they have registered their info to the database, they are logged in then redirected to the account management page where they can change their details if they want

I need to post data into a database using SQL and PHPIt is for a school project btw

I am trying to use COALESCE() to get the lowest non NULL date with a default to NOW() from the following table:

I am changing the encoding of all my tables from latin1 to utf8mb4 using a rails rake task

I'm trying to wrap my head around functions in mySQL and I'm currently making one that checks the column account_description and it's value to see if the description already exists

I worked through the Mode SQL tutorial (link)The tutorial states that it teaches a student how to query a MySQL database

I am using Django 20

I´m making differents queries for the same goal in order to get the most efficient query

I have a problem deploying a system on the server for free 000webhostappcom

I am new to PHP and MySQL and so please help me kindly to knowI want to create a search engine in my website that searches in the MySQL database, but I have problem

A leader may have many followersA notification_followers table gets a single notification when a leader adds a post with an entry leader_id 1 and notifiable_id 0 (id 1,2 in table)

I have a table with IP accounting data,

I'm trying to display my database's record in a table using php, but the table show with no dataI tried to copy the code from w3school to avoid making any errors

I am new to MySql and I am trying to print out a nice text file that would show the structure only (no Data) of my tables and columns withinIs this possible? If so please instruct - thanks!

I have been trying to change display property in Javascript by getting a variable from PHPI could send a variable to PHP with Ajax but I coudnt do it same vica versa

I tried to connect on remote server with a ssh tunnel in order to access to a database

I have a table customersHow can I select only ids for the distinct values in the email column?

I' like to have a small explanation about Flask, Something I don't understandI'm looking to get DATA from Database by an ID

i am trying to select data from to table bast on column on thes tow table but i get duplicating data

Have 3 tables that I have linked to together one filed is cable type and I would like to get a total by cable type, "bdbuss_cable"