Namaste UINamaste UI collaborates closely with clients to develop tailored guest posting strategies that align with their unique goals and target audiences. Their commitment to delivering high-quality, niche-specific content ensures that each guest post not only meets but exceeds the expectations of both clients and the hosting platforms. Connect with us on social media for the latest updates on guest posting trends, outreach strategies, and digital marketing tips. For any types of guest posting services, contact us on info[at]namasteui.com.
For making money, online jobs are becoming very popular and easy to maintain around the world. Million of users are using online jobs for making extra income for part time from home. Online Jobs are becoming very popular in India & all over the world for earning Money online from home without any investment. Now […]
Using ‘replace’ you can find and replace text of a column in a table. Example of Replace text: UPDATE `tbl` SET `field_name` = replace(field_name, ‘old_text’, ‘new_text’);
To insert data into tables you can use MySQL INSERT statement. Simple syntax of MySQL INSERT: INSERT INTO table(column1,column2..) VALUES (value1,value2,..), (value1,value2,..); You can also insert from another table also i.e. clone: INSERT INTO tbl_1 SELECT * FROM tbl_2;
WordPress blog is nothing but converting your hobby into business. So by business or profession share your thoughts on a subject you love. Blogging is free and you can create blog on blogger or WordPress. Let’s see how to start a WordPress Blog: Go to http://wordpress.com Fill up the online form. In the blog address […]
Php 5.3 has a solution for ignoring for(), foreach() cycles that will reduce the average number of iteration structures you need to write i.e. array_map. This function in PHP sends each value of an array to a user defined function, and then returns an array with new values that is given by the user defined […]
Using MySQL LIKE operator you can search based on patterns. It is used in the WHERE clause in SELECT statement. This basically use two characters for using the MySQL LIKE operator: ‘%’ – allows you to match zero or more characters‘_’ – allows you to match any single character For searching the first character starts […]
Using MySQL delete state you can delete table data. With a single delete statement you can delete one or more tables data at a time. Example of MySQL DELETE: DELETE FROM users WHERE status = 0; For multiple table: DELETE users, orders FROM users, orders WHERE users.user_id = orders.user_id AND users.status = 0; TRUNCATE TABLE […]
Few Mysql queries that will help you develop websites and resolve complex codes. Here are few Mysql Query tips: Finding 2nd highest salary in employee table SELECT MAX(`salary`) from tbl where `salary` < (select MAX(`salary`) from tbl); Mysql order by FIELD SELECT * FROM tbl ORDER BY FIELD(first_name,’John’) desc, FIELD(last_name,’Doe′) ASC; Show category-parent category SELECT […]
Subquery in MySQL means Query inside another query on SELECT, INSERT, UPDATE or DELETE. A subquery must be enclosed with parentheses and can be used anywhere in an expression. The main advantages of subqueries is that it allow queries that are structured so that, it is possible to isolate each part of the statement and […]
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; […]