I have some questions about writing/using SQL; Can I ask those here in this forum?

bhowerton

New member
Local time
Today, 04:11
Joined
Oct 30, 2004
Messages
5
Hello everyone,
I have a few questions about using/writing SQL.

I would like to start programming in SQL. I am a Database Manager and I have a lot of reports that are in Text Files (these Text Files contain a lot of Necessary and UnNecessary data. I want to try and use SQL to format them and extract the needed data to create a professional report.

Can I use SQL to do this?

I know this might seem like a stupid question, but I have installed and configured MySQL Ver 4.1.7 and the MySQL Query Browser on my Windows XP machine. Windows (itself) basically done all of the installing and configuring...I just answered a few questions.

Now that it is installed and everything...how do you open it up to start programming / typing the MySQL code to import the text file and format it, etc?

I have not found a ExE file to click on and open. I have attached a screen capture of what the MySQL Query Browser is asking for. I just do not know what to enter into those fields.

Can someone tell me what I need to do next....PLEASE BE DETAILED...I want to make sure that I get it right the first time.

Also,
I have read a lot of posts that talk about creating code and connecting to the server...so now I have a few questions.

If I create a set of SQL code to import, format, and create a report of my data...can I do this (run this code) independently of any other server (outside of my own computer)?

In other words...Can I take this SQL code and make it an actual program/database that has, for example, an EXE/BAT/COM extension to run on any computer (independently)?

Could everybody please provide some input on this post. It will help other Newbies in the future.

Thanks

Bobby Howerton
 
Since this is an Access forum, I will suggest an Access solution.

You can import the text files into Access tables and create the queries and reports from within Access.

If the text files are delimited format and contain headers in the first row, the job is easier. If the file doesn't contain column headers or is fixed, you will probably want to define the tables manually. Then you can link to the text files and create append queries that take the data from the linked text files and appends it to the pre-defined Access tables.

I don't use MySQL so I don't know anything about its user interface but once you create tables in a MySQL database, you can link those tables to Access and use Access to write your queries and do your reporting.

If you want to do this entirely with MySQL, you will do better to post to a MySQL site.
 

Users who are viewing this thread

Back
Top Bottom