[Libreoffice-bugs] [Bug 119850] Database creation wizard dialog missing mysql connector options

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119850

--- Comment #24 from Alex Thurgood <iplaw67 at tuta.io> ---
@Tamas :

You need to create a database called "test" on your mysql server, and then a
table "AC" as follows:


CREATE TABLE `AC` (
  `bid` int(10) NOT NULL AUTO_INCREMENT,
  `Ac` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Cur` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `dt` datetime DEFAULT NULL,
  PRIMARY KEY (`bid`),
  KEY `cur` (`Cur`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

and then add some data to it

or else modify the content.xml of the ODB file to point to an already existing
db and table.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180926/0f9ebe9f/attachment.html>