April 4, 2015 at 6:10 am #13348
Hello everyone, am new in this forum and I want to ask can I import SQL database into excel sheet? Is it right than how to do it?
April 6, 2015 at 5:35 am #35296
Abhishek Kumar PandeyMember
Yes It is possible. You can goto table->backup/export->export data as and select excel. Or just press CTRL+ALT+C to get export as dialog.
April 15, 2015 at 8:22 am #35297
Thanks Abhishek, For your suggestion but still all data is not showing in proper way
April 16, 2015 at 5:29 am #35298
Abhishek Kumar PandeyMember
What is the problem you are facing? Also I should have mentioned that for utf8 data you should select UTF8 with bom character set for exporting. UTF8 doesn’t work properly with excel so SQLyog have option to write BOM characters in starting of the file.
April 16, 2015 at 10:17 am #35299
I just imported a .Sql file into my database and got an issue. Its been crazy. Its says “database not found” . Although the database already exists. Perhaps, this happens due to diffierent database name. Any suggestion?
April 20, 2015 at 8:53 am #35300
Please tell your SQLyog version.
I also do not understand “Perhaps, this happens due to different database name”. Please elaborate in detail how to trigger this.
April 28, 2015 at 4:32 am #35301
My SQLyog version 8.71, simply I used following code to import sql database in excel : SELECT * INTO DetailsImport1 FROM EXCELLINK…[Customers$].
April 28, 2015 at 11:25 am #35302
Please refer this https://dev.mysql.com/doc/refman/5.6/en/ansi-diff-select-into-table.html
“MySQL Server doesn’t support the SELECT … INTO TABLE Sybase SQL extension. Instead, MySQL Server supports the INSERT INTO … SELECT standard SQL syntax, which is basically the same thing. See Section 220.127.116.11, “INSERT … SELECT Syntax”“.
So your statement is not supported by MySQL. However he error message is not good and not helpful to identify the problem. But it is an error message generated by the MySQL server and not by SQLyog. Error message quality problems are frequenly reported to bugs.mysql.com. You may decide to report this one as well.
Note that also the [square brackets] are not MySQL syntax. It is Microsoft (SQL Server and Access) syntax. MySQL uses `backticks` for quoting identifers (unless ANSI sql_mode is used. In that case it is “double quotes”). The complete MySQL statement syntax is documented here: https://dev.mysql.com/doc/refman/5.6/en/sql-syntax.html
April 29, 2015 at 8:06 am #35303
If I simplify your statement as much as possible:
SELECT * FROM a INTO a_copy;
I get the error— Error Code: 1327— Undeclared variable: a_copyThe MySQL parser expects a “user variable” here.It does not matter what tabels a and a_copy are like as long as they arei dentical and whether tables are empty or not.This statement is correct for MySQL and works as expected:
INSERT INTO a_copy SELECT * FROM a;
May 1, 2015 at 9:21 am #35304
Am totally agree with you. yes may be this error occurring from this select statement. Let me check again. Thank you so much
You must be logged in to reply to this topic.