How to Test database in Manually?

[eventplanner]

How to Test database in Manually?

 

[Turnkey FX]

We can play with queries to insert, update and delete the data from the data base and check in the front end of the application.

 

[ahsanhabibcx]

The database can be tested various ways, If we are using SQL server then open the SQL query analyzer and write the queries to retrieve the data. Then verify whether the expected result is correct or not. IF not the data is not inserted into the database. We can play with queries to insert, update and delete the data.

 

[JamesLeeOnline]

i want to break this up ...
This database is an English dictionary intended for word semantics writing and analysis.

mysql> select * from entries where definition regexp 'devoted';
(too many returns for an example post)
117 rows in set (0.87 sec)
(limits 5 rows)
mysql> select * from entries where definition regexp 'devoted' limit 5;

| word       | wordtype | definition                                                                                
| Abbey      | n.       | A monastery or society of persons of either sex, secluded
   from the world and devoted to religion and celibacy; also, the monastic
   building or buildings.                                                                    |
| Addict     | p. p.    | Addicted; devoted.                                                                                                                                                                                                                |
| Adhere     | v. i.    | To hold, be attached, or devoted; to remain fixed,
   either by personal union or conformity of faith, principle, or opinion;
   as, men adhere to a party, a cause, a leader, a church.                                          |
| Antiquary  | n.       | One devoted to the study of ancient times through their
   relics, as inscriptions, monuments, remains of ancient habitations,
   statues, coins, manuscripts, etc.; one who searches for and studies the
   relics of antiquity. |
| Apolaustic | a.       | Devoted to enjoyment.                                                                                                                                                                                                    
5 rows in set (0.04 sec)

mysql>

Basically, you can execute any command or query in the mysql monitor that you have grant permission for granted by the mysql root user

Great mate .. thank you very much for this

 

[TerryShop]

Which is the best way to test database?

 

[martinsmith]

Database can be tested in many ways you can insert, Update and Delete the data and you can retrieve the results using some queries..

 

[Eve Jones]

Just Google it, you will find many ways to do it