Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.