mysql
Chandresh Kumar Chhatlani (A Computer Programmer / Software Developer in Udaipur, Rajasthan, India)
Submitted by chandresh_kumar on Tue, 04/20/2010 - 18:43.
Chandresh Kumar Chhatlani (Software & Web Developer)
Contact Me for any IT Related Work e.g., Software Development, Website Development, Web Designing, Hardware, Network issue, KPO, BPO, Training, etc.
I have developed more that 100 software and more than 35 websites.
Chandresh Kumar Chhatlani (A Computer Programmer / Software Developer in Udaipur, Rajasthan, India)
Submitted by chandresh_kumar on Tue, 04/20/2010 - 18:41.
handresh Kumar Chhatlani (Software & Web Developer)
Contact Me for any IT Related Work e.g., Software Development, Website Development, Web Designing, Hardware, Network issue, KPO, BPO, Training, etc.
I have developed more that 100 software and more than 35 websites.
Chandresh Kumar Chhatlani (A Computer Programmer / Software Developer in Udaipur, Rajasthan, India)
Submitted by chandresh_kumar on Tue, 04/20/2010 - 18:38.
Chandresh Kumar Chhatlani (Software & Web Developer)
Contact Me for any IT Related Work e.g., Software Development, Website Development, Web Designing, Hardware, Network issue, KPO, BPO, Training, etc.
Click And Share This:
Chandresh Kumar Chhatlani (A Compueter Programmer / Website Developer in Udaipur, Rajasthan, India)
Submitted by chandresh_kumar on Tue, 04/20/2010 - 18:25.
Chandresh Kumar Chhatlani (Software & Web Developer)
Contact Me for any IT Related Work
Chandresh Kumar Chhatlani3 PA 46, Prabhat Nagar Sector-5,Hiran Magari, Udaipur (Rajasthan) - IndiaPin: 313 002Contact No.: 91 99285 44749Email: chandresh_kumar@india.comchandresh_2k@yahoo.com
rename table in mysql or sql command statement syntax and example
Submitted by inder on Tue, 12/02/2008 - 21:55.
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
Default passwords for mysql,sql server database for mysql user is root
Submitted by inder on Mon, 11/17/2008 - 14:43.
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
Submitted by inder on Fri, 11/14/2008 - 14:25.
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;
phonebook example in php mysql insert delete confirm basic demo
Submitted by inder on Thu, 11/13/2008 - 06:16.
This is a very basic example of php/mysql.We used to make use of mysql database and a php file for getting this done.To run this code you can first create database as provided in sql here and after creating database run this code.Make modifications as you want to do in it.
<html>
<head>
<title>Phone Book Example</title>
</head>
<body bgcolor="#f6f6f6" style="font-family:arial">
<marquee behavior="alternate">
Preventing MySQL Injection attacks with good PHP code- Using PHP for preventing MySQL injection attacks on your site
Submitted by inder on Thu, 11/13/2008 - 06:14.
A Mysql injection is attack tried by site visitors/users to
get/damage data in databases by taking benefit from poor programming of
websites.An injection attack occurs when a visitor to your site types
something into a form input with the purpose of changing the outcome of
your MySQL query. For example, at a login screen someone may try this
type of attack to gain access to a secure area of the website.
If your query to check the username and password entered by the user was this:
connecting to Mysql using ODBC windows drivers within ASP code file
Submitted by inder on Mon, 11/10/2008 - 19:15.
![[Valid RSS]](http://feedvalidator.org/images/valid-rss.png "Validate my RSS feed")