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");

What is serializable?

1089

---

What is importing utility?

1038

---

What are the benefits and tasks of object explorer? : sql server management studio

1250

---

What are trace flags and mention a few common trace flags used with sql server?

1137

---

Explain Normalization and DE normalization

1160

---

Explain the properties of the relational tables?

1029

---

What is dbcc updateusage?

1257

---

What is database architecture? : SQL Server Architecture

1099

---

List types of tables in SQL Azure?

128

---

How do I setup a local sql server database?

1070

---

Explain the disadvantages of cursors?

1205

---

What is sql server query analyzer?

1098

---

What is a partition function in sql server?

1216

---

How to create an inline table-valued function?

1021

---

What is difference between getdate and sysdatetime in sql server 2008?

1099

---