I’m using a free hosting solution for my MySQL database. However, when I try to connect to it through my PHP code it throws me a uncaught PDOException error and my access is denied. I can’t seem to find why the connection is denied as my credentials are correct. I’m using Ionic 2 framework, …
Need a MySQL Query out of this diagram
I’d like a query that shows me the tracks that a user doesn’t have in his playlist. The only parameter I’ll be getting is the username of a user. Is that possible with this diagram? If so, could you …
jsonb LIKE query on nested objects in an array
My JSON data looks like this: given a text “foo” I want to return all the tuples that have this substring. But I cannot figure out how to write the query for the same. I followed this related answer but cannot figure out how to do LIKE. This is what I have working right now: Instead of passing the…
Entity Framework Core “The entity type ‘XXX’ requires a primary key to be defined.”
So I’m currently trying to create a code first migration with Entity Framework Core for a table that displays which lectures the application user has completed. My model looks like this: public class …
Getting column names from a JPA Native Query
I have an administrative console in my web application that allows an admin to perform a custom SQL SELECT query on our database. Underneath, the application is using Hibernate, but these queries are …
no local server type “database engine” were found (V 2016)
I don’t know many things about SQL server, today I install the SQL Server Management Studio 2016 and want to create a local Database. after search in the internet find this link from microsoft. in step 4 of this tutorial found this error when want to regester local servers no local server type “da…
Select where in() for each id return equal rows count
How to select rows for each user_id equals select numbers of count for each user_id? My example table: mp3_id | user_id ——————– 120 | 840 123 | 840 126 | 840 128 | …
create fiscal week number
How can I put the below logic into a format SQL Server will use to create a fiscal week number ? Answer The CASE Statement should work:
How to setup properties on CSV import in OrientDB?
I have a CSV file like: And I am importing it into OrientDB like: I would like to set the import so that it created properties so that FN becomes first_name, MI becomes middle_name and so on, as well as set some values to lowercase. For ex: Carolina to become carolina I could probably make this changes from t…
ERROR 1046:No database selected
I would like to create a SQL database but this error occurs I do not know why. Can somebody help me? My SQL statement: Can somebody help me? Answer Firstly you need to tell MySQL which database you would like to use to create a table: If your database does not exist yet, you have to create one: then tell