Try http://www.analysisandsolutions.com/code/mybasic.htm#creating for a nice
tutorial
and http://www.devshed.com/Server_Side/MySQL/Speak/page7.html has some
excellent tutorials
To Create a database and table
CREATE DATABASE member;
Create a table
CREATE TABLE members (
member_id int(11) NOT NULL auto_increment,
fname varchar(50) NOT NULL,
lname varchar(50) NOT NULL,
tel varchar(15),
email varchar(50) NOT NULL,
PRIMARY KEY (member_id)
);
To insert
INSERT into <members (fname_1,lname, tel) VALUES
(Shania, Qiu, 208-469-9999, [EMAIL PROTECTED], 16)
To Delete
mysql> DELETE FROM members WHERE member_id = 16;
Query OK, 1 row affected (0.06 sec)
There is a Ton of info out there and some really good books as well. There
is also alot of other ways to do this which I am sure others will show you.
Have fun
Cheers
M;-)
-----Original Message-----
From: Shania Qiu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 7:29 PM
To: 'Mike'
Subject: RE: asking for teaching?
Thank you, Mike,
It seems to work in cmd environment. the 'mysql>' prompt appeared. The
screen looks like:
mysql>create database firsttry
->use test
->create table art
->
Right?
The next i'd better to find out in the manaul what the command is to create
tables and such. May you could give me the clue.
Cheers,
Shania Qiu
-----Original Message-----
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 5 July 2001 1:34 p.m.
To: Shania Qiu
Subject: RE: asking for teaching?
Try this
Start | Run cmd to get to the command prompt
cd to Mysql the cd bin
now type mysql
now the prompt looks like
mysql>
then you can do what Luis said
create database test; ---hit enter
one you create it do this
# use test; --- this will change to this database
after that you will have to create the table
# create table art ; this will create the table for you .
-----Original Message-----
From: Shania Qiu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 7:11 PM
To: 'Luis'
Cc: '[EMAIL PROTECTED]'
Subject: RE: asking for teaching?
Thank you, Luis,
I type in 'login mysql', the system responded me with 'Welcome to Microsoft
Telnet Server', then back to c:\, according to your instruction, i typed in
create database test, the message ' 'create' is not recognized as an
internal or external command, operable program or batch file.'
I think the commands for windows are not the same as in linux. any ideas?
Shania
-----Original Message-----
From: Luis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 5 July 2001 1:03 p.m.
To: Shania Qiu; [EMAIL PROTECTED]
Subject: Re: asking for teaching?
well you should read the man pages that come with it also there are alot of
book on mysql.
But you know what since your a newbie. I wills how you. I dont have mysql
installed on a windows machine, but on a linux box. i believe the commands
are the same.
log in
mysql
create database test; ---hit enter
one you create it do this
# use test; --- this will change to this database
after that you will have to create the table
# create table art ; this will create the table for you .
if i'm wrong let me know
bye Luis
----- Original Message -----
From: "Shania Qiu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 5:55 PM
Subject: asking for teaching?
> Hi, all,
>
> I am a newer to MySQL, being learning, i have installed the bianary
3.23.29
> into my pc which is running windows 2000. Can someone tell me where and
how
> to create tables in MySQL.
>
> Thank you all.
>
>
> shania.
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php