Answer / narayana

no idea because its a seperate software

Answer / 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 Trace flag?

1 Answers   Wipro,

---

What are the types of database recovery models?

0 Answers   HCL,

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---

What is difference between index and primary key?

0 Answers  

---

Is foreign key a primary key?

0 Answers  

---

default databases available in sql server and there uses ?

4 Answers   TCS,

---

Tell me what are cursors and when they are useful?

0 Answers  

---

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

---

How to update a field in SQL after ALTERING a row?

0 Answers   Amdocs,

---

How does index makes search faster?

0 Answers   QuestPond,

---