1. select continent,country,concat("area: ",area," population: ",population) from countries
2. select left(country,1) as lex,country from countries
3. select continent,left(country,1) as lex,concat(country," (",capital,")") from countries
4. select concat(conti.continent," (",FORMAT(sum_pop,0),")") as cont_pop,country,FORMAT(country.population,0) from (select continent,sum(population) as sum_pop from countries group by continent) as conti left join (select continent,country,population from countries) as country on conti.continent=country.continent
Category:
This Database Management Software was built to help you quickly backup and do sql database restore functions, particularly on My SQL databases. Assure DMS most specifically functions as database replication software, that is that it replicates your My SQL data to a sql dump file. While this is not a revolutionary concept, Assure makes it simple, for even the non DB expert. Simply install our database management software, and you can quickly select the databases you wish to backup, should a probe occurred, you will then be able to quickly restore your database in its entirety. All from an easy to use online web based interface.
Category:
PuszBaza - php script written by myself - database
It allows you to use sql functions similar to famous databases Mysql,
Postgresql, etc., but without application of this kind of software
Category: