SQL Statements

Open Questions

• 1

  about query

  UPDATE pna SET Personality=t2.Personality FROM pna1 AS t2 WHERE t2.ID <= 3...
• 1

  how do I create databases in phpmyadmin using SQL query/queries?

  When I run the CREATE DATABASE command in the sql window, the db is not cre...
• 1

  loop parameter

  i am new migrate from mySQL in visual studio when i set parameter in SELECT...
• Need help resolving SQL IMPORT ERROR

  SQL file with the following type of code to fill a table with data from an ...
• 2

  Sakila database

  What is the right syntax to use near 'mysql command and display all tables ...

Answered Questions

• 4

  select based upon date...

  I dont understand why I can't filter based upon date.... the following comm...
• 1

  Close conection of an user

  There are some rules that must be follow, I wanna close the connection of a...
• 1

  como se usa dump en mariadb

  no funciona mysqldump
• 4

  COUNT not working on XAMPP

  I have just installed XAMPP version 7.0.2 which incorporates MariaDB. I hav...
• 1

  database export

  how can I export database in MariaDB to outside environment e.g. to text file or other format
• 1

  Do I need quote marks

  I've just set up my first db but the one user I created gets access denied when I log them in.
• 6

  Documentation

  Do you have the MariaDB reference docs in PDF format? The online HTML forma...
• 4

  ERROR 1604

  I ssh into my server and try nto change the root password to gain access to...
• 1

  Error in syntax

  Hello, I have this query meant to add a value into my table but it returns ...
• 1

  Help with syntax error

  I am trying to run a sql script in a mariadb version 10.3.38-MariaDB-cll-lve: SET @s := '20
• 1

  How to use an insert using variable column names in stored procedure

  I am sure that this happens because of my lack of knowledge, but I am in a ...
• 1

  INSERT ERROR

  I am trying to insert data into my table but it keeps saying a row inserted...
• 1

  IP Address

  How do I find the IP address or the full hostname of the MariaDB server?
• 7

  mysqli_connect did not work

  i will try the make local database from csv File. but Sql did not connect l...
• 1

  Replace multiple character

  How to replace multiple characters in a Textstring ececuting one select? Re...
• 2

  Specific terminal command ONLY_FULL_GROUP_BY & ANSI_QUOTES

  Hi I only have minimal knowledge on this but I would need to do the followi...
• 1

  SQL problem occuring with PHP but notin the DBMS itself

  SQL problem occuring with PHP but notin the DBMS itself Hi I run a query wi...
• 1

  SQL SYNTAX

  What causes this error? You have an error in your SQL syntax; check the ma...
• 2

  SQL Syntax Error -RAISERROR

  I'm trying to create a trigger which raises an error when old password and ...
• 1

  trigger

  how to use trigger
• 1

  What is the rest api for mariadb for integration purpose?

  What is the rest api for mariadb for integration purpose?