August 19, 08 by Gabi Solomon
I wanted to do add a new column to a table and to copy the values from that a diferent to column ( from the same table ) to the new column. And even though i thought of very integrates query's at first, the solution was quite simple 
( as always ).
SQL:
-
ALTER TABLE `table_name` ADD `new_column` TEXT NOT NULL;
-
UPDATE `table_name` SET `new_column` = `old_column`;
Nice and simple.
Cheers
June 30, 08 by Gabi Solomon
Thanks to a Chris Pirillo video i recently discoverd a new website that some of you could find interesting. This is Tinypaste. The ideea beside this site is to transform a big text you want to send to someone into a tiny URL.
This is similar to the tinyurl.com service just that is intended for text instead of URL's.
The site is very simple to use, you just copy & paste your text into the textbox and pres submit and you get the URL. This should really come in handy when you have large bits of text from a document or a webpage that you want to send fast to a friend online.
Tinypaste also come with a Firefox Extension. Using the extension you can post the text from a webpage, by selecting it and click “Tinypaste selected text” from the right click menu and you will receive your link, pretty nit huh ?
Hope you find this interesting also,
Cheers.
