Namaste UIWe found 884 results for your search.
To maintain MySQL Database tables efficiently you need to analysis, optimize, check and repair database tables frequently. Tips for Maintaining MySQL Database Tables: Analyze table: analyze the table for optimize. ANALYZE TABLE table_name; Optimize table: avoid defragmenting problem. OPTIMIZE TABLE table_name; Check table: check if something wrong happen to the database server. CHECK TABLE table_name; […]
Image sprite is nothing but a collection of images put into a single image. When web page loads then for a particular location we show particular position of a image. For multiple images it takes time to load on a server. That is why we use single image for multiple position to save bandwidth. In […]
Sometimes it is very tough for them who owned the website but can not modify any part of it. Rarely a non-technical person does it. You need a HTML Tricks. For any internet marketers, it should know as well as easily learn. You do not have to a web developer rather than a web researcher. […]
jQuery uses $ as a alias or shortcut. So if you use another javascript library (like prototype, mootools etc) that uses same alias then you are in a jQuery conflicts situation. Use no-conflict mode to avoid jQuery conflicts: You have to use a new variable name to replace with jQuery $.For e.g. <script src=”jquery.js”></script> <script […]
Using MySQL SELECT statement you can fetch combination of columns and rows from tables or views, known as a result set. This is the one of the most commonly used queries in MySQL to get data from the MySQL database. You can add or use one or more tables i.e. separated by comma for including various […]
MyISAM vs Innodb – both are commonly used engines on MySQL servers and they both have their unique advantages and disadvantages against each other. MyISAM is the default storage engine type for MySQL 5.0 but the Cloud Sites environment defaults the storage engine to Innodb. MyISAM vs Innodb: MyISAM: Table level locking.Innodb: Row level locking. […]
To group rows into subgroup by one or more values of columns we use MySQL GROUP BY. Suppose in user table same country name exists for many times for different user. So if we use GROUP BY for country column to a SELECT query then only unique country will be listed. EXAMPLE: SELECT * FROM […]
A segment of declarative SQL statements which is stored inside the database catalog is called stored procedures, invoked by a triggers. Advantages: When stored procedures are created it is compiled and stored in the database so that when it is called multiple times then the compiled version is used. It is very secure. It is […]
To format html text several elements are used. Now day we can do this by css style. But you can still use html element for formatting. Text Formatting types: <pre> Element:<pre>The quick brown fox jumps over the lazy dog</pre> <del> ElementThe quick brown fox <del>jumps</del> over the lazy dog <sup> Element<p> The quick brown fox […]
To store a temporary result set you can use a special type of table i.e. called MySQL temporary table. To keep temporary data, the temporary tables could be very useful in some cases. When the current client session terminates, the temporary tables is deleted. This is useful for stored procedures, join query etc. Temporary tables […]