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: [email protected]
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
