...
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 ...
... = JFactory::getDbo()->updateObject('#__users', $user_record, 'id');
// equivalent to UPDATE #__users SET name='Joel', username='jlipman' WHERE id=42
DELETE
Note: for Joomla v3.x, use db->execute() ...
... on the server itself. (ie. Fast & Reliable)
Compress/backup LIVE files to ZIP file.
Export LIVE database to SQL file. (Export > Custom > Save output to file)
Except for configuration.php, delete ...
... SET SQLStatement = 'SELECT * INTO SearchTMP FROM ' + Tablename + ' WHERE ' + substring(WHEREClause,1,len(WHEREClause)-5)
DELETE FROM @SQLTbl
WHERE WHEREClause IS NULL
...
... "Outside Group - Below".
Delete the row with the left parenthesis
Click on the dropdown of "Data" and select "TimeStamp".
Click in the left of that column and type the word "TimeStamp".
Right-click ...
... another dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in the order you want them to load) to get the timestamp of when the queries started. ...
... just been created (usually "Group1") by clicking the grey part above it
Delete this column. Check that the grouping grey part (a giant parenthesis) is still there.
Right-click on the grey header of ...
... ipconfig /all IP Configuration (Display DNS Cache Contents) ipconfig /displaydns IP Configuration (Delete DNS Cache Contents) ipconfig /flushdns IP Configuration (Release All Connections) ipconfig /release ...
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.