SQL Statements & Structure

Open Questions

• 1

  0 not found in WHERE however value is 0

  TABLE DEFINITION CREATE TABLE `tblArtikelen` ( `ArtikelCode` int(10) NOT ...
• 1

  An update lock cannot be acquired during a READ UNCOMMITTED transaction

  Hello everyone I just upgraded to the latest version of WampServer to use P...
• 1

  I have an error

  1064 - You have an error in your SQL syntax; check the manual that correspo...
• 1

  ING

  What functions does Mariadb know, p.e. pivot ?
• 2

  problem in create table statement in specific data directory

  i am using mariadb 10.4.12 x64 on windows 10 when executing: create table t...

Answered Questions

• 1

  auto-increment feature

  Hi: This is my first day using Maria DB and pardon me if my question is ele...
• 5

  Field 'xxxx' doesn't have a default value

  We are running mariadb version 10.3.27 When trying to insert a record we ge...
• 1

  Getting syntax error while inserting data

  NSERT INTO details ('Reference ID','Type of Request','User Start/Term/Chang...
• 1

  how to check the CPU utilization in mariaDB

  how to check the CPU utilization in mariaDB
• 5

  indexes in subquery causing MariaDB crash ???

  where to begin..... Over the last 24 hours i've had 3 (out of 5 total) mari...
• 1

  ive bought a hosting with host daddy

  do i have to download anythng to get things going? it says mariadb 10.4.34 ...
• 1

  mysql command legth limit? 10.1.44-MariaDB-0ubuntu0.18.04.1

  I am executing a create table command. If the character count in the singl...
• 1

  problem in sql

  function get_unique_categories(){ global $con; if(isset($_GET['category...
• 3

  Problem installing Mariadb on a Debian

  Hello, Im trying to intall Mariadb with this command: curl -LsS https://r.m...
• 1

  sql query for join

  i want to know the sql query to join 2 tables whether it has been matched or not
• 4

  Table Construction

  Alter Table EmployeeEvals ADD EvaluatorNum INT(8) NOT NULL AUTO_INCREMENT P...
• 1

  TRIGGER SYNTAX ERROR

  MySQL said: #1064 - You have an error in your SQL syntax; check the manual ...
• 1

  trying to sync my DB to a game server for my community and getting an error i have no idea how to fix

  You have an error in your SQL syntax; check the manual that corresponds to ...
• 1

  trying to write an SQL

  Where do I go to write an SQL and save it with the tee command?
• 3

  Unable to create after insert trigger on mariadb

  Hi, I followed trigger instructions from documentation. When i run the scri...
• 3

  WHERE usage in MariaDB

  im getting this message when im trying to update the records of my database...
• 2

  Why is this create table statement failing?

  Hi: When I tried to create a table: CREATE TABLE pt_lang ( meddra_version_...
• 4

  WITH RECURSIVE limited to 1001 records?

  Hi guys, I need to generate a list of dates from A to B. In the example bel...
• 2

  working with timestamps

  I have a table with epochtime (Unix-Time) in one row. Now I want to select ...