& its another 43 dreams

• rainee

  27 Apr 06, 11:22

  Originally posted by ndmmxiaomayi:

  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.

  ok i go take a look...
  
  i just created a test database in my mysql and insert some pseudo data, and can work...
  
  but let me take a look at the values...maybe sth wrong there..
  
  Quick question: Are you inserting the values they gave you in question #13?
• StarPuppy

  27 Apr 06, 11:22

  /is eating maggi mee for breakfast
  
  
• Simple_Bear

  27 Apr 06, 11:24

  /eating red bean buns for breakfast...
  
  
• ndmmxiaomayi

  27 Apr 06, 11:27

  Originally posted by Simple_Bear:

  Good Morning everyone...
  
  

  Good morning bear.
• ndmmxiaomayi

  27 Apr 06, 11:28

  Originally posted by rainee:

  ok i go take a look...
  
  i just created a test database in my mysql and insert some pseudo data, and can work...
  
  but let me take a look at the values...maybe sth wrong there..
  
  Quick question: Are you inserting the values they gave you in question #13?

  Yup.
  
  Minus the Comics_Masters table.
• Simple_Bear

  27 Apr 06, 11:30

  Originally posted by ndmmxiaomayi:

  Good morning bear.

  Good Morning Mayi...
  
  /prepares honey tea for Mayi...
  
  Dun be too stressed k...
  
  
• rainee

  27 Apr 06, 11:30

  sigh forum very slow for me now
• ndmmxiaomayi

  27 Apr 06, 11:33

  Originally posted by Simple_Bear:

  Good Morning Mayi...
  
  /prepares honey tea for Mayi...
  
  Dun be too stressed k...
  
  

  Thanks bear.
  
  *takes honey tea*
• Simple_Bear

  27 Apr 06, 11:36

  Originally posted by rainee:

  sigh forum very slow for me now

  /prepares ice honey longan for Rainee...
  
  Relax...
  
  
• rainee

  27 Apr 06, 11:36

  Originally posted by ndmmxiaomayi:

  Yup.
  
  Minus the Comics_Masters table.

  okie...
  
  i managed to get it to show up in my table...
  
  like this right?
  
  
• Simple_Bear

  27 Apr 06, 11:37

  Originally posted by ndmmxiaomayi:

  Thanks bear.
  
  *takes honey tea*

  U r welcome, my dear Mayi...
  
  
• ndmmxiaomayi

  27 Apr 06, 11:42

  Originally posted by rainee:

  okie...
  
  i managed to get it to show up in my table...
  
  like this right?
  
  

  
  
  Still nothing
  
  By the way, we are using MySQL Query Browser.
• rainee

  27 Apr 06, 11:45

  Originally posted by ndmmxiaomayi:

  
  
  Still nothing
  
  By the way, we are using MySQL Query Browser.

  hmm...
  
  but shud be the same...
  
  just do the same as inserting into the first row...same syntax and everything, just change the data...
  
  make sure they go one after another...no need to have anything in between them...
  
  
• ndmmxiaomayi

  27 Apr 06, 11:49

  Originally posted by rainee:

  hmm...
  
  but shud be the same...
  
  just do the same as inserting into the first row...same syntax and everything, just change the data...
  
  make sure they go one after another...no need to have anything in between them...
  
  

  I think same...
  
  Browser just let us see better... user-friendly I guess
  
  But the weird thing is, I don't have the second record onwards.
• rainee

  27 Apr 06, 11:53

  Originally posted by ndmmxiaomayi:

  I think same...
  
  Browser just let us see better... user-friendly I guess
  
  But the weird thing is, I don't have the second record onwards.

  yea very weird...
  
  cos i can see my second and third row...
  
  i show u wat i did, tho mine is straight away go into the mysql one..
  
  CREATE TABLE SHOP_NAME
  
  (
  
  SHOP_ID VARCHAR(3) NOT NULL,
  
  SHOP_LOCATION VARCHAR(30),
  
  SHOP_ADDRESS VARCHAR(90),
  
  PRIMARY KEY(SHOP_ID)
  
  );
  
  INSERT INTO shop_name
  -> VALUES ('001','Woodlands Regional Centre','No 1 Woodlands Ave 9');
  INSERT INTO shop_name
  -> VALUES ('002','Chinatown Point','Chinatown #01-02');
  
  SELECT * FROM shop_name;
  
  
• ndmmxiaomayi

  27 Apr 06, 11:57

  Got it, finally
  
  
• rainee

  27 Apr 06, 11:59

  hehe congrats...
  
  wat was the problem just now?
• ndmmxiaomayi

  27 Apr 06, 12:03

  Originally posted by rainee:

  hehe congrats...
  
  wat was the problem just now?

  No idea....
  
  I wrote the same thing as yours. I re-do everything and kiasu a bit, refresh the schemata all the time.
  
  Then it works lor. That worksheet only says refresh one time, I refresh for every statement I wrote.
• StarPuppy

  27 Apr 06, 12:04

  arrgh...can't sleep...my mind too messed up too sleep
  
  i really need to find something to calm my mind down...its been lidat since...2 weeks ago
  
  
• blackchickenahkai

  27 Apr 06, 12:05

  Originally posted by ndmmxiaomayi:

  Got it, finally
  
  

  
• rainee

  27 Apr 06, 12:05

  Originally posted by ndmmxiaomayi:

  No idea....
  
  I wrote the same thing as yours. I re-do everything and kiasu a bit, refresh the schemata all the time.
  
  Then it works lor. That worksheet only says refresh one time, I refresh for every statement I wrote.

  
  
  oh well as long as it works
• rainee

  27 Apr 06, 12:06

  Originally posted by StarPuppy:

  arrgh...can't sleep...my mind too messed up too sleep
  
  i really need to find something to calm my mind down...its been lidat since...2 weeks ago
  
  

  wan to share your thoughts here?
• ndmmxiaomayi

  27 Apr 06, 12:07

  Originally posted by rainee:

  
  
  oh well as long as it works

  Now going on to the Comic_Master table. If it doesn't work again, going to kill myself liao.
• StarPuppy

  27 Apr 06, 12:07

  Originally posted by rainee:

  wan to share your thoughts here?

  no la...myabe alot of things haven do?
  
  i haven cut my hair..
  
  then scared tomorrow late
  
  
• ndmmxiaomayi

  27 Apr 06, 12:08

  Originally posted by StarPuppy:

  arrgh...can't sleep...my mind too messed up too sleep
  
  i really need to find something to calm my mind down...its been lidat since...2 weeks ago
  
  

  2 weeks ago? What happened then?