Tag: mysql-error-1064

Show the manufacturers that sold cellphone in 2010 but didn’t in 2009. (USING MYSQL)

SELECT Manufacturer_Name FROM DIM_MANUFACTURER INNER JOIN DIM_MODEL ON DIM_MANUFACTURER.IDManufacturer = DIM_MODEL.IDManufacturer WHERE DIM_MANUFACTURER.IDManufacturer IN ( …

MySQL: cannot add constant field at start of SELECT. Error 1064

mariadb mysql mysql-error-1064 sql

Using MariaDB v. 10, I try to add a custom constant as the first column of my SELECT query, before all other columns *. This results in the generic syntax error 1064. For example: If I select only some columns, it works: And it also works if I use * to select all columns, but put my constant column after

I got mysqli error 1064 but i don’t know why

mysql mysql-error-1064 php sql

I want to post this data from android client and i tested it with postman and status code was 200. But i have a mysqli error and it’s: Error: ((1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE id=’ at line 1)

I keep getting 1064 error in phpmyadmin

database mysql-error-1064 sql

I am trying to create a table in phpmyadmin with the following SQL : CREATE TABLE `umOrder`.`Bill` ( `Id` INT(5) NOT NULL AUTO_INCREMENT , `userID` VARCHAR(255) NOT NULL , `product` …

Why am I getting an error in this create table script? [closed]

mysql mysql-error-1064 sql

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. Closed 9 years ago. I’m attempting to write

Conditional NOT NULL case SQL

mysql mysql-error-1064 null sql

I am trying to calculate a field and I want it to behave differently depending on if one of the columns happens to be null. I am using MySQL Is this the right syntax? Answer You need to have when reply.replies IS NOT NULL NULL is a special case in SQL and cannot be compared with = or <> operators.

SQL syntax for “if exists”

mysql mysql-error-1064 sql

Why I’m getting this error: My SQL query: Thanks. Answer IF EXISTS only works in a stored procedure. Outside of a stored procedure, IF() is a function which takes 3 arguments. Proper usage would be