From: Arjen Lentz Date: March 20 2011 11:07pm Subject: Re: mysql questions List-Archive: http://lists.mysql.com/ug-brisbane/154 Message-Id: <886415088.2715.1300662464563.JavaMail.root@zimbra.lentz.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hi Marvin ----- Original Message ----- > a blind computing it student doing a it help desk course from > http://ww.oten.edu.au > and doing the subject use sql to create database and manipulate data, > now, using my sql community 5.1.5 database server. > using the jaws for windows screen reader from > http://www.freedomscientific.com excellent! > and now a fe questions: > 1. how to write a basic script. > 2. any documentation, on how to use variables, functions, loops, etc. > 3. how to say import a text file and then execute a script within the > command line editor. > 4. will be using a text editor like notepad, text pad, and then will > execute and create the database. > also, any delimeters, or any other information.a > newbie and have done a little bit of sql, using visual web developer, > doing a star trek project, and used sql server management studio > express 2008, as part of visual studio. > but have never really used my sql. > now need to use this as to do my assignments. > and got the assignments, and enrolled in this subject. > got the learning materials. > but any extra, help, tips, tricks, so my coding can go smoothly. > marvin, from devonport, tasmania. I'm just replying to all of this in one go because I think my answer relates to the whole rather than individual bits. The mysql command line client just takes plain SQL and passes it to the server, so no loops/functions or other programmatic constructs (like you may have been familiar with from the Microsoft stuff). Inside the client, the source command is used to have a file read and executed, or you can use input redirection with