1,639 questions
0
votes
1
answer
101
views
Syntax error 1064 with LOAD DATA ... FIELDS OPTIONALLY ENCLOSED BY '"'
My SQL statement in MySQL 5.7.44, Windows 10:
drop table if exists test;
create table test (col1 VARCHAR(64), col2 VARCHAR(80) );
LOAD DATA LOCAL INFILE "t.csv" INTO TABLE test FIELDS ...
- 1,193
-5
votes
1
answer
66
views
How to Automatically Rearrange IDs in an SQL Table After Deleting a Row?
I have an SQL table with an id column that uses auto-increment. When I delete a row (e.g., where the id is 6), the IDs of the remaining rows do not change, and there is no longer a row with id 6. How ...
-1
votes
1
answer
96
views
How do I get rid of this ERROR 1064 (42000)? [duplicate]
Honestly, I don't understand why I have this error. Someone can help, please?
mysql> mysql -u root -p foodly < /Users/gregoireperney/Documents/1-dev/trainings_no_git/sql_foodly_db/partie_2/...
0
votes
3
answers
86
views
Flutter connection to Mysql
my name is Marques and desenvolving a flutter project for my end project in school and i'm a little but desesperated with a error that i can't solve .
I hope someone could help solving this to could ...
- 11
-3
votes
1
answer
546
views
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax. line 1 [closed]
I just finished installing MySQL 8.0.35 and Python 3.12.0. I added the path to my environment variables. But in my command prompt, I keep getting this error message.
Welcome to the MySQL monitor. ...
1
vote
0
answers
61
views
Cannot insert data in CodeIgniter 3 where database and fields are using space
I've tried to insert data using database and table fields where naming the database uses spaces (this is from my office law). But there is a following error -
'Error Number: 1064 You have an error in ...
- 25
0
votes
0
answers
21
views
bash file, mysql command update syntax error [duplicate]
Hi I want to make a script I can run via cron to update certain columns on a schedule
The script command not running it in sh file works fine
UPDATE `lines` SET allowed_outputs = '[1,2]';
in the sh ...
0
votes
0
answers
58
views
Error in CTE when using row_number() in mysql. I don't know why the error is showing up
WITH
team as (
select
row_number() over() as id,
team_code,
team_name
from teams
)
I got this error :- [12:06:32 WITH team as ( select ...
- 15
1
vote
1
answer
75
views
Failing sql import getting1064 error mysql 8 [duplicate]
CREATE PROCEDURE `getTestById`(IN `studID` INT,IN `tID` INT)
BEGIN
SELECT t.id,t.name,c.name category,i.name instructor,getQuestionsInTest(t.id) questions,ts.startTime,ts.duration,ts....
-2
votes
1
answer
89
views
I'm having trouble reading the sql output MySQL #1064 [closed]
photo of the error
`CREATE TABLE IF NOT EXISTS `adminpanel_bans` (
`banid` varchar(50) NOT NULL,
`active` int NOT NULL DEFAULT '1',
`bannedby` int NOT NULL,
`userid` int NOT NULL DEFAULT '0',
...
0
votes
0
answers
298
views
OLAP queries in MySql
I am trying to implement OLAP queries in MySql.
Here is a relation that I am trying to implement queries on
Cart(product_name,shipper_name,quantity).
I tried running the following query:
select ...
-1
votes
1
answer
120
views
showing syntax error while using sequence in mysql
-- creating table
create table student( studID int(10),
-> name varchar(100),
-> roll_no int(20));
--inserting values in table
insert into student(name,roll_no) values("suraj"...
-1
votes
1
answer
297
views
PHP mysql read function error (Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;)
This is database. php file: and I am getting fatal error on line 30($result = $stm->execute($data);)
The data and query there goes from the read function in the folder named user.class.php and I ...
0
votes
1
answer
184
views
How to rectify Error #1064 in MariaDB procedure?
DELIMITER $$
CREATE PROCEDURE insert_priority_rows()
BEGIN
DECLARE max_heuristics INT DEFAULT 10;
DECLARE heuristic_ID INT;
DECLARE cur CURSOR FOR
SELECT heuristicID
FROM heuristics;
...
-1
votes
3
answers
539
views
What is problem in this MySQL Query, it is giving error 1064 (42000)? [duplicate]
the query is
CREATE TABLE order(
order_id int primary key,
customer_name varchar(30) not null,
product_name varchar(20) not null,
date_ordered date,
quantity int,
unit_price ...
