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

faintingheart

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?

gespenstern

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.

faintingheart

I install mysql but SID application doesn't have any database in it. What am I doing wrong?

faintingheart

gespenstern I got mysql to work. Now do i use the scratch database?

faintingheart

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.

gespenstern

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.

faintingheart

I got it working. I use DESCRIBE and it worked. Thanks man for suggesting using mysql.

gespenstern

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.

faintingheart

Okay I got it. Thank you sir.

unfbilly11

Did you ever find out why SQL Fiddle didn't work? I know my code is correct and I keep getting the same messages.

faintingheart

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.