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
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