& its another 43 dreams

• StarPuppy

  27 Apr 06, 10:10

  Originally posted by candyger:

  /yawns..
  
  morning everyone!

  morning candyger
  
  
  
  wat can i get you?
  
  a cup of hot milo, a cup of cofeee..anything?
• candyger

  27 Apr 06, 10:12

  water pls. sorethroat..
• StarPuppy

  27 Apr 06, 10:14

  Originally posted by candyger:

  water pls. sorethroat..

  /pours a cup of lukewarm water
  
  nah...
  
  hows ur day?
  
  
• candyger

  27 Apr 06, 10:14

  my day? dunno yet. just woke up.
• StarPuppy

  27 Apr 06, 10:15

  Originally posted by candyger:

  my day? dunno yet. just woke up.

  any plans today?
  
  
• ndmmxiaomayi

  27 Apr 06, 10:18

  Go off to do work.
• candyger

  27 Apr 06, 10:22

  Originally posted by StarPuppy:

  any plans today?
  
  

  study lor. hehe.
• candyger

  27 Apr 06, 10:23

  Originally posted by ndmmxiaomayi:

  Go off to do work.

  bye ant!
• StarPuppy

  27 Apr 06, 10:24

  Originally posted by ndmmxiaomayi:

  Go off to do work.

  mayi..dun overstress ur self by skipping lunch ok?
  
  byebye...
• sammiegal

  27 Apr 06, 10:32

  hello.
  on a side note, im positive im going to fail my physics test.
• StarPuppy

  27 Apr 06, 10:35

  Originally posted by candyger:

  study lor. hehe.

  where u studying now?
  
  
• StarPuppy

  27 Apr 06, 10:35

  Originally posted by sammiegal:

  hello.
  on a side note, im positive im going to fail my physics test.

  aww *pats*
  
  nevermind..try and try again..its not like its the final right?
  
  
• sammiegal

  27 Apr 06, 10:37

  Originally posted by StarPuppy:

  aww *pats*
  
  nevermind..try and try again..its not like its the final right?
  
  

  but still..
  ah well. must cheer up.
  better things in life then physics
  
  and tht boy apologised today!!
  
• StarPuppy

  27 Apr 06, 10:40

  Originally posted by sammiegal:

  but still..
  ah well. must cheer up.
  better things in life then physics
  
  and tht boy apologised today!!
  

  finally...
  
  so hows the little guy?
  
  
• ndmmxiaomayi

  27 Apr 06, 10:51

  
  
  mySQL failed to work.
  
  Any experts here?
• rainee

  27 Apr 06, 10:53

  Originally posted by ndmmxiaomayi:

  
  
  mySQL failed to work.
  
  Any experts here?

  wich part of it are u doing now?
• ndmmxiaomayi

  27 Apr 06, 10:54

  Originally posted by rainee:

  wich part of it are u doing now?

  This is what I wrote:
  
  

  code:

  CREATE TABLE SHOP_NAME
  (
  SHOP_ID       VARCHAR(3) NOT NULL,
  SHOP_LOCATION VARCHAR(30),
  SHOP_ADDRESS  VARCHAR(90),
  PRIMARY KEY(SHOP_ID)
  );
  
  SELECT * FROM shop_name s;
  
  DESC SHOP_NAME;
  
  INSERT INTO SHOP_NAME ( SHOP_ID, SHOP_LOCATION, SHOP_ADDRESS ) VALUES ("001", "WOODLANDS REGIONAL CENTRE", "NO 1 WOODLANDS AVE 9");
  
  SELECT * FROM SHOP_NAME;
  
  INSERT INTO SHOP_NAME ( SHOP_ID, SHOP_LOCATION, SHOP_ADDRESS ) VALUES ("002", "CHINATOWN POINT", "CHINATOWN #01-02");
  
  SELECT * FROM shop_name s;

• rainee

  27 Apr 06, 10:56

  wat are you trying to do? Like just inserting the shopnames into a database or?
• ndmmxiaomayi

  27 Apr 06, 10:58

  Originally posted by rainee:

  wat are you trying to do? Like just inserting the shopnames into a database or?

  Yeah...
  
  Today is my first lesson on it. They taught us how to create simple tables and a few rows. But the second row onwards failed to appeared.
• rainee

  27 Apr 06, 11:01

  Originally posted by ndmmxiaomayi:

  Yeah...
  
  Today is my first lesson on it. They taught us how to create simple tables and a few rows. But the second row onwards failed to appeared.

  hmm okie...i show u some of my files for my project...
  
  create table Course(
  Number int Primary Key,
  Name varchar(45),
  Professor varchar(15),
  Department varchar(20),
  ClassNum int);
  
  this is used to build the table course...
  
  then actually to insert data, you can just put all the names into a notepad file, and then do
  
  Load Data local infile '/path/course.txt' into table course;
  
  course.txt is the notepad file where you put in all the info, must be in order of cos according to what you have put in for the table...
  
  not sure if you can use this method or they want you to do it line by line...if yes, I will teach u dat...but need to go look up the syntax cos i m more familiar with uploading them from the notepad file..
  
• rainee

  27 Apr 06, 11:06

  You can also refer here
  
  How To Create Table in MySQL
  
  How to Insert Information into the Table
  
  Can look up the whole tutorial here
  
  Hope that helps...I always use that tutorial last time when I first started out in MySQL de...can say it is quite helpful
• ndmmxiaomayi

  27 Apr 06, 11:10

  Table is up, I saw the first row of data that we are supposed to enter.
  
  Then tried it for second row, nothing leh....
• rainee

  27 Apr 06, 11:13

  Originally posted by ndmmxiaomayi:

  Table is up, I saw the first row of data that we are supposed to enter.
  
  Then tried it for second row, nothing leh....

  can let me see your entire code? post up the file if possible...
  
  cos right now i cant see the entire line, it got chopped up in the middle...
  
  i see if i can try it using mysql in my PC
• ndmmxiaomayi

  27 Apr 06, 11:20

  Originally posted by rainee:

  can let me see your entire code? post up the file if possible...
  
  cos right now i cant see the entire line, it got chopped up in the middle...
  
  i see if i can try it using mysql in my PC

  http://www.sendspace.com/file/ry23x2
  
  My whole worksheet. That's how they taught us, and how I wrote.
  
  And failed horribly. Apparently, the code is correct, but the it doesn't work.
• Simple_Bear

  27 Apr 06, 11:22

  Good Morning everyone...