Photoshop/Web design and SEO
Hi guys,
On 5th of August 2009 Wednesday tech session, we might have EC to brief us about basic Photoshop skills.
OR, we might have relax discussion on web design and SEO.
Thanks.
- Forums:
Hi guys,
On 5th of August 2009 Wednesday tech session, we might have EC to brief us about basic Photoshop skills.
OR, we might have relax discussion on web design and SEO.
Thanks.
Suppose you have a table
Suppose you have a table where each row is associated with a certain group (For example, orders are associated with the customers placing them) where each item WITHIN the group has a distinct number (For example dedicated hosting, each person my have a sequence of competition results - each person, therefore, has a 1st, 2nd, 3rd... competition).
If you would like to renumber items within their group so that each has the same baseline (say 0), here is an example way to proceed domain names:
Create TEMPORARY Table Groups (Id INTEGER AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(31), GroupId VARCHAR(31), ValWithinGroup INTEGER);
INSERT INTO Groups VALUES (null, "Davy", "Boy", 2);
INSERT INTO Groups VALUES (null, "Mary", "Girl", 2);
INSERT INTO Groups VALUES (null, "Bill", "Boy", 5);
INSERT INTO Groups VALUES (null, "Jill", "Girl", -3);
INSERT INTO Groups VALUES (null, "Fred", "Boy", 3);
# Find the lowest value for each group search engine marketing
CREATE TEMPORARY TABLE GroupSum AS SELECT GroupId, MIN(ValWithinGroup)
AS baseVal FROM Groups GROUP BY GroupId;
# create an index so mySQL can efficiently match
ALTER TABLE GroupSum ADD UNIQUE (GroupId);
# finally, make the baseline adjustment
UPDATE Groups LEFT JOIN GroupSum USING (GroupId)
SET ValWithinGroup=ValWithinGroup-baseVal;
SELECT * FROM Groups;
# 1 Davy Boy 0
# 2 Mary Girl 5 credit card processing
# 3 Bill Boy 3
# 4 Jill Girl 0
# 5 Fred Boy 1
#Each group ("Boy", "Girl") now has a (lowest) ValWithinGroup entry of 0.
Thanks EC!
Hi guys,
Yes, we're pleasure to have EC for conducting a tech session regarding basic Photoshop skill sets. Isn't it fun and excited? For me, it's a brand new experience.
Do you all get enough for that? Hope EC will still conducting another tech session regarding Photoshop again in the near future.
Special thanks to EC, cheers!