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]

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]

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.

[Tormod]

I guess your web host should have a tutorial somewhere if they offer myphpadmin.

[alexander]

google request for a phpmyadmin tutorial revealed this:

http://www.google.com/search?q=phpmyadmin+tutorial&sourceid=mozilla-search&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official

[TINNY]

that was easy, but i didn't get such results when i googled the exact keywords before.

[TINNY]

oh, i just discovered that the faqs for phpmyadmin are right on the first page of my phpmyadmin folder!

(i just started all this php thing this week..)

[alexander]

Hey, its better than someone starting an ASP or JavaScript thread here, i got shivers just from thinking about those... But PHP is awesome, by far the best server-side programming language!

[alexander]

that was easy, but i didn't get such results when i googled the exact keywords before.[/Quote]

I guess i just got lucky...

[TINNY]

javascript is client-side right? just asking.. :)