Answer Posted / shrikant

mysql> CREATE DATABASE first_test;
Query OK, 1 row affected (0.31 sec)
mysql> USE first_test;
Database changed
mysql> CREATE TABLE people (
id int UNIQUE NOT NULL,
first_name varchar(40),
surname varchar(50),
PRIMARY KEY(id)
);
Query OK, 0 rows affected (0.24 sec)
mysql> INSERT INTO people VALUES(1,'Ann','Brache');
Query OK, 1 row affected (0.09 sec)
mysql> INSERT INTO people VALUES(2,'Narcizo','Levy');
Query OK, 1 row affected (0.02 sec)
mysql> INSERT INTO people VALUES(3,'Tony','Crocker');
Query OK, 1 row affected (0.00 sec)

Your table should now look as follows:

mysql> SELECT * FROM people;
+----+------------+---------+
| id | first_name | surname |
+----+------------+---------+
| 1 | Ann | Brache |
| 2 | Narcizo | Levy |
| 3 | Tony | Crocker |
+----+------------+---------+
and for connecting

<?php
$username = "username";
$password = "password";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");

How to create an index on a view?

1058

---

How you trouble shoot when any job fails

1924

---

What is policy based management (pbm)? : sql server database administration

968

---

What are the five characteristics of good data?

906

---

What does REVERT do in SQL Server 2005?

947

---

Can foreign key be duplicate?

1044

---

What do you understand by recursive stored procedures?

978

---

What is b tree index?

909

---

How to count rows with the count(*) function in ms sql server?

1003

---

How will you make an attribute not process? : sql server analysis services, ssas

1074

---

Tell me what is the stuff and how does it differ from the replace function?

976

---

How to list all triggers in the database with sys.triggers in ms sql server?

1061

---

What is the maximum size per database for sql server express?

1033

---

What are the dmvs? : sql server database administration

1045

---

What is tempdb in sql server?

960

---