- Joined
- Feb 15, 2008
- Messages
- 213 (0.04/day)
System Name | Shark's Build |
---|---|
Processor | AMD Ryzen 7 5700X 3.4 GHz |
Motherboard | Gigabyte B450 I AORUS PRO |
Cooling | Noctua NH-C14 heatsink core with swapped Phanteks PH-F140HP PWM |
Memory | G.SKILL Aegis (2 * 8GB) DDR4-3000 |
Video Card(s) | GeForce RTX 3060Ti 8GB |
Display(s) | Tri-Monitor setup 1x144hz 2x60hz |
Case | Corsair Obsidian 250D Mini ITX |
Audio Device(s) | On-Board |
Power Supply | EVGA Supernova NEX750B 750W ATX Power Supply 80+ Bronze |
Hey all!
So I'm working on an assignment and I'm getting an error when I try and load my .SQL file.
https://pastebin.com/4GajJ9MT <--- here is my code blocks
I get the error l_id doesn't exist when I have it in the limo table.
I'm a real scrub when it comes to this. Please help me
Edit: Fixed qualify and rental up a little by adding q_ to the foreign keys and r_ to the rental foreign keys. Now I'm getting error "Cannot add foreign key constraint" regarding the rental table create.
So I'm working on an assignment and I'm getting an error when I try and load my .SQL file.
https://pastebin.com/4GajJ9MT <--- here is my code blocks
I get the error l_id doesn't exist when I have it in the limo table.
I'm a real scrub when it comes to this. Please help me
Edit: Fixed qualify and rental up a little by adding q_ to the foreign keys and r_ to the rental foreign keys. Now I'm getting error "Cannot add foreign key constraint" regarding the rental table create.
Last edited: