phpmysqldatabaseheidisql
SQL Error (1064) : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax
I have a sql file name live.sql and I want import in my DB in heidiSQL but when I am going import this file, it gives a following error.
SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'þFFvar/www/html/live/databases/012017/live_01_11_2017.sql
' at line 1
How can I fix this error?
Solution
The error means that the sql query is incorrect. Comment out line number 1, by adding 2 dashes (--) at the start of the line.
- Laravel Excel Download using Controller
- How do I parse emails in realtime as they are recieved
- PhpStorm does not show Missing parameter's type declaration warning
- HTML form not sending expected value of radio button, sending "on" instead
- Cannot modify readonly property - but not modifying it?
- PHP: Best way to check if input is a valid number?
- How do I get Eloquent autocompletion in Visual Studio Code?
- Can you get a return URL by GET in JQuery or PHP?
- Retrieve wordpress image filename as it is loaded
- How can I use a many-to-many relationship to display articles by tag in Laravel?
- When a file is not found, anything blow the error is a no show, how can I fix this?
- How can i edit that php code to be required?
- Use PHP to create thumbnails. (Cropped to square)
- Custom quantity input step based on WooCommerce product category
- How to get video from Instagram public access API?
- Browscap.ini throwing an error when loading PHP (command line - PHP_CLI)
- PHP arrays, how to access keys and values
- Error 500 - Premature end of script headers in Laravel
- I want to hide json file from public access. How do I do that?
- I got this error "Use of a direct database call is discouraged"
- PHP replace string with values from array
- How to Validate Bitbucket Webhook Signature Using Secret Key?
- Passing docker-compose .env file values into the container
- Declaring Variable Types in PHP?
- How can I detect a malformed UTF-8 string in PHP?
- PHP: mb_convert_encoding() to UTF-16LE doesn't work
- Use WC Kalkulator product field values to update WooCommerce cart item product properties
- What is the difference between strcmp() and Spaceship Operator (<=>)
- Validate UUID with Laravel Validation
- Artisan Call output in Controller?