|
|
 |
|
|
Thread Tools | Display Modes |
Feb 25th, 2007, 1:10 AM
|
#1 |
|
Hobbyist Programmer
Join Date: Mar 2005
Posts: 139
Rep Power: 4
 |
How do i run a script in MySql
Hi All,
I have a .SQL file with all my create table statements and another with my indexes and another with my insert into statements I created a database (create database test) sucessfuly, but how do i run a script on that database Also where do my scripts have to be (The /MySql/My SQL 5.0/scripts directory ?) many thanks |
|
|
|
Feb 25th, 2007, 1:19 AM
|
#2 |
|
Hobbyist Programmer
Join Date: Nov 2005
Posts: 172
Rep Power: 3
  |
What you do is go to command line and run the script from there, i'm not sure if you can just go c:\script.sql or if you have to copy and paste it in. One of the two ways should work.
|
|
|
|
|
Feb 25th, 2007, 3:09 AM
|
#3 |
|
Hobbyist Programmer
Join Date: Mar 2005
Posts: 139
Rep Power: 4
|
if this helps to explain what im getting at:
With oracle you have your .SQL file that contains lets say create table statements, and at the command line you type @ followed by the file name and it runs the statements in the file. in mysql what is the syntax for doing this |
|
|
|
|
Feb 25th, 2007, 3:21 AM
|
#4 |
|
Professional Programmer
Join Date: Oct 2004
Location: .ro
Posts: 383
Rep Power: 4
 |
__________________
Don't take life too seriously, it's not permanent ! |
|
|
|
|
Feb 25th, 2007, 10:52 AM
|
#5 |
|
Hobbyist Programmer
Join Date: Mar 2005
Posts: 139
Rep Power: 4
|
source C:\........
works perfectly, .. thanks my next question is: is there a programming language I can use to write programs in MySql -- like PL/SQL in Oracle where you make programs that run at the command line of MySql ?? Many Thanks and happy programming to all of you |
|
|
|
|
Feb 26th, 2007, 6:31 AM
|
#6 |
|
Hobbyist Programmer
Join Date: Nov 2006
Location: 163H
Posts: 213
Rep Power: 2
|
Here u can find some interesting tools that can come very handy and helpful. Also about languages to program to anything does. You only need the ODBC drivers of MySql and say welcome to .NET. I have tried the headers provided with MySql in visual studio 2003 but it seemed to have some errors and nothing worked. So now i am downloading here.
Good luck.
__________________
You never test the depth of a river with both feet. The believer is happy. The doubter is wise. Free speech carries with it some freedom to listen. The next generation will always surpass the previous one. It`s one of the never ending cycles of life. |
|
|
|
|
Feb 26th, 2007, 3:49 PM
|
#7 |
|
Hobbyist Programmer
Join Date: Mar 2005
Posts: 139
Rep Power: 4
|
Thanks. I will look into this.
Also, it would be very helpfull if you could take a look at my other post (Mysql error) its in this same room thanks |
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Tutorial - Using MySQL in C# | Darkhack | C# | 12 | Jan 17th, 2006 9:28 AM |
| Simple Perl / MySQL Problem.. pls help! | domquemo | Perl | 0 | Jan 11th, 2006 4:08 AM |
| A simple perl script | satimis | Perl | 3 | Aug 15th, 2005 9:31 AM |
| Bash Script Help | pelon | Bash / Shell Scripting | 2 | Feb 28th, 2005 3:58 PM |
Linear Mode
