Hello together,
i have found a Bug in the create statement when i export a table.
Version SQLYog Ultimate v 10.2
MySQL: 5.1.55 Community
OS: Windows 7-64 bit
How to reproduce:
Create a table with type decimal 5,2.
Put in some values.
ID price
1 1.28
2 1.11
Got to table on the left side open the context menue.
Choose Backup/Export – > Export Table as…
In the new window then choose SQL.
Be sure to select structure and data.
If the export is done read the content of the sql statement. You will see something like this:
/*
SQLyog Ultimate v10.2
MySQL - 5.1.55-community-log
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
create table `test1` (
`id` int (11),
`preis` Decimal (7)
);
insert into `test1` (`id`, `preis`) values('1','1.28');
insert into `test1` (`id`, `preis`) values('2','1.11');
You will see that the decimal type is now 7 and not 5,2.
This will only be happens when you make these steps above.
regards Alex
