I have a POINT column to store coordinates, and here is my insert query: INSERT INTO _coordinates_test (coordinates) VALUES(POINT(59.356125477261266, -2.8759361517393898)) But here is what i get on the column (coordinates): …•M@“Ö(ÐêÀ I also tried reading coordinates like this: SELECT POINT(59.356125477261266,…
MySQL returns the following error when I want to execute a statement: SQLSTATE[HY000]: General error: 1366 Incorrect string value: 'xD1' for column 'last_update' at row 1 Here is the code to insert the value: $connection = DataBaseMySQLConnect::getConnection(self::$dbName); $query = "INSERT…
I am try to get some random data from the MySql data base, in order to get that data I use the following query @Query(nativeQuery = true,value = "select question from test_questions order by RAND() limit 4") and I put…
I need a report of which cars (license plates) are parked in and when. This is an example of my table. id lic_plate datetime lane _________________________________________________ 10 1234-JM 2022-10-07 12:24:33 IN 11 1234-JM 2022-10-07 12:29:57 OUT 12 5678-PC 2022-10-07 15:14:17…
My salary table looks like this, employeeId Salary salaryEffectiveFrom 19966 10000.00 2022-07-01 19966 20000.00 2022-07-15 My role/grades table looks like this, employeeId grade roleEffectiveFrom 19966 grade 3 2022-07-01 19966 grade 2 2022-07-10 I am trying to get the salary a…
I have this membertype table: | member_id | member_name | |-----------|-------------| | 901 | Liz | | 902 | Margaret | | 903 | Bob | and this revenue table: | GIS_ID | Member_ID | Total_Revenue | Total_Discount | Number_Transaction…
Here is the query I tried to write and gives an error $users =User::has('subscriptions', function (Builder $q) { $q->whereNotNull('ends_at'); })->get(); Getting this error SQLSTATE[42601]: Syntax error: 7 ERROR: SELECT * with no tables specified is not valid LINE 1: ...sers"."id"…
I have a wallet table like this: // wallet +----+----------+--------+ | id | user_id | amount | +----+----------+--------+ | 1 | 5 | 1000 | | 2 | 5 | -200 | | 3 | 5 | -100 | |…
I have three tables in my database, one for clients, one for products and one for orders, containing both the primary keys of products and clients as a foreign key. I am using SQL and MySQL A query I'm struggling…
I have a very similar problem to this one: Count unique occurrences per each distinct variable in MySQL but with a twist. I'm working with a select statement that shows results much like what the above-mentioned question does. If I…