Applies to:
MySQL Database v5.0.45
MySQL Workbench v6.0.8.11354 build 833
What?
This is a quick article on how to get around the problem of backing up your MySQL database when attempting to ...
What?
A quick article on how to use the where clause in a joomla database query.
Why?
In response to a member, I use the old form where I can include the whole SQL statement:
$db->query('SELECT ...
... It might seem trivial but these little aesthetic changes done at the database level can save some time.
Why?
I have an Excel report which dynamically gets its content from a data source located ...
What?
This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate ...
... Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages and VS2010 for database solutions running against SQL Server 2008 R2. We can use VS2012 for both but this requires upgrading all the packages ...
What?
So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...
... in a database and rather than a separate file, it stores these in a row.
How?
Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS":
123456 ...
...
Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about ...
... allows the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS.
How?
I could just type a query on the database and get the same result, but this script ...
... access to a component? A load of blab on ACL managers?
How?
In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.