18
มิ.ย.

Materials

•US #6 needles
•Gauge for this project, taken over 1×1 ribbing, at the midpoint of a section where it isn’t particularly stretched out: approximately 6 stitches (3 ribs) per inch
•30 stitches at widest point

•Width of scarf: about 4.25 inches. Length of scarf: about 58 inches.

•Anticipated yarn consumption for this size: About 250 yards of a multicolor worsted weight yarn that normally knits in stockinette at 5 stitches per inch.

As for working method, this scarf is done in a pretty standard Entrelac edge column technique – think Entrelac project reduced to just the right and left most columns, without the basket weave effect sections between.

Row 1: Cast on 1 stitch, knit in the front, then purl in the back of this stitch [2 stitches on needle]
Row 2: Knit in the front, then purl in the back of the first stitch, K1 [3 st on needle]
Row 3: Purl in the front, then knit in the back of the first stitch, P1, K1 [4 stitches on needle]
Row 4: Purl in the front, then knit in the back of the first stitch, P1, K1, P1 [5 stitches on needle]
Row 5: Knit in the front, then purl in the back of the first stitch, finish row in established K1, P1 ribbing [6 st on needle]
Row 6: Knit in the front, then purl in the back of the first stitch, finish row in established K1, P1 ribbing [7 st on needle]
Row 7: Purl in the front, then knit in the back of the first stitch, finish row in established P1, K1 ribbing [8 st on needle]
Row 8: Purl in the front, then knit in the back of the first stitch, finish row in established P1, K1 ribbing [9 st on needle]

Continue rows 5-8, adding one stitch in each row but doing it to maintain the K1, P1 rib pattern. Keep doing this until you have 30 stitches on your needle.

Entrelac body section:

Row 1: Knit in the front, then purl in the back of the first stitch, SSK. Turn work over so the next row heads back in the other direction. Note that this first row is only 3 stitches long.
Row 2 and all subsequent even numbered rows: Work P1, K1 ribbing as established.
Row 3: Purl in the front, then knit in the back of the first stitch, P1, SSK. Note that from now on this row-ending SSK will be composed of one stitch worked on the previous row, plus one stitch from the dormant stitches on the left hand needle. Turn work over so the next row heads back in the other direction. You now have 4 stitches in the row.
Row 5: Knit in the front, then purl in the back of the first stitch, K1, P1, SSK. Turn work. You now have 5 stitches in the row.
Row 7: Purl in the front, then knit in the back of the first stitch, P1, K1, P1, SSK. Turn work. You will now have 6 stitches in the row.

Continue to work in the manner of rows 5-8, adding one stitch at the edge of each right-side row in the established rib pattern until you have incorporated all of the dormant stitches on the left hand needle. You will again have 30 stitches on the needle. At this point your segment is done. To do the next one, flip the work over (the and begin again from Row 1 of the Entrelac section). Continue adding entire trumpet shaped sections until your scarf is of sufficient length. (Mine maxed out at about 58″).

Final section:

Rows 1-25 – work as for a standard Entrelac section. At the completion of Row 25 you should have fifteen active stitches on your right hand needle. The left hand needle should hold the other fifteen stitches. Work Row 26 as usual (marked in blue on accompanying chart).

Row 27 and all subsequent odd numbered rows: SSK, work in established ribbing, ending row with SSK and turn in the same manner as in the Entrelac section.
Rows 28 and all subsequent even numbered rows: Work P1, K1 ribbing as established.

Continue in this manner until you have completed Row 50, and three stitches remain on your needle.
Row 51: Slip, slip, slip, knit all three stitches together through the back of the loop (this is a three-stitch variant of the standard two stitch SSK decrease).

Darn in all ends.

01
ม.ค.

หลายครั้งหลายครากับ CREATE VIEW  พอจะใช้ก็ต้องหาใหม่อยู่เรื่อย (ตามเคยสำหรับคนมีหยักสมองน้อยๆ แต่หน้าตาดี..ฮิฮิ)

CREATE VIEW Syntax


CREATE
    [OR REPLACE]
    [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    [DEFINER = { <em><code>user</code></em> | CURRENT_USER }]
    [SQL SECURITY { DEFINER | INVOKER }]
    VIEW <em><code>view_name</code></em> [(<em><code>column_list</code></em>)]
    AS <em><code>select_statement</code></em>
    [WITH [CASCADED | LOCAL] CHECK OPTION]

ชอบใช้ CREATE OR REPLACE VIEW … AS … มากกว่าเพราะถ้าเคยสร้าง VIEW ไว้แล้วจะไม่ทำให้เกิด Error  

Example :  

CREATE OR REPLACE VIEW view_something AS
SELECT a.field1, a.field2 FROM tblSomthingA a
UNION
SELECT b.field1, b.field2 FROM tblSomthingB b

 

CREATE OR REPLACE VIEW view_something AS
SELECT a.field1, a.field3, count( a.field1 )
FROM tblSomthingA a
LEFT JOIN tblSomthingB b ON ( a.field1 = b.field2 )
GROUP BY a.field1

Comment :

เขาบอกมาว่า VIEW จะ refresh ทุกครั้งที่มีการ INSERT หรือ UPDATE ซึ่งมีอัตราส่วน 20:1 (20 SELECT ต่อ 1 INSERT or UPDATE) ตามนั้น

The view “refresh” will occur every time someone runs an INSERT or UPDATE, which will be on a 20 to 1 ratio. (20 Selects for every Update or Insert)

Refer :

http://dev.mysql.com/doc/refman/5.0/en/create-view.html

Category: MYSQL  Leave a Comment