Access MySQL databases using Oracle SQL Developer
So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04.
Knowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search342 entries / matching Data
Clear filters
Cheat Sheet for mySQL vs t-SQL
Some memory aids for me so that I don't have to keep looking them up:
JDatabase: using the Joomla database with examples
Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for v1.5.x and for v2.5.x This article applies to...
Proposed Budget i3 PC under £200
i3 workstation upgrade running Windows 7 So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is that our workstations need upgrading (it always is). So on a budget (i...
Delete related records from multiple tables
So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements.
Setup a copy of your Joomla website
More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They experiment on their customer-facing website and in most cases, they are pay...
Error 1065: Query was Empty
In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common.
DataScramble - Randomizing data rows
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before...
DataTumble - Randomize Data Rows
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User 1964-02-18 After: ID Name DateOfBirth...
Loading more notes...
No more notes to load.