mysql-error-1064 Questions
19
Solved
I had set the MySQL path, but still getting the same error. Please let me know whether I followed the correct one or not.
MySQL location is: C:\Program Files\MySQL\MySQL Server 5.0\bin
In Windows...
Hamitosemitic asked 7/5, 2011 at 9:9
25
Tried
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Getting
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corr...
Prone asked 4/5, 2018 at 14:23
2
Solved
DELIMITER //
CREATE FUNCTION fnc_credit_custstatus
RETURNS VARCHAR(6) DETERMINISTIC
BEGIN
DECLARE custstatus VARCHAR(6);
IF CustCredit>='1000',THEN SET custstatus='VIP';
ELSEIF CustCredit...
Liggins asked 30/4, 2020 at 7:40
2
Solved
I'm trying to create this event but I can't find the syntax error.
CREATE
EVENT respaldoRegRawInformeAperturaLocal
ON SCHEDULE EVERY 1 DAY STARTS '2017-08-03 22:00:00'
DO BEGIN
-- INSERT INTO ...
Ghiberti asked 3/8, 2017 at 15:17
11
Solved
Modifed.
DROP FUNCTION IF EXISTS PersonName;
DELIMITER |;
CREATE FUNCTION PersonName( personID SMALLINT )
RETURNS CHAR(20)
BEGIN
DECLARE pname CHAR(20) DEFAULT '';
SELECT name INTO pname FROM f...
Dystopia asked 12/8, 2009 at 16:13
5
I have already installed Visual Studio 2015 x64 Redistributable but still the server failed to install. What could be the reason?
Comprise asked 25/1, 2019 at 1:6
6
Solved
mysql> SHOW TABLES like 'cms';
+-------------------------+
| Tables_in_tianyan (cms) |
+-------------------------+
| cms |
+-------------------------+
1 row in set (0.00 sec)
Result
mysql> SHO...
Enclave asked 10/4, 2011 at 3:39
6
Solved
SELECT airline, airports.icao_code, continent, country, province, city, website
FROM airlines
FULL OUTER JOIN airports ON airlines.iaco_code = airports.iaco_code
FULL OUTER JOIN cities ON airpor...
Riker asked 5/3, 2010 at 3:2
4
Solved
I was searching for a way to convert all the text which I have in a database to Camel Case / Proper Case
i.e. from CAMEL HAS LEGS to Camel Has Legs
I found an answer here, which asks to create a ...
Bello asked 25/3, 2017 at 7:35
7
I am getting an error while running a SQL script to load data. Error is pasted below:
Preparing...
[WinError 32] The process cannot access the file because it is being used by another process: 'C:...
Heyes asked 26/1, 2021 at 20:1
6
Solved
I have the Stored procedure like this:
CREATE PROCEDURE ProG()
BEGIN
SELECT * FROM `hs_hr_employee_leave_quota`;
END
But it gives the error:
#1064 - You have an error in your SQL syntax; check...
Dissected asked 18/4, 2011 at 13:14
5
Solved
My mysql server is not starting after stopping it
Command using:
sudo /etc/init.d/mysql restart
Error :
Restarting mysql (via systemctl): mysql.serviceJob for mysql.service
failed because the con...
Velasquez asked 22/6, 2020 at 22:16
11
I have a clean install of MySQL (mysql-5.5.24-osx10.6-x86_64). I am on Lion (OS 10.7.4) with a Mac Pro Quad Core. I installed MySQL the GUI installer and also installed the pref pane and the startu...
Phasia asked 16/5, 2012 at 1:25
5
Solved
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
CASE
WHEN reply.replies <> NULL THEN
24/((UNIX...
Thunell asked 27/1, 2011 at 19:42
3
Solved
When issuing a command to MySQL, I'm getting error #1064 "syntax error".
What does it mean?
How can I fix it?
Dedal asked 7/5, 2014 at 10:32
10
Solved
Unable to set password for a user using 3.5.2.2 - phpMyAdmin for 5.5.27 - MySQL. When trying to set the password while logged onto phpMyAdmin as the user, it pops up the following error:
#1133 - C...
Sender asked 13/10, 2012 at 22:8
1
How fix permanently: Job for mysql.service failed because the control process exited with error code
I am working with Ubuntu 18.04 and MySQL Server - 8.0.18
Suddenly today MySQL can't start anymore
With the sudo service mysql status command appears:
sudo service mysql status
● mysql.service - ...
Drinkwater asked 2/11, 2019 at 23:51
2
Solved
I have heard a lot of people complain about this, and justifiably so. Many MySQL error messages are ridiculously long:
You have an error in your SQL syntax; check the manual that corresponds to y...
Lanate asked 23/4, 2014 at 14:0
5
Solved
I had created a Django view which is returning some data after reading from MySql DB.When i try and fetch around 6000 rows from the Database,everything works fine and the view returns HttpResponse ...
Circumambient asked 26/12, 2011 at 6:12
3
Solved
CREATE TABLE `users` (
`UID` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`username` VARCHAR(45) NOT NULL ,
`password` VARCHAR(100) NULL ,
`name` VARCHAR(100) NULL ,
`gender` BIT NULL ,
`email` VAR...
Ridley asked 23/7, 2010 at 8:10
5
Solved
I just did a fresh install of Apache server 2.2.
Everything works. When I go to localhost I get: "It Works!"
I just installed mySQL5.5 and when I go to localhost:3306 I just get gibberish:
J���...
Methuselah asked 7/4, 2012 at 10:20
7
Solved
I am trying to delete from a few tables at once. I've done a bit of research, and came up with this
DELETE FROM `pets` p,
`pets_activities` pa
WHERE p.`order` > :order
AND p.`pet_id` = :pet_...
Scarabaeid asked 26/7, 2010 at 3:5
2
Solved
I am not sure whats wrong with my code.
delimiter $$
CREATE TRIGGER updateRestaurantAtributes
AFTER UPDATE ON fields_data
FOR EACH ROW BEGIN
IF (NEW.fieldid = 1) THEN
UPDATE restaurants
SE...
Disposed asked 31/12, 2011 at 2:44
15
I am trying to populate a new MySQL empty database with a db dump created from MS SQL Azure database, and I get the following error
ERROR 1064 (42000) at line 1: You have an error in your SQL sy...
Lympho asked 9/8, 2011 at 15:27
1
Solved
I'm running MySQL 8 and it's suddenly just decided to shutdown and not come back when I try to start it back up.
In the log I can see this event was the cause.
However, I have no idea what that m...
Philomel asked 25/4, 2019 at 10:0
1 Next >
© 2022 - 2024 — McMap. All rights reserved.