This is a project about dumping MySQL data into XML file using parser that is being implemented by our team.If for some reason database crashes then we are able to retrieve data from XML file by using reverse parser in MySQL table form.As XML is itâ„¢s own DTD for specific kind of data structure for that reason of project is conceptual for only specific kind of database.It cannot be generalized as every database is having itâ„¢s own features
Technologies used: PHP , MySQL ,WAMP software.
any details on this please advice
The SELECT statement is used to pull information from a table
The general form of the statement is:
what_to_select is what you want to see.
what_to_select can be a list of columns
* to indicate "all columns."
which_table is the table name list.
The WHERE clause is optional.
If where clause is present, conditions_to_satisfy specifies conditions that rows must satisfy.
The basic SELECT statement syntax
SELECT columns FROM table [WHERE (condition)]
The WHERE condition is in square brackets as it is optional.
The statement is 'complete' when a semi-colon is typed at the end.
-> This is a continuation line allowing you to enter a long statement over several lines.
To display all the data from the 'employee' table we would issue the following command (where '*' is the wildcard symbol for all).
select * from Employee;
Conditions can be combined to achieve better filtering of results
SELECT * FROM employee WHERE ((employee.id = 2) AND (employee.city = 'Vancouver'));
I need to know how exactly it can be done.
Please explain in detail.