Re: sql scripts

2004-04-18 Thread Robert J Taylor
Dudley F. Cañas wrote: hi ppl, im a newbie to mysql but been using oracle for quite sometime now and i found that mysql is not bad at all :) i was just wondering if is there an equivalent scripting method of coding like plsql scripts in mysql... ? TIA Stored Proceedures are currently imp

sql scripts

2004-04-18 Thread "Dudley F. Cañas"
hi ppl, im a newbie to mysql but been using oracle for quite sometime now and i found that mysql is not bad at all :) i was just wondering if is there an equivalent scripting method of coding like plsql scripts in mysql... ? TIA -- ___| |_ _ ___| | | ___ _ _ __ _ _ __ __

SQL Scripts web site

2004-04-15 Thread SQL-Scripts.COm
Hello, This is an announcement to all MySQL developers. I have opened my web site www.SQL-Scripts.com up to MySQL . This means that you can now search for scripts for MySQl and other database system on this site. www.SQL-Scripts.Com is targeted at becoming the number on search engine for databas

RE: How to generate sql scripts in Mysql?

2003-09-12 Thread Andy Eastham
al Message- > From: florence florence [mailto:[EMAIL PROTECTED] > Sent: 12 September 2003 09:17 > To: [EMAIL PROTECTED] > Subject: How to generate sql scripts in Mysql? > > > Hi, > > Hope someone can guide me how to generate sql scripts in > Mysql?Thanks

How to generate sql scripts in Mysql?

2003-09-12 Thread florence florence
Hi, Hope someone can guide me how to generate sql scripts in Mysql?Thanks. regards, florence Yahoo! Games - Who Wants to Be A Millionaire? Play now!

Re: Open-Source/Freeware Tool To Generate Entity Relationship Diagram s From Text File Containing SQL Scripts ?

2003-06-12 Thread Carl B. Constantine
* Eldrid Rensburg ([EMAIL PROTECTED]) wrote: > I have exported tables from MySQL 3.23 to a text file script containing all > its 'create table', indexing, etc, statements. > Is there an open-source / freeware tool to generate Entity Relationship > Diagrams from this script file ? > If not what oth

RE: Open-Source/Freeware Tool To Generate Entity Relationship Diagram s From Text File Containing SQL Scripts ?

2003-06-12 Thread Kieran Kelleher
From Text File Containing SQL Scripts ? Importance: High I have exported tables from MySQL 3.23 to a text file script containing all its 'create table', indexing, etc, statements. Is there an open-source / freeware tool to generate Entity Relationship Diagrams from this script file ? I

Open-Source/Freeware Tool To Generate Entity Relationship Diagram s From Text File Containing SQL Scripts ?

2003-06-12 Thread Eldrid Rensburg
I have exported tables from MySQL 3.23 to a text file script containing all its 'create table', indexing, etc, statements. Is there an open-source / freeware tool to generate Entity Relationship Diagrams from this script file ? If not what other tools exist ? This message and any attachment

Re: running sql scripts with 'source'

2002-11-05 Thread Daniel Koch
Don Vu wrote: Hi guys, I have a script in my home directory that i want others to be able to run. I 'chmod 777'ed the file and the folder it lives in and people still can't run it when they are at the mysql prompt and type "source /path/to/script/scriptname.sql". I can execute that script, even

running sql scripts with 'source'

2002-11-05 Thread Don Vu
Hi guys, I have a script in my home directory that i want others to be able to run. I 'chmod 777'ed the file and the folder it lives in and people still can't run it when they are at the mysql prompt and type "source /path/to/script/scriptname.sql". I can execute that script, even when i log in

Running SQL Scripts

2002-01-22 Thread Egor Egorov
Jarlath, Tuesday, January 22, 2002, 3:18:33 PM, you wrote: Script means "a file with SQL statements in it" I suppose. JH> - Does my script file need to be a .sql file or just a plain .txt file??? The suffix doesn't matter. But inside it there should be a plain text file in UNIX format of newl

RE: Running SQL Scripts

2002-01-22 Thread Jarlath . Hennelly
EMAIL PROTECTED] Subject: Re: Running SQL Scripts Hi, This should do the trick mysql > source /path/to/file.sql or shell > mysql databasename < /path/to/file.sql And it doesn't matter about the file extension. Kevin - Original Message - From: "Jarlath . Hennelly

RE: Running SQL Scripts

2002-01-22 Thread Achim, Caterina
Hi J, I think you shoud type of command prompt: mysql database < file.sql and this will create the database Cheers, Caterina -Original Message- From: Jarlath . Hennelly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 2:19 PM To: MySQL (E-mail) Subject: Running SQL Scri

RE: Running SQL Scripts

2002-01-22 Thread John Lodge
The file extension can be anything you like the command is mysql < file_name -Original Message- From: Jarlath . Hennelly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:19 PM To: MySQL (E-mail) Subject: Running SQL Scripts Dudes & Dudettes, I got a SQL script w

Re: Running SQL Scripts

2002-01-22 Thread Kevin Smith
t;MySQL (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, January 22, 2002 1:18 PM Subject: Running SQL Scripts > Dudes & Dudettes, > > I got a SQL script with all the SQL to setup a database. But I can't seem to > access the script. I did this before so I know it can be d

Running SQL Scripts

2002-01-22 Thread Jarlath . Hennelly
Dudes & Dudettes, I got a SQL script with all the SQL to setup a database. But I can't seem to access the script. I did this before so I know it can be done, but I've to do it for a new project, and I can't remeber how. So I've 2 questions : - Does my script file need to be a .sql file or just a