Lets start with a basic SQL statement like this: SELECT CustomerName, City, Country FROM Customers; We get something like this: CustomerName City Country Alex
I want to create a license system for my codes in python. Now I am facing an issue: how can I check if an integer is contained in my MySQL database? Here are so
I am making an interactive Shiny dashboard with typical "drill-down" capability. There are hundreds of thousands of links in the database. I am working on takin
The tables should be linked mainly towards the employee table. Is this fine? I need to make connection to employee using foreign keys. Is it good practice to h
I was asked to implement an in memory cache mechanism in my spring boot application. My application is related to social media. User can register and login User
I made a many-to-many relationship in laravel, where users can make announcements on an event. The problem is that I want to retrieve the announcement message f
I have a question. I made this procedure, and I am curious if I can make it to return more than 1 output. Let me know if you need the tables, but the code is wo
DB Fiddle: https://www.db-fiddle.com/f/u1N4YYV3wmiWndnZNb95xz/5 For the following tables nodes and leaves, with nodes having just 9 records and leaves having a
I have a local docker environment (MAC) for my Laravel set-up. The mariadb container in docker-compose.yml is defined as image: mariadb:10.6 container_n
I'm trying to have one docker container with: ubuntu 20.04, on top of which I add apache, php, mysql and phpmyadmin (all on the same container) What's installed
Environment: MySQL Server 8.0, .NET Core 3.1, MySql.Data 8.0.28, NHibernate 5.3.11 I have following table: CREATE TABLE `Master` ( `Row_Id` char(36) NOT NULL
I've been trying to filter the data for the last X number of days. All these columns work as standalone results when I remove the time filter from the where cla
I have following two tables: comments comment_post_ID status comment_type 1 complete course_status 2 complete course_status a1 complete lesson_status a2 passed
I want to sort the results of MySQL based on the best match by using collate query => zeķ want to show Vīriešu zeķes Sieviešu
I create login for user in home page if user click on login then the login page is display there user enter email id and password if email id and password is co
I'm successfully uploading some files to a folder and saving the path in table. If I display the file's path in an html table, hovering over it, the address on
Hello to everyone who is viewing this question. I am currently running a web-application server, which only does CRUD operation (using MySQL) for android and iO
I have 2 tables that I want to join. They both have a uuid field and a text name field. Besides that they have no connection, The end result I wish to achieve i
There is a mariadb version 10.7 instance running in Kubernetes. Recently log-bin was added to the server.cnf. The restore scripts stopped working for any databa
I'm very confused, i try to find what's wrong but i don't find it.. In my SQL Database i've 'posts' table created all my code are related with 'posts' table and