Sql

[TINNY]

I created this thread so that I can ask questions when i stumble upon problems with SQL.

so the first question is Can I add an additional column on an existing database? How?

[Tormod]

It does depend slightly on which database you are using.

Here is how you add a column to a table in MySQL:

ALTER TABLE tablename ADD columnnate data_type;

Example:

ALTER TABLE Customers ADD Last_Name VARCHAR(30);

[TINNY]

COOL!!! That's great if it works. I'll try it later on.
that'd saved me a lot

[TINNY]

what is the use of Indices and how to use them?

[Tormod]

You might want to check out this:

http://dev.mysql.com/doc/mysql/en/Tutorial.html

and

http://dev.mysql.com/doc/mysql/en/SQL_Syntax.html

[TINNY]

Thanks! I never knew there existed such a site.

[TINNY]

where can i find tutorials for phpMyAdmin?

[TINNY]

might as well ask another,
how do i redirect a visitor to another page using client-side scripting?

[Tormod]

Originally Posted by TINNY

might as well ask another,
how do i redirect a visitor to another page using client-side scripting?

This has nothing to do with SQL. Try to keep the topics separate or it will be impossible to help you out.

[Tormod]

Originally Posted by TINNY

where can i find tutorials for phpMyAdmin?

I'm not sure. I couldn't find any on the web. When I work with MySQL I never use myphpadmin except for very basic tasks, because I like to work with programs that have a clear GUI and can do things like backup my database to my local machine and see tables and data in a more practical way.

So I use this program:

MySQL Manager
http://www.ems-hitech.com/mymanager/

But I think MySQL.com are offering some free tools that do basically the same now.

Maybe Alexander or someone else can be more helpful here.