To convert field values with date value but with text type in a spreadsheet.
Choose data > Text to columns..
Choose the delimiter for example “/” and it will generate 3 columns.
Can reformat the date with =A3&-A2&-A1 (YYYY-MM-DD)
If you have a csv file, you can easily import the csv and create a table in mysql using Sequel Pro.
As usual, choose File > Import
Choose a csv file
And click on the “New” button to create a new table based on the file structure.
Mostly for MySQL
To duplicate a table:
CREATE TABLE new_table LIKE old_table;
To replace some character in a field value:
update TABLENAME set FIELDNAME = replace (FIELDNAME, searchstr, replacestr)
Set the DB to InnoDB instead of MyISAM
MYISAM:
MYISAM supports Table-level Locking
MyISAM designed for need of speed
MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS
MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI)
MYISAM not supports transaction. You cannot commit and rollback with MYISAM. Once you issue a command it’s done.
MYISAM supports fulltext search
You can use MyISAM, if the table is more static with lots of select and less update and delete.
INNODB:
InnoDB supports Row-level Locking
InnoDB designed for maximum performance when processing high volume of data
InnoDB support foreign keys hence we call MySQL with InnoDB is RDBMS
InnoDB stores its tables and indexes in a tablespace
InnoDB supports transaction. You can commit and rollback with InnoDB
PHP class to detect mobile
http://mobiledetect.net
detecting browser type using javascript:
http://www.quirksmode.org/js/detect.html
1 2 3 4 5 6 7 | 1. <input type="text" placeholder="Your name here" /> (auto-focus, with place holder and required field) 2. Number: <input max="5" min="0" type="number" /> 3. Email: <input required="" type="email" /> - validation on email upon form submission 4. Range: <input max="10" min="0" step="1" type="range" value="5" /> 5. Date: <input type="date" /> (also available type datetime, time, week, month) 6. URL: <input type="url" /> (on phone - no space bar on keypad) 7. Color: <input type="color" /> |
Output
Validation only works on submission (click on submit button)
Use modernizr to detect and automatically correct non-supported browsers
1 2 3 | foreach((array)$items as $item) { print $item; } |
Information Technology is popular as a service industry. The support is the most important activity.
Some of important practice on email support.
Usually I used to use Google Calendar to set an event and reminder to the event. But there are features that are unnecessary that make things a bit complicated.
I found a simpler reminder application that is much easier to set up and just serve the purpose (to send an email reminder for an event)
Check it out –> remindr.me
In an organization, there are information that are important enough to be documented. As a reference for all the members in the future.
I’ve tried several wiki applications and most of them are not friendly enough. So I decided to move to wordpress as a wiki alternative. To sort content by “category”, to have “page” as static information and “post” for other findings and on-going updates.
With the search function, it is very helpful to find any information within the ‘wiki’.
Template
Plugins used
Settings