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 sql server executes a statement with nested subqueries?

1032

---

What is change data capture (cdc) in sql server 2008?

1027

---

Explain DBCC?

967

---

What is indexed view?

984

---

What is normalization and what are the advantages of it?

987

---

Which table keeps the locking information?

931

---

How do I start and stop sql server?

1027

---

Do you know what is a linked server in sql server?

1029

---

What are group functions in query statements in ms sql server?

1010

---

What are the differences between clustered and non-clustered index?

1033

---

What is difference between joins and subqueries?

1121

---

How to resolve the orphan use problem? : sql server security

1019

---

what is the difference between delete table and truncate table commands? : Sql server database administration

1040

---

How you can get a list of all the table constraints in a database?

956

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1151

---