Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming alter is required, the following 6 results were found.

  1. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    list as you will import them all!) -- DELETE FROM `v34_db`.`v34_contact_details` WHERE `v34_contact_details`.`id` >= 1 -- ALTER TABLE `v34_db`.`v34_contact_details` AUTO_INCREMENT = 1 -- Content: UPDATE `v34_db`.`v34_content` SET `created_by` =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  2. Modifying columns in a tablehttps://joellipman.com/articles/database/modifying-columns-in-a-table.html

    I've made better DBMS tools). All SQL -- Add a column to an existing table (giving it datatype char(2) and allowing NULL) ALTER TABLE myTable ADD myColumn CHAR(2) NULL -- Delete a column ALTER TABLE myTable DROP COLUMN myColumn -- Reorder a column ALTER...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  3. Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

    use whatever is most useful and Google's Chrome is the fastest browser I have. Here are some ways to do this: Method: MySQL ALTER TABLE table_name MODIFY COLUMN misplaced_column AFTER other_column; NOTE that annoyingly the column doesn't retain the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  4. Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    SET @SqlToExecute = ''; -- Declare temporary table to use CREATE TABLE #myScrambledTable (dummyIndex INT); -- Alter temporary table structure to match given table SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  5. Prices get rounded up in Virtuemarthttps://joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    suggesting to change the number_format to convert any number to a currency or two decimal places. Another suggestion was to alter the main virtuemart database table (jos_vm_prodcut_price)... Don't do any of these things! After modifying tax rates and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *

  6. Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    following to your header This does nothing: // set the collation of the database and any text fields to 'utf8-general-ci' ALTER DATABASE db_name CHARACTER SET latin1 COLLATE utf8-general-ci; // set text fields to utf8 SET NAMES 'utf8'; This does...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 1 - 6 of 6

Joes Word Cloud

Please publish modules in offcanvas position.