C170 Performance Assessment I'm stuck sql fiddle won't work.

faintingheartfaintingheart Member Posts: 256
in IT Jobs / Degrees
I'm stuck on exercise 3 on the performance assessment. I build code to create 4 tables. I enter it in SQLfiddle and it keep saying either Gateway time out or "Can't create database 'db_9_d073b'; database exists". What does that mean ya'll? I'm stuck at this part and so frustrated. In the video the coarse mentor did it so easily in SQLfiddle without any problems. When I do it it keep getting that error. Can any body help me?
· Share on FacebookShare on Twitter

Comments

  • gespensterngespenstern Member Posts: 1,243 ■■■■■■■■□□
    Try to create and use your own database with your own name, not sure if fiddle allows that.

    I did everything with a local mysql installation in order not to depend on such crap.
    · Share on FacebookShare on Twitter
  • faintingheartfaintingheart Member Posts: 256
    I install mysql but SID application doesn't have any database in it. What am I doing wrong?
    · Share on FacebookShare on Twitter
  • faintingheartfaintingheart Member Posts: 256
    gespenstern I got mysql to work. Now do i use the scratch database?
    · Share on FacebookShare on Twitter
  • faintingheartfaintingheart Member Posts: 256
    So I created a DATABASE and put 5 tables in there. But when I use "Select * from customers" to view a table. Nothing comes up.
    · Share on FacebookShare on Twitter
  • gespensterngespenstern Member Posts: 1,243 ■■■■■■■■□□
    Hard to tell. I'm assuming you are on Windows. In this case you can launch cmd.exe, go to the directory where mysql executable files are, launch mysql with the user/pass you supplied during installation.

    Then you create database (look up this command's precise syntax in the course).

    Then do 'use database yourdatabasename'.

    Then proceed as usual, creating/manipulating/accessing tables and entries.
    · Share on FacebookShare on Twitter
  • faintingheartfaintingheart Member Posts: 256
    I got it working. I use DESCRIBE and it worked. Thanks man for suggesting using mysql.
    · Share on FacebookShare on Twitter
  • gespensterngespenstern Member Posts: 1,243 ■■■■■■■■□□
    faintingheart wrote: »
    So I created a DATABASE and put 5 tables in there. But when I use "Select * from customers" to view a table. Nothing comes up.

    You are probably not in the right DB. Change it using 'use database name' command.
    · Share on FacebookShare on Twitter
  • faintingheartfaintingheart Member Posts: 256
    Okay I got it. Thank you sir.
    · Share on FacebookShare on Twitter
  • unfbilly11unfbilly11 Member Posts: 100 ■■□□□□□□□□
    Did you ever find out why SQL Fiddle didn't work? I know my code is correct and I keep getting the same messages.
    · Share on FacebookShare on Twitter
  • faintingheartfaintingheart Member Posts: 256
    Yeah SQL Fiddle site is always down. I tried to do my home work and I get gateway time out all the time. That sucks.
    · Share on FacebookShare on Twitter
Sign In or Register to comment.