I'm currently using AWS Athena and I'm looking to convert a string field 'YYYYMM' to date (i.e '202208' to 2022-08-dd) and define the date (dd) as the last day in that month. I would first convert the string to date…
I have small web/mail server with apache/mariadb. Last week we changed some of the WWW code and to make it work I changed in php.ini line : max_input_vars to 5000 (now 4000, it was 1000 at the start) And it…
It is possible to list all values in n number of tables having same structure? Table: insert into t2 values(1,sam); insert into t2 values(2,tony); . . insert into tn values(1,jim); Output: 1 max 1 sam 2 tony . . 1…
I'm sure this is a bit dumb, but I'm very very beginner in MySQL so here I go. I have a table Items with id (primary key), category_id (index) and some more columns. One of the categories (category_id = 5)…
Using MySQL 5.7, I have a table of urls containing url_title, url_description, url_keywords Sometimes I just need to look in url_title, but sometimes look for something in all columns. Is it better to just create one index containing all 3…
I am trying to finish my graduation project which is a desktop application for database transfer. The application was made by C# WPF. I want to introduce a feature in the application which is Quality Assurance, and it should be…
using a MVC model to try and fetch from a mySQL db. The code tries to query db and put the results into and array to pass it to the controller. The jsp page can then call it. At the…
I am basically trying to select data from the backend mysql database based on the input gathered in a previous drop down. However, I am not able to get this working. Looks like I am missing something, but unable to…
I'm not sure what is happening or why this is happening so hopefully someone can give me tips on how to debug or where to look. I have 2 docker containers, 1 for phpmyadmin and another for mysql. The phpmyadmin…
I want to duplicate a specific teacher so that they appear twice in the output of a SELECT statement. Teacher Grade District Mr. Smith 3rd West Mrs. John 4th South Mr. Cameron 2nd North Mr. Cameron 2nd North Kirk Horn…