Login To InderWeb ! Just Play !

Username:
Password:

UserSubmittedComments

database

rename table in mysql or sql command statement syntax and example

The RENAME TABLE statement defines a new name for an existing table in the database enviornment
Scope/Usage

Application Programs

SQL Syntax

RENAME TABLE [Owner.] TableName TO NewTableName

Parameters

[Owner.]TableName

Denotes the old table that is to be renamed.You can enclose database owner name in prefix.

NewTableName

    is the new table name.

Description

sql server error code list database management administration

Sql server provides many error codes if you are using sql server as a developer or as a administrator then

you must be familiar with error code that what they mean.Below is list of error codes which i have collectaed.

These error codes can help you a lot in sql server management and administration.

 

Number

Severity

Default passwords for mysql,sql server database for mysql user is root

Mysql:-
Default password is that there is no password. You can log in to mysql

for example with this command:

mysql -u root



There are also ways to change the password and you will find those

methods from the MySQL manual.



http://www.mysql.com/doc/en/index.html

after doing this command on commane prompt:-
mysql -u root




If this brings you to the 'mysql>' prompt then you can set the password to

ALTER table command mysql sql database manipulation adding new column drop column index consrtaint

Definition And Explaination:-
ALTER TABLE allows you to change the structure of an existing table. For example, you can add or delete columns, create indexes, change the type of existing columns, or rename columns or the table itself.You can use ALTER TABLE to modify the structure of a table that has not been added to a database.Alter table command allows
    * To add the field;
    * To delete the field out;
    * To change the DEFAULT value for any of the field;
    * To add or delete the table PRIMARY KEY;

Syndicate content

Popular Tags