Handy SQL Snips

  • Views Views: 9,361
  • Last updated Last updated:

Navigation

Development - Fabrik-based Web sites
   Application Tutorials - Real Examples
      Community Builder Interests Picklist
   AutoFading System Messages
   Common Javascript Tasks
   Common PHP tasks
      Check age from DoB in PHP
      Days between 2 dates in PHP
   Content type
   Email templates
   Handy SQL Snips
      How to use field records to filter your db_join?
   How do I ... Developer
      Promote from Dev to Production
   Image overrides
   Javascript
      Form Javascript Objects
      JavaScript Window Class
      Javascript: Elements
      List JavaScript
      User ajax
   Javascript common tasks
      Comparing two dates in javascript
      Masking areas whilst ajax updates
      Select a radio / checkbox in JS
      Setting one date depending on an other
   Javascript Interactivity (+)
   Override default Joomla Login page
   PHP helper functions
   Using eval

Wiki index

Page
  • Sub-pages:

    Contents

    These are to be used only when necessary as most of these actions can be achieved via Fabrik itself.

    Please only use these if you are comfortable that you know what they are doing.

    Insert data into columns​

    SQL: 
    INSERT INTO your_table (column1_name, column2_name, column3_name) VALUES (1, 'another value', 450);

    Insert data into multiple columns​

    SQL: 
    INSERT INTO your_table (item_name, item_color)
    
VALUES ('a boingle', 'blue'),
    
        ('a doingle', 'red'),
    
        ('a foingle', 'yellow'),
    
        ('a poingle', 'aqua'),
    
        ('a qoingle', 'green'),
    
        ('a shoingle', 'purple'),
    
        ('a loingle', 'orange');

    Delete a column​

    SQL: 
    ALTER TABLE your_table DROP COLUMN column_name;

    Change the ordering of your columns in the database table​

    SQL: 
    ALTER TABLE table_name CHANGE field_name field_name INT(6) AFTER another_field;
Back
Top