My SQL database

[generalnewbie]

anyone here use mysql im wondering somethings about how to make one and view one.

if you have ever made a database from it please let meknow

i really could use your advice

thanks

[othernutrient]

Try reading the manual.

I mean really, actually try learning something, because if you don't, you're not going to know how to do anything when it comes time.

The manual is free, right under your nose, and you don't have to wait for us to reply.

It goes into great detail how to do the things you describe. It even tells you about a graphical extension to the command line you can use.

Take the time to actually try it. You might learn something.

[PM5K]

Do you mean on a remote server, or locally ?

[generalnewbie]

ive attempted to set it up locally but that didnt work

so im gonna attemp remotely

whats the extension on a mysql database? file

[Tim Dorr Veteran]

Originally posted by generalnewbie

ive attempted to set it up locally but that didnt work

so im gonna attemp remotely

whats the extension on a mysql database? file

uh, i don't think you understand dbs at ALL :D

there are file's stored on your system, but you don't access them directly. you go through the MySQL dameon/server. You issue it SQL commands and it returns the result. There is an included GUI, that you can use and is rather nice. But it's all SQL.

Go and read up on SQL language and you'll probably understand things better :)

[othernutrient]

Originally posted by generalnewbie

ive attempted to set it up locally but that didnt work

so im gonna attemp remotely

whats the extension on a mysql database? file

Databases are made up of multiple files and work quite differently than pseudo databases like Access.

I really strongly suggest that you read the manual. Cover to cover, then read it again. And if you're still stumped, search Google for "How do I make a database in MySQL?"

But above all else, always always always RTFM.

[YahoKa]

RTFM.

Install it. Run mysql.exe. type the command

> create yourdatabasename

then type

> u yourdatabasename

then type

> g create table tablename (id int(12) default NULL auto_increment, primary key (id), nextcolumnname int/char/etc default NULL)

There you go. You have a database. If you ask how to connect to it i will smack you (digitally, of course)