Fun reading about making databases / the internet faster… With cool drawings and stuff. I love the GOTO 1 reference… Source: Cache is the new RAM
Read More...me.stuff(spin());
Fun reading about making databases / the internet faster… With cool drawings and stuff. I love the GOTO 1 reference… Source: Cache is the new RAM
Read More...SELECT DISTINCT ID, post_title, post_name, guid, post_date, post_content FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON ( p.ID = tr.object_id ) INNER JOIN wp_term_taxonomy AS tt ON ( tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = ‘category’ AND tt.term_id IN ( 16 ) ) ORDER BY id DESC
Read More...So you need to replace text in your wordpress Posts / Pages. Open up PHPMyAdmin and enter this SQL query. First: Export your wp_posts table so you have a backup if this messes stuff up. Always back up your DB before running MySQL commands. SQL: update wp_posts set post_content = replace(post_content, ‘removeText’, ‘replaceText’) where instr(post_content, ‘removeText’) >…
Read More...How to Implement Natural Sorting in MySQLPosted by Dave Rogers // December 20, 2013 // in Blog // 0 CommentsIn the programming world, Natural Sorting is taking a list of things and sorting them, well, the way a human naturally would. Take this list, sorted in natural order, for example:col_name————— test1test2test3test4test5test6test7test8test9test10test11test12MySQL sorting doesn’t work, naturallyIn PHP,…
Read More...Great example of count() and Group By functions in MySQL. In this page we have discussed how to use MySQL COUNT() function with GROUP BY. Example : The following MySQL statement will show number of author for each country. The GROUP BY clause groups all records for each country and then COUNT() function in conjunction…
Read More...Updated Google is migrating its MySQL systems over to MariaDB, allowing the search company to get away from the Oracle-backed open source database. The news came out at the Extremely Large Databases (XLDB) conference in Stanford, California on Wednesday, one month after El Reg reported that Google had assigned one of its engineers to the MariaDB Foundation. News of…
Read More...To many programmers, SQL is a bit of a beast. It is one of the few declarative languages out there, and as such, behaves in entirely different ways from imperative, object-oriented, or even functional languages (although, some say that SQL is also somewhat functional). I’m writing SQL every day, embracing SQL with myOpen Source Software jOOQ. I thus…
Read More...Well Dang… I always felt Oracles ‘purchase’ of Sun and thus MySQL will eventually have a negative effect on MySQL. I started to feel that today when I couldn’t download the new version of MySQL Workbench without signing up as an Oracle Developer… Then I started reading the MySQL Wikipedia page about the history and…
Read More...SQL Buddy – Web based MySQL administration. SQL Buddy is my favorite web-based tool for accessing and managing MySQL databases. PHPMyAdmin alternative – SQL Buddy Rocks!
Read More...I’ve tried a ton. This is the one package that will keep your code moving forward and deliver your project on time
Read More...the new hot shot coder / friend (he really is a solid coder) was calling me out on my database architecture. why do you have redundant data, it’ll slow the database down. you don’t need the data in this table if it’s connected through a join. i was telling him, for display logic, it’s faster…
Read More...In your favorite shell you can export a MySQL database and Import using the following. on Ubuntu, my MySQL databases are located at /var/lib/mysql/database_name To Export a MySQL Database run: mysqldump -v -u username -p database_name > dumpfile.sql To Import a MySQL Database run: mysql -v -u username -p database_name < dumpfile.sql
Read More...i setup a RAID 5 system for our mysql database and wanted to move it over on ubuntu 10. MOVE MYSQL first stop mysql service mysql stop i’m paranoid, so i check the status service mysql status copy your MySQL database files to the new location. in this instance my RAID drive is located at:…
Read More...In my attempt to move the MySQL datadir I have a messed up MySQL installation. Here’s how I’ve completely removed MySQL 5.1 from Ubuntu 10.x. i have a messed up installation and need to completely remove MySQL and re-install it. Warning, this will delete *everything* associated with MySQL on ubuntu! It does give you a…
Read More...