Re: [libreoffice-users] help with database

Hi :)
That is a good question.  


Ultimately the Tables 'should' be in MySql (or whichever back-end you are using).  One thing i 
don't know is if you can use the nice GUI front-end in Base to create the Tables and find the 
Tables are automatically in the external back-end.  If it does work that way then it greatly 
reduces complexity by hiding the complexity away from the Database Designer.  


Ian, Alex, Dan, anyone any idea?
Regards from 

Tom :)  






> ________________________________
> From: rounak jain <rounak.mint@gmail.com>
> To: Dan Lewis <elderdanlewis@gmail.com> 
> Cc: "users@global.libreoffice.org" <users@global.libreoffice.org> 
> Sent: Sunday, 12 May 2013, 6:24
> Subject: Re: [libreoffice-users] help with database
>
>
> [quote]What version of MySQL are you using?[/quote]
> $ which mysql
> /usr/local/mysql-5.6.11-osx10.7-x86_64/bin/mysql
> [quote] Tables and their data are kept within
> MySQL.........................After creating the schema, you can use Base
> to create the tables for the schema.[/quote]
> Confusing.....tables are to be created in MySQL or BASE?
>
>
>
> On Sun, May 12, 2013 at 9:50 AM, Dan Lewis <elderdanlewis@gmail.com> wrote:
>
> > On 05/11/2013 11:21 PM, rounak jain wrote:
> >
> > > I have connected my Base to MySql. Can you please clarify which tasks must
> > > I perform in Base and which ones in MySql..............for example....I
> > > guess I must create tables in MySql.......what about "Forms" and
> > > "Queries"?
> > > Where must I make the data entry? Sorry.....total newbie!!(and
> > > intermediate Filemaker user)
> > >
> > >        What version of MySQL are you using? The answer to this determines
> > what you should do and how.
> >       Tables and their data are kept within MySQL. Forms, queries, views,
> > and reports are created within the Base file you use to connect to MySQL.
> >       Databases and schema must be created within MySQL. How this is done
> > depends upon the answer to my first question. A database must be created
> > first. Then the schema for the database are created second. After creating
> > the schema, you can use Base to create the tables for the schema.
> >       You have probably heard the advice RTM (read the manual). Well, you
> > need to get a manual for the version of MySQL that you are using.
> >        I use MySQL 5.5 and the program, Workbench, is what I use for all
> > administrative tasks for MySQL. When I used MySQL 5.1, I used mysqladmin to
> > do these things.
> >
> > --Dan
-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted