List:General Discussion« Previous MessageNext Message »
From:Bruce Douglas Date:May 8 2003 5:59am
Subject:RE: making a mysql script
View as plain text  
kurt...

if i understand your issue/question....

----------------------------------------------------------------------------
---------
#
#	Usage:
#		Make sure the dbid database exists or create it by
#			d:\mysql -u "user" -p "passwd" -e "create database dbname"
#			user	==> the username for the mysql database
#			passwd	==>	the passwd for the mysql database
#			dbname	==>	the name you give your database
#
#		to create the tables. From a prompt, type
#			c:\mysql -u -p < dbid.sql
#
#
#

# Test database
#
use dbid;


#
#	AuctionTbl
#
#	Table is used to store information on the auctions that occur
#	on the site. This includes new/current/old auctions. The table
#	contains the following information:
#
#		auctionname varchar(25)	NOT NULL default ''
#		status			int(5) NOT NULL,		//status of the auction
#		auctionid int(11) NOT NULL
#		auctiondescr		varchar(25)	NOT NULL default ''
#		auctionlocation varchar(25)	NOT NULL default ''
#		auctiontime			timestamp
#		auctiontype		varchar(25)	NOT NULL default '' (webcast/on-location/etc..)
#		auction_length	varchar(20) NOT NULL default '',
#		spotlight			int(1) NULL,	//defines which items in col #1
#		spotlight_data		text NULL,	//defines the spotlight data
#		span			varchar(50) NULL,	//defines the span section (rarely used)
#		id int(11) NOT NULL
#

CREATE TABLE AuctionTbl (
	compname		varchar(50)	NOT NULL default '',
	status			int(5) NOT NULL,
	dbid_id			int(11) NOT NULL,
	descr			text	NOT NULL,
	location		varchar(25)	NOT NULL default '',
	_time			datetime NOT NULL default '0000-00-00 00:00',
	type			varchar(25)	NOT NULL default '',
	auction_length	varchar(20) NOT NULL default '',
	spotlight		int(1) NULL,
	spotlight_data	text NULL,
	span			varchar(50) NULL,
	id				int(10)	NOT NULL auto_increment,
	PRIMARY KEY  (id)
)	TYPE=MyISAM;

---------------------------------------------------------------------------

Everything between the ------------ lines is representative of what could go
in a mysql script file. Simply name the script whatever you
want.."foo.sql"..etc... Lines beginning with # are of course comments...

Hope this helps..

Bruce




-----Original Message-----
From: Kurt [mailto:k.killen@stripped]
Sent: Wednesday, May 07, 2003 10:51 AM
To: mysql@stripped
Subject: making a mysql script


Shoot me now. In Oracle you can write an SQL procedure, in notepad for
example, to create a table. You can then save this file in case you need
to recreate the table later. The problem I am having is the naming of
the file format and what command to use to run the file from the MySQL
command prompt.

In Oracle you type

SQL> @filename.sql

What do I name the file?
How to I run the file?

Thanks

Kurt


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1

Thread
making a mysql scriptKurt8 May
  • RE: making a mysql scriptBruce Douglas8 May
  • RE: making a mysql scriptRoger Davis8 May
  • Re: making a mysql scriptSam A. Funk11 May
    • manipulating myqsl database from javascript function....Bruce Douglas12 May
      • Re: manipulating myqsl database from javascript function....Greg Donald12 May
        • Re: manipulating myqsl database from javascript function....Rene van de Weerd14 May
      • Re: manipulating myqsl database from javascript function....colbey12 May
        • RE: manipulating myqsl database from javascript function....Daevid Vincent14 May
RE: making a mysql scriptDave Christensen9 May