I'm trying to create a quiz app with a database with two tables one for topics and one for the questions. The topicsID is a Foreign key in my questions table. I want to retrieve 2 random questions from each…
How to make them access the same database? I have a web and mobile application and I need them to access the msm sql file to do the crud the problem is that one of them I stored in godaddy…
I have a table in which the id is constantly increasing. The Id does not always increase by the same value and it is not an auto_increment due to a api, but it increases permanently. Example: Id other content 501…
i run this query on phpmyadmin database table working fine: select substring_index( prefix, '.', 3 ) as subip , count(prefix) as count, prefix from prefixes GROUP BY INET_ATON(subip)/256 order by cidr desc when i run raw query in laravel: $selected_prefixes…
I am storing STARTTIME and ENDTIME in a SQL Server table by using ASP.NET webform. timeTableID startTimeVal endTimeVal ------------------------------------------------- 1 07:30:00.0000000 08:00:00.0000000 2 08:00:00.0000000 08:30:00.0000000 3 08:15:00.0000000 08:25:00.0000000 Now, as you can see in the row with timeTableID = 2,…
My SQL query is not working. Below is my code and note that in that table query worked fine and gives output. But in PHP by using mysqli_num_rows(), mysqli_fetch_assoc() and mysqli_fetch_array() all doesn't works for me. My DB connection is…
I have a SQL Server table that has approximately 2 million rows. Let's say the table is called Students. If I query a database from SQL Server Management Studio: SELECT * FROM Students At the same time, the currently loaded…
I have an ASP.net Web API that inserts data from the user after they purchase a product in a Xamarin Application I am currently developing. However, data can also be inserted by simply calling the URL on a web browser…
There are 3 tables in SQL Server with large amount of data, each table contains about 100000 rows. There is one SQL to fetch rows from the three tables. Its performance is very bad. WITH t1 AS ( SELECT LeadId,…
I'm trying to connect to a Azure SQL Server database, from my Blazor app running inside a Docker container. Since I have the DB configs inside Azure Vault, I'm launching docker with env parameters (tenantId, clientId, clientSecret) and that's working…