New to MySQL and I'm confused!

[w_curtis]

I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
some web databases. But it just isn't clicking.

I've followed some tutorials, and picked up a book, but just getting to
square one has been a pain. I can follow the tutorials and get to the point
where I can make tables and stuff, but I don't know how I got there, or what
to do if something changes that makes it different than the tutorial.

MySQL doesn't seem to be like any other program I've used. Usually, I can
install a program, and then there's a little icon on my desktop, I click on
it, and there is the program.

But with MySQL, I install it, and it starts running as a service, but I
still can't see it. So I have to use a command prompt to talk to it. But
the commands to do this are anything but intuitive, and the tutorials I've
seen (from DevShed, the official site, and a few others) gloss over this
part like I'm already supposed to know how it works. Sometimes, I can get
it to work, and sometimes I can't. Users, passwords, ports, And this is
on my own computer. I don't even want to think of what this is like on a
network, or the internet. Or trying to get a program to talk to it
automatically.

Is there a good primer on the mechanics of how I'm supposed to actually
interface with this program? Can I skip the whole command-line thing and
just get a GUI? I imagine I'll still need to know about connecting and
stuff with a GUI.

[Aggro]

Re: New to MySQL and I'm confused!

w_curtis wrote:[color=blue]
> I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
> some web databases. But it just isn't clicking.[/color]

That is true, and it is because MySQL is a real database, while Access
is just a toy (looks nice, but you can't do much usefull stuff with it)
IMHO.

The main purpose of a database server is to be a server. Then you can
find the UI or GUI you like to interact with it. There are both console
and graphical intercases for MySQL, but I prefer mysql console program.

If you know SQL it is quite easy to interact with the console program,
but if not, you should learn it, if you are going to do database
software. You should learn it, because without understanding SQL it is
very hard to make fast and efficient queries, which are required in
web-programming.

# To start the console program:
# ( Assuming you have mysql installed in C:\MySQL\ )
# ( Assuming you have not set up the root password yet )
# ( If you have root password use: mysql -u root -p )

C:\> cd c:\mysql\bin\
c:\mysql\bin> mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 129 to server version: 3.23.49-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

# When you see this, you are in mysql console and you can
# for example create a database, select database, create table there
# insert data into table, and select the data,
# and finally we will drop the database, which will destroy
# the tables, inserted data and database. Of course if you are
# doing something for real life, you don't need to drop database,
# it is just to remove our test-database. Be carefull not to
# drop mysql database with this command.:

mysql> create database mydatabasename;
Query OK, 1 row affected (0.01 sec)

mysql> use mydatabasename;
Database changed

mysql> create table mytablename( id int unsigned, name varchar(255) );
Query OK, 0 rows affected (0.00 sec)

mysql> insert into mytablename values( 1, 'Jack' );
Query OK, 1 row affected (0.00 sec)

mysql> insert into mytablename values( 2, 'Lisa' );
Query OK, 1 row affected (0.00 sec)

mysql> select * from mytablename;
+------+------+
| id | name |
+------+------+
| 1 | Jack |
| 2 | Lisa |
+------+------+
2 rows in set (0.01 sec)

mysql> drop database mydatabasename;
Query OK, 3 rows affected (0.00 sec)



If you fail to do all that, please tell us where it fails and we will
see if we can fix that problem.

What comes to GUI programs, I don't know much about them, since I don't
use them. However someone else might answer to that question, or you
could try searching the answer for example with Google.

[Aggro]

Re: New to MySQL and I'm confused!

w_curtis wrote:[color=blue]
> I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
> some web databases. But it just isn't clicking.[/color]

That is true, and it is because MySQL is a real database, while Access
is just a toy (looks nice, but you can't do much usefull stuff with it)
IMHO.

The main purpose of a database server is to be a server. Then you can
find the UI or GUI you like to interact with it. There are both console
and graphical intercases for MySQL, but I prefer mysql console program.

If you know SQL it is quite easy to interact with the console program,
but if not, you should learn it, if you are going to do database
software. You should learn it, because without understanding SQL it is
very hard to make fast and efficient queries, which are required in
web-programming.

# To start the console program:
# ( Assuming you have mysql installed in C:\MySQL\ )
# ( Assuming you have not set up the root password yet )
# ( If you have root password use: mysql -u root -p )

C:\> cd c:\mysql\bin\
c:\mysql\bin> mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 129 to server version: 3.23.49-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

# When you see this, you are in mysql console and you can
# for example create a database, select database, create table there
# insert data into table, and select the data,
# and finally we will drop the database, which will destroy
# the tables, inserted data and database. Of course if you are
# doing something for real life, you don't need to drop database,
# it is just to remove our test-database. Be carefull not to
# drop mysql database with this command.:

mysql> create database mydatabasename;
Query OK, 1 row affected (0.01 sec)

mysql> use mydatabasename;
Database changed

mysql> create table mytablename( id int unsigned, name varchar(255) );
Query OK, 0 rows affected (0.00 sec)

mysql> insert into mytablename values( 1, 'Jack' );
Query OK, 1 row affected (0.00 sec)

mysql> insert into mytablename values( 2, 'Lisa' );
Query OK, 1 row affected (0.00 sec)

mysql> select * from mytablename;
+------+------+
| id | name |
+------+------+
| 1 | Jack |
| 2 | Lisa |
+------+------+
2 rows in set (0.01 sec)

mysql> drop database mydatabasename;
Query OK, 3 rows affected (0.00 sec)



If you fail to do all that, please tell us where it fails and we will
see if we can fix that problem.

What comes to GUI programs, I don't know much about them, since I don't
use them. However someone else might answer to that question, or you
could try searching the answer for example with Google.

[Aggro]

Re: New to MySQL and I'm confused!

w_curtis wrote:[color=blue]
> I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
> some web databases. But it just isn't clicking.[/color]

That is true, and it is because MySQL is a real database, while Access
is just a toy (looks nice, but you can't do much usefull stuff with it)
IMHO.

The main purpose of a database server is to be a server. Then you can
find the UI or GUI you like to interact with it. There are both console
and graphical intercases for MySQL, but I prefer mysql console program.

If you know SQL it is quite easy to interact with the console program,
but if not, you should learn it, if you are going to do database
software. You should learn it, because without understanding SQL it is
very hard to make fast and efficient queries, which are required in
web-programming.

# To start the console program:
# ( Assuming you have mysql installed in C:\MySQL\ )
# ( Assuming you have not set up the root password yet )
# ( If you have root password use: mysql -u root -p )

C:\> cd c:\mysql\bin\
c:\mysql\bin> mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 129 to server version: 3.23.49-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

# When you see this, you are in mysql console and you can
# for example create a database, select database, create table there
# insert data into table, and select the data,
# and finally we will drop the database, which will destroy
# the tables, inserted data and database. Of course if you are
# doing something for real life, you don't need to drop database,
# it is just to remove our test-database. Be carefull not to
# drop mysql database with this command.:

mysql> create database mydatabasename;
Query OK, 1 row affected (0.01 sec)

mysql> use mydatabasename;
Database changed

mysql> create table mytablename( id int unsigned, name varchar(255) );
Query OK, 0 rows affected (0.00 sec)

mysql> insert into mytablename values( 1, 'Jack' );
Query OK, 1 row affected (0.00 sec)

mysql> insert into mytablename values( 2, 'Lisa' );
Query OK, 1 row affected (0.00 sec)

mysql> select * from mytablename;
+------+------+
| id | name |
+------+------+
| 1 | Jack |
| 2 | Lisa |
+------+------+
2 rows in set (0.01 sec)

mysql> drop database mydatabasename;
Query OK, 3 rows affected (0.00 sec)



If you fail to do all that, please tell us where it fails and we will
see if we can fix that problem.

What comes to GUI programs, I don't know much about them, since I don't
use them. However someone else might answer to that question, or you
could try searching the answer for example with Google.

[Jeff North]

Re: New to MySQL and I'm confused!

On Tue, 20 Jan 2004 03:16:42 GMT, in mailing.databas e.mysql "w_curtis"
<anon@yahoo.com > wrote:
[color=blue]
>| I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
>| some web databases. But it just isn't clicking.
>|
>| I've followed some tutorials, and picked up a book, but just getting to
>| square one has been a pain. I can follow the tutorials and get to the point
>| where I can make tables and stuff, but I don't know how I got there, or what
>| to do if something changes that makes it different than the tutorial.[/color]

MSAccess hides a lot of the table creation and manipulation commands
from you.

If you have the mysql help file look under create table, alter table,
update table and drop table for starters.
[color=blue]
>| MySQL doesn't seem to be like any other program I've used. Usually, I can
>| install a program, and then there's a little icon on my desktop, I click on
>| it, and there is the program.[/color]

That's all you need. To access the database you need to use the
command-line prompt.
[color=blue]
>| But with MySQL, I install it, and it starts running as a service, but I
>| still can't see it. So I have to use a command prompt to talk to it. But
>| the commands to do this are anything but intuitive, and the tutorials I've
>| seen (from DevShed, the official site, and a few others) gloss over this
>| part like I'm already supposed to know how it works. Sometimes, I can get
>| it to work, and sometimes I can't. Users, passwords, ports, And this is
>| on my own computer. I don't even want to think of what this is like on a
>| network, or the internet. Or trying to get a program to talk to it
>| automatically.[/color]

mySQL needs to know where the database is (-host) who you are and what
privileges you have(-user) and if your a valid user (-password).

Unlike Access, mysql can contain many databases so you need to tell
mysql which one you want to work on.
[color=blue]
>| Is there a good primer on the mechanics of how I'm supposed to actually
>| interface with this program? Can I skip the whole command-line thing and
>| just get a GUI? I imagine I'll still need to know about connecting and
>| stuff with a GUI.[/color]

If you want a GUI interface then try:

http://www.mysql.com/downloads/mysqlcc.html

If you want a php/web interface try:

http://www.phpmyadmin.net/home_page/

mySQL off-line help files:

http://www.mysql.com/documentation/index.html

You'll also need the ODBC driver if you plan to link to MSAccess
database:

http://www.mysql.com/downloads/api-myodbc-3.51.html

Once you've mastered these then you will need to know how to create
DSN or DSN-less connections. www.asp101.com is a good source.

Tip: when creating (complex) queries for you web pages I would stick
to using MSAccess query builder and copy/paste the sql statement.
Create a DSN connection, create a new database and link the mysql
tables to the access database. This will allow you to use MSAccess as
the front-end for adding data and writing queries. Because the tables
are linked you can not edit them.
---------------------------------------------------------------
jnorth@yourpant sbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Jeff North]

Re: New to MySQL and I'm confused!

On Tue, 20 Jan 2004 03:16:42 GMT, in mailing.databas e.mysql "w_curtis"
<anon@yahoo.com > wrote:
[color=blue]
>| I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
>| some web databases. But it just isn't clicking.
>|
>| I've followed some tutorials, and picked up a book, but just getting to
>| square one has been a pain. I can follow the tutorials and get to the point
>| where I can make tables and stuff, but I don't know how I got there, or what
>| to do if something changes that makes it different than the tutorial.[/color]

MSAccess hides a lot of the table creation and manipulation commands
from you.

If you have the mysql help file look under create table, alter table,
update table and drop table for starters.
[color=blue]
>| MySQL doesn't seem to be like any other program I've used. Usually, I can
>| install a program, and then there's a little icon on my desktop, I click on
>| it, and there is the program.[/color]

That's all you need. To access the database you need to use the
command-line prompt.
[color=blue]
>| But with MySQL, I install it, and it starts running as a service, but I
>| still can't see it. So I have to use a command prompt to talk to it. But
>| the commands to do this are anything but intuitive, and the tutorials I've
>| seen (from DevShed, the official site, and a few others) gloss over this
>| part like I'm already supposed to know how it works. Sometimes, I can get
>| it to work, and sometimes I can't. Users, passwords, ports, And this is
>| on my own computer. I don't even want to think of what this is like on a
>| network, or the internet. Or trying to get a program to talk to it
>| automatically.[/color]

mySQL needs to know where the database is (-host) who you are and what
privileges you have(-user) and if your a valid user (-password).

Unlike Access, mysql can contain many databases so you need to tell
mysql which one you want to work on.
[color=blue]
>| Is there a good primer on the mechanics of how I'm supposed to actually
>| interface with this program? Can I skip the whole command-line thing and
>| just get a GUI? I imagine I'll still need to know about connecting and
>| stuff with a GUI.[/color]

If you want a GUI interface then try:

http://www.mysql.com/downloads/mysqlcc.html

If you want a php/web interface try:

http://www.phpmyadmin.net/home_page/

mySQL off-line help files:

http://www.mysql.com/documentation/index.html

You'll also need the ODBC driver if you plan to link to MSAccess
database:

http://www.mysql.com/downloads/api-myodbc-3.51.html

Once you've mastered these then you will need to know how to create
DSN or DSN-less connections. www.asp101.com is a good source.

Tip: when creating (complex) queries for you web pages I would stick
to using MSAccess query builder and copy/paste the sql statement.
Create a DSN connection, create a new database and link the mysql
tables to the access database. This will allow you to use MSAccess as
the front-end for adding data and writing queries. Because the tables
are linked you can not edit them.
---------------------------------------------------------------
jnorth@yourpant sbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Ed Seedhouse]

Re: New to MySQL and I'm confused!

On Tue, 20 Jan 2004 09:04:50 +0000, Aggro wrote:
[color=blue]
> w_curtis wrote:[/color]
[color=blue][color=green]
>> I'm an Access user, and I'm trying to learn MySQL and then
>> PHP so I can make some web databases. But it just isn't
>> clicking.[/color][/color]
[color=blue]
> That is true, and it is because MySQL is a real database,
> while Access is just a toy (looks nice, but you can't do
> much usefull stuff with it) IMHO.[/color]

That's just silly. I'm a big MySQL fan, but calling Access a
"toy" is nonsense. For one thing Access is actually, at present,
more truly a "relational " database than MySQL.

Big problem with Access is it's data storage engine, (jet) which
fails to scale well to decenly big databases. Combine it with a
server back end and that problem pretty well goes away. Too bad
the designed in back end that reallt works well with it is Microsoft
SQL Server which costs the really big bucks.

That doesn't change the fact that combined with SQL Server, Access
can and does work great on some really big database systems.

Access can be combined with MySQL via MyODBC and works quite well
as a front end tool. Unfortunately the ODBC interface to MySQL
adds it's own limitations to the system.

Still, I have found it easier to write an administration front end
for most of my MySQL/PHP/HTML projects using Access than to try to
write it in PHP/MySQL. PhpMyAdmin is unfortunately not yet to the
point where I can use it to allow a newcomer to databases to
administer a database system I've set up for them. Access has tools
that allow me to do this quickly and easily such that someone who
has never used a database system before can be trained to administer
the data quite quickly.

For someone moving "up" from Access to MySQL the transition really
requires learning *three* languages and that's not easy. You have
to learn SQL, PHP or Perl, and then you have to learn to make
HTML web pages.

[Ed Seedhouse]

Re: New to MySQL and I'm confused!

On Tue, 20 Jan 2004 09:04:50 +0000, Aggro wrote:
[color=blue]
> w_curtis wrote:[/color]
[color=blue][color=green]
>> I'm an Access user, and I'm trying to learn MySQL and then
>> PHP so I can make some web databases. But it just isn't
>> clicking.[/color][/color]
[color=blue]
> That is true, and it is because MySQL is a real database,
> while Access is just a toy (looks nice, but you can't do
> much usefull stuff with it) IMHO.[/color]

That's just silly. I'm a big MySQL fan, but calling Access a
"toy" is nonsense. For one thing Access is actually, at present,
more truly a "relational " database than MySQL.

Big problem with Access is it's data storage engine, (jet) which
fails to scale well to decenly big databases. Combine it with a
server back end and that problem pretty well goes away. Too bad
the designed in back end that reallt works well with it is Microsoft
SQL Server which costs the really big bucks.

That doesn't change the fact that combined with SQL Server, Access
can and does work great on some really big database systems.

Access can be combined with MySQL via MyODBC and works quite well
as a front end tool. Unfortunately the ODBC interface to MySQL
adds it's own limitations to the system.

Still, I have found it easier to write an administration front end
for most of my MySQL/PHP/HTML projects using Access than to try to
write it in PHP/MySQL. PhpMyAdmin is unfortunately not yet to the
point where I can use it to allow a newcomer to databases to
administer a database system I've set up for them. Access has tools
that allow me to do this quickly and easily such that someone who
has never used a database system before can be trained to administer
the data quite quickly.

For someone moving "up" from Access to MySQL the transition really
requires learning *three* languages and that's not easy. You have
to learn SQL, PHP or Perl, and then you have to learn to make
HTML web pages.

[Jeff North]

Re: New to MySQL and I'm confused!

On Tue, 20 Jan 2004 03:16:42 GMT, in mailing.databas e.mysql "w_curtis"
<anon@yahoo.com > wrote:
[color=blue]
>| I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
>| some web databases. But it just isn't clicking.
>|
>| I've followed some tutorials, and picked up a book, but just getting to
>| square one has been a pain. I can follow the tutorials and get to the point
>| where I can make tables and stuff, but I don't know how I got there, or what
>| to do if something changes that makes it different than the tutorial.[/color]

MSAccess hides a lot of the table creation and manipulation commands
from you.

If you have the mysql help file look under create table, alter table,
update table and drop table for starters.
[color=blue]
>| MySQL doesn't seem to be like any other program I've used. Usually, I can
>| install a program, and then there's a little icon on my desktop, I click on
>| it, and there is the program.[/color]

That's all you need. To access the database you need to use the
command-line prompt.
[color=blue]
>| But with MySQL, I install it, and it starts running as a service, but I
>| still can't see it. So I have to use a command prompt to talk to it. But
>| the commands to do this are anything but intuitive, and the tutorials I've
>| seen (from DevShed, the official site, and a few others) gloss over this
>| part like I'm already supposed to know how it works. Sometimes, I can get
>| it to work, and sometimes I can't. Users, passwords, ports, And this is
>| on my own computer. I don't even want to think of what this is like on a
>| network, or the internet. Or trying to get a program to talk to it
>| automatically.[/color]

mySQL needs to know where the database is (-host) who you are and what
privileges you have(-user) and if your a valid user (-password).

Unlike Access, mysql can contain many databases so you need to tell
mysql which one you want to work on.
[color=blue]
>| Is there a good primer on the mechanics of how I'm supposed to actually
>| interface with this program? Can I skip the whole command-line thing and
>| just get a GUI? I imagine I'll still need to know about connecting and
>| stuff with a GUI.[/color]

If you want a GUI interface then try:

http://www.mysql.com/downloads/mysqlcc.html

If you want a php/web interface try:

http://www.phpmyadmin.net/home_page/

mySQL off-line help files:

http://www.mysql.com/documentation/index.html

You'll also need the ODBC driver if you plan to link to MSAccess
database:

http://www.mysql.com/downloads/api-myodbc-3.51.html

Once you've mastered these then you will need to know how to create
DSN or DSN-less connections. www.asp101.com is a good source.

Tip: when creating (complex) queries for you web pages I would stick
to using MSAccess query builder and copy/paste the sql statement.
Create a DSN connection, create a new database and link the mysql
tables to the access database. This will allow you to use MSAccess as
the front-end for adding data and writing queries. Because the tables
are linked you can not edit them.
---------------------------------------------------------------
jnorth@yourpant sbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Andrew DeFaria]

Re: New to MySQL and I'm confused!

Ed Seedhouse wrote:
[color=blue]
> For someone moving "up" from Access to MySQL the transition really
> requires learning *three* languages and that's not easy. You have to
> learn SQL, PHP or Perl, and then you have to learn to make HTML web pages.[/color]

That's making the assumption that the goal is to have an HTML page and
to manipulate a DB on the other end. Seems to me that even Access users,
given such requirements, would need to learn SQL, a programming
language and HTML to do the same.

--
3 kinds of people: those who can count & those who can't.

[Andrew DeFaria]

Re: New to MySQL and I'm confused!

Ed Seedhouse wrote:
[color=blue]
> For someone moving "up" from Access to MySQL the transition really
> requires learning *three* languages and that's not easy. You have to
> learn SQL, PHP or Perl, and then you have to learn to make HTML web pages.[/color]

That's making the assumption that the goal is to have an HTML page and
to manipulate a DB on the other end. Seems to me that even Access users,
given such requirements, would need to learn SQL, a programming
language and HTML to do the same.

--
3 kinds of people: those who can count & those who can't.

[Ed Seedhouse]

Re: New to MySQL and I'm confused!

On Tue, 20 Jan 2004 09:04:50 +0000, Aggro wrote:
[color=blue]
> w_curtis wrote:[/color]
[color=blue][color=green]
>> I'm an Access user, and I'm trying to learn MySQL and then
>> PHP so I can make some web databases. But it just isn't
>> clicking.[/color][/color]
[color=blue]
> That is true, and it is because MySQL is a real database,
> while Access is just a toy (looks nice, but you can't do
> much usefull stuff with it) IMHO.[/color]

That's just silly. I'm a big MySQL fan, but calling Access a
"toy" is nonsense. For one thing Access is actually, at present,
more truly a "relational " database than MySQL.

Big problem with Access is it's data storage engine, (jet) which
fails to scale well to decenly big databases. Combine it with a
server back end and that problem pretty well goes away. Too bad
the designed in back end that reallt works well with it is Microsoft
SQL Server which costs the really big bucks.

That doesn't change the fact that combined with SQL Server, Access
can and does work great on some really big database systems.

Access can be combined with MySQL via MyODBC and works quite well
as a front end tool. Unfortunately the ODBC interface to MySQL
adds it's own limitations to the system.

Still, I have found it easier to write an administration front end
for most of my MySQL/PHP/HTML projects using Access than to try to
write it in PHP/MySQL. PhpMyAdmin is unfortunately not yet to the
point where I can use it to allow a newcomer to databases to
administer a database system I've set up for them. Access has tools
that allow me to do this quickly and easily such that someone who
has never used a database system before can be trained to administer
the data quite quickly.

For someone moving "up" from Access to MySQL the transition really
requires learning *three* languages and that's not easy. You have
to learn SQL, PHP or Perl, and then you have to learn to make
HTML web pages.

[Ed Seedhouse]

Re: New to MySQL and I'm confused!

On Tue, 20 Jan 2004 10:32:22 -0800, Andrew DeFaria wrote:
[color=blue]
> Ed Seedhouse wrote:
>[color=green]
>> For someone moving "up" from Access to MySQL the
>> transition really requires learning *three* languages
>> and that's not easy. You have to learn SQL, PHP or Perl,
>> and then you have to learn to make HTML web pages.[/color][/color]
[color=blue]
> That's making the assumption that the goal is to have an HTML
> page and to manipulate a DB on the other end. Seems to me that
> even Access users, given such requirements, would need to learn
> SQL, a programming language and HTML to do the same.[/color]

Actually Access can create dynamic web pages from an Access database
if you don't mind a fairly ugly and simplistic result. I prefer to
use PHP to create dynamic web pages, personally, but it can be done,
after a fashion, from Access just by point and click if you'll accept
the defaults.

Ed

[Ed Seedhouse]

Re: New to MySQL and I'm confused!

On Tue, 20 Jan 2004 10:32:22 -0800, Andrew DeFaria wrote:
[color=blue]
> Ed Seedhouse wrote:
>[color=green]
>> For someone moving "up" from Access to MySQL the
>> transition really requires learning *three* languages
>> and that's not easy. You have to learn SQL, PHP or Perl,
>> and then you have to learn to make HTML web pages.[/color][/color]
[color=blue]
> That's making the assumption that the goal is to have an HTML
> page and to manipulate a DB on the other end. Seems to me that
> even Access users, given such requirements, would need to learn
> SQL, a programming language and HTML to do the same.[/color]

Actually Access can create dynamic web pages from an Access database
if you don't mind a fairly ugly and simplistic result. I prefer to
use PHP to create dynamic web pages, personally, but it can be done,
after a fashion, from Access just by point and click if you'll accept
the defaults.

Ed

[Andrew DeFaria]

Re: New to MySQL and I'm confused!

Ed Seedhouse wrote:
[color=blue]
> Actually Access can create dynamic web pages from an Access database
> if you don't mind a fairly ugly and simplistic result. I prefer to use
> PHP to create dynamic web pages, personally, but it can be done, after
> a fashion, from Access just by point and click if you'll accept the
> defaults.[/color]

Just goes to show you how much I know about Access (i.e. nothing).
However, realistically, if you are going to develop web pages that
access databases for real you're gonna have to learn at at least those
languages (if not more or different sets).
--
E-mail returned to sender -- insufficient voltage.