Isn't displaying information which I select from database in mysql php

Hello i am trying to find out what the value is in the database (this is like a level system and depending on the level in the database then decides if you have access to the page) so what i am try

View details »

Retriving data from mysql db

Hi bros am working for an api for retriving data from(mysql) three tables with in one call and those three tables are not having any relation like how can I do that. Can anyone help me

View details »

Formatting string as date with leading zeros when needed T-SQL

I am trying to convert a string to date. The field is either 5 or 6 characters, depending on what month it is. Sample data from the field is as follows: 20185, 20186, 20187, 20188, 20189, 201810, 2

View details »

Determine SQL String Equivalence from C#

I have a C# program that is reading data from a file, then inserting unique strings into a SQL table (via System.Data.SqlClient). The problem is that SQL considers certain strings to be equivalent

View details »

No error, but unable to insert row in a table

Hi I have been working on a flask web app, It has many tables with relation among themselves. One table is users_email. +---------+------------------+ | user_id | email | +---------+----

View details »

Save sql query in table and add dinamically where clauses

this is not exactly a code problem but I need some advice to know which would be the best way to achieve this. I have an application where I have to save bit queries in a table from a database(yes,

View details »

mysqli_query only returning results when there's a WHERE statement

MySQL query is only showing information if I have a condition in the SQL statement. I've successfully used the SQL statement in phpmyadmin and it works great. I've changed the table name in the PHP

View details »

How to select count today and tomorrow data less than specific time group by day?

I have a table like a table below. I want to select count and group by day. But the data in 1 day will start counts at 7:00:00 until tomorrow at 6:59:59 (24hr.). For example Day 1 data between '

View details »

How can I Insert several columns from one table to another having only 1 column unique/distinct?

I am trying to create a star schema and am currently working on the dimension tables. I want to copy several columns from one table to another but at the same time I want to make the result values u

View details »

Using CDC tables to create DB state as on a previous date

I have a complex data model consisting of 100s of tables. I have CDC enabled for all tables and have that data in corresod nponding CDC tables. I need a generic mechanism whereby given a arbitrary S

View details »

PostgreSQL hiding some parts of result

I have the following table/column Table: VENDORS Column: vendor_records varchar(5000) In same cases, using basically: select vendor_records from vendors; The postgres hide same parts of return

View details »

Update multiples rows with different ID at the same time

is it possible to do something like this? update table set field ='text' where ID=1 and ID=3 and ID=5 I executed it but no row is updated.

View details »

How can i rewrite this sql script without using exists

I am new to sql. How can i rewrite the below script without using exists select distinct oe.*, o.*, so.* ,ro.* from ms_bvoip_order_extension oe inner join ms_order o on oe.ms_order_id = o.ms_order

View details »

EF Core DbContext not setting up my Models correctly for my DB schema

I have a Project entity that has a list property for a List<ProjectFileBucket> which is another Entity that contains a ProjectId and a list property for a List<ProjectFileBucketFiles> which is just

View details »

inserting an array into table via direct SQL injection using VBA

There is an SQL error 3134 syntax error when trying to insert these arrays into the data table in Microsoft access 2016. I am unsure if it is due to the fact that they are arrays or if it is due to

View details »

Password_resets table missing, even after doing php artisan migrate

I am trying to do password recovery in laravel, but after inserting an email to send the reset request, an error appears saying that password_resets doesn't exist. I've already tried to migrate aga

View details »

How to partition records of same key in a specific span and count the number of these partitions in sql?

Chrome History SQlite 3 database has the urls table like this: CREATE TABLE "urls"( id INTEGER PRIMARY KEY AUTOINCREMENT, url LONGVARCHAR, title LONGVARCHAR, visit_count INTEGER DEFAULT 0

View details »

SQL - Assess minimum value across multiple rows, then filter to show list of unique rows?

My end goal is to create a list of honor roll students. Each student has multiple rows, one for each grade. I want to say, look at their grades across these rows; only show 1 student name if none of

View details »

Connecting to sybase using pyodbc

I am trying to connect to Sybase Database (Adaptive Server Enterprise/15.7) using pyodbc. I am trying to connect using FreeTDS (assuming) it has support for MSQL Server and Sybase, but I do not have

View details »