I come back with utf8mb4 character issues. I'm using mariadb Server version: 10.3.37-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04 on a local machine with Linux Mint 20.3. Here is a test table: CREATE TABLE chartable ( k1 VARCHAR(5) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT…
I have a column (student_no) in my database with JSON data (String). student No: [ {First_name: 'John', Last_name: 'Wick', student_id: 1001, }, {First_name: 'David', Last_name: 'Stone', student_id: 1002, } If I want to read and display only the student_id =…
I have written an application in Javascript which inserts data into two tables via a connection to a MariaDB server. There should be a 1:1 correspondance between the rows in these tables when first running the application. One table stores…
I have a problem on this, I can't find where is the problem in my code, anyone help me, pls. <?php if($_POST['submit']) { $username = $_POST['username']; $password = $_POST['password']; $id = $_POST['id']; $query = "UPDATE users SET "; $query .="username…
I want to retrieve all buy orders with a count of matching buy orders in a single query. A match would be a sell order that satisfies all attributes (greater or equal) and is cheaper than the buy order. Is…
I am looking for a way of find rows by given element of the json table that match the pattern. Lets start with mysql table: CREATE TABLE `person` ( `attributes` json DEFAULT NULL ); INSERT INTO `person` (`attributes`) VALUES ('[{"scores":…
I want to join two tables: Table1: Task Hours Client Time Task A 1 Client A 2023-01-01 Task A 2 Client A 2022-03-04 Task A 3 Client A 2023-01-01 Task A 4 Client A 2022-03-04 Task B 5 Client A…
<?php $server="localhost"; $user="root"; $pass=""; $dbname="expert"; $dsn="mysql:host=$server;dbname=$dbname"; try { $connect=new PDO($dsn,$user,$pass); $connect->exec("SET character_set_connection ='utf8mb4'"); $connect->exec("SET NAMES ='UTF8'"); } catch (PDOException $error){ echo ("unable to connect".$error->getMessage()); } ?> unable to connectSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in…
AND t1.Team IN (SELECT Team FROM t2 WHERE t3.ID = t2.ID) How can I make above AND as optional, if the sub-query does not have any results, do not even consider AND t1.Team IN (""). Something like this does not…
My system is Ubuntu 16.04 and MariaDB version is 10.2.38. I want to get Ubuntu version from shell and save the result in sql variable. MariaDB [(none)]> ! lsb_release -r; Release: 16.04 I executed the sentence below. MariaDB [(none)]> set…