Posts
Ontology Linked Data
… The data was stored as HTML. There was no need for a database or a data storage mechanism as the data was fairly static and was very … need for dynamic data on webpages lead to the use of databases. The webpages used databases for storing the dynamic content and user …
Important MySQL DBA Interview Questions
… redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries … values cannot be changed. What are the steps involved in Database Startup? – Start an instance, Mount the Database and Open the …
Customizing Mysql Prompt For multiple Servers
… be useful if it showed the username,hostname, current database and things like that. So how to do this. One method is on login … works for multiple host showing the username,hostname and database. So find this file if it doesn’t exists create a new one and add the …
Group by Date when Stored in Mysql DataBase as Date Time
I have a table called date_count with 2 columns one is a value and another is a date time, say called date_time in mysql. Date Time in mysql is stored as dd-mm-yy hh:mm:ss. The issue comes when I need to get the number of rows per day. As its stored as dat …
Check if a table exists in MySQL from PHP
… the method is simple. Just get the list of tables in a database by using the function mysql_list_tables and iterate thought the list … { // Get a list of tables contained within the database. $result = mysql_list_tables("DBNAME"); $rcount = …
Recent Comments