Posts: 1,061
Threads: 613
Joined: Feb 2010
Description:
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.
Posts: 1
Threads: 0
Joined: Jun 2010
any details on this please advice
Posts: 201
Threads: 4
Joined: Jun 2010
you can find a discussion about this topic in this forum:
http://bytestopic/mysql/answers/625165-insert-xml-file-into-mysql-database
Posts: 2,300
Threads: 878
Joined: Sep 2010
[attachment=6988]
MYSQL
SELECT
The SELECT statement is used to pull information from a table
The general form of the statement is:
SELECT what_to_select
FROM which_table
WHERE conditions_to_satisfy;
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'));
Posts: 1
Threads: 0
Joined: Mar 2011
Hi,
I need to know how exactly it can be done.
Please explain in detail.
Thanks