Re: [Maria-discuss] New FRM Format

2013-07-16 Thread Stewart Smith
Justin Swanhart writes: > Though flush tables for export could produce a version neutral .frm > perhaps? Yep, there's a bunch of options like that available. -- Stewart Smith pgpxibVfSsq8q.pgp Description: PGP signature ___ Mailing list: https://lau

Re: [Maria-discuss] New Question: A Few Questions About MariaDB

2013-07-16 Thread Reindl Harald
Am 16.07.2013 20:25, schrieb AskMonty KB: > 1. Most of the time in MySQL, I would use the InnoDB storage engine in which > I used constraints and foreign keys. > Is this feature present in XtraDB and/or Aria db engines? XtraDB is pretty the same as InnoDB > 3. Does MariaDB recognize the mysql

[Maria-discuss] New Question: A Few Questions About MariaDB

2013-07-16 Thread AskMonty KB
Hello, A new question has been asked in "General FAQ" by edutrac: I am starting a new SaaS project, and I am looking at installing MariaDB 10.x for some testing. Below are a few questions I have. 1. Most of the time in MySQL, I would use the InnoDB storage engine

Re: [Maria-discuss] deferrable constraints syntax?

2013-07-16 Thread Ian Gilfillan
Hi Joeri The page you mention is from the SQL-99 book, and the syntax is not supported by MariaDB (or MySQL). ian On 16/07/2013 10:49, Joeri Leemans wrote: Hi all, I'm trying to create a deferrable foreign key constraint, according to the knowledge base article at https://kb.askmonty.or

[Maria-discuss] New Question: Which datatypes are supported by MariaDB

2013-07-16 Thread AskMonty KB
Hello, A new question has been asked in "Getting Started" by giordano: I would like to know which datatypes are supported by MariaDB. I'm asking since I'm little confused. For example, the knowledge base contains a chapter temporal datatypes: https://kb.askmonty.

[Maria-discuss] deferrable constraints syntax?

2013-07-16 Thread Joeri Leemans
Hi all,I'm trying to create a deferrable foreign key constraint, according to the knowledge base article at https://kb.askmonty.org/en/constraint_type-foreign-key-constraint/. The syntax of "deferrable initially deferred" doesn't seem to be recognised. Without it, the tables are created just fine.