Linux Won't install from LIveUsb

Question

I'm new to MySQL and trying to perform a full outer join operation on 3 tables:

Student:-

usn(Primary key)

name

plays :-

usn(foreign key)

sport_id(foreign key)

sport :-

sport_id(primary key)

sport_name

I want to get names of Students who play some sports and if they don't play any, i want NULL (thus the full outer join),

I tried executing the query :

select student.name, sport.name 
from student 
full outer join plays on student.usn = plays.usn
full outer join sport on plays.sport_id = sport.sport_id;

But, i am getting an error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near 'outer join plays on student.usn = plays.usn 
LIMIT 0, 25' at line 3

Can you please tell me what is it that i am doing wrong...?

Solution

okay...here is what has happened...

you have created a non-efi capable linux installation medium (your linuxu usb disk) and a windows installation medium so that's why it doesn't work on EFI mode ON

(apparently your linux usb-disk is corrupted, you need to recreate it. please keep reading)

so you have two choices

1. leave EFI mode OFF and install both OSes
2. install both OSes in EFI mode

1. leave EFI mode OFF and install both OSes

since you have a windows installation disk already, you can try this method... install windows, then recreate the live usb using the app rufus

remember to use MBR PARTITION SCHEME FOR BIOS OR UEFI COMPUTERS parameter while creating the usb disk. just select the device and the image file and other settings will automatically generated by the app

now try to install linux...it will work flawlessly

2. install both OSes in EFI mode

this method is bit complicated for a regular user...in EFI mode, Disk scheme get changed to GPT scheme from MBR (dos-type) scheme. so you may need to re-format the whole disk to convert into GPT mode

1. use another PC and recreate the windows installation medium. Remember to use GPT PARTITION SCHEME FOR UEFI COMPUTERS parameter.just select the device and the image file and other settings will automatically generated by the app
2. in the target PC, turn ON EFI mode and turn OFF CSM (compatible mode) or legacy mode.also turn off secureboot function
3. install windows
4. generate a linux installation disk by the same rufus app settings as windows and reboot to install linux (to avoid hibernation,don't shut down from windows, only restart )

(if you need to make sure you are on EFI mode when installing linux...try these links How can I tell if my system was booted as EFI/UEFI or BIOS? , https://unix.stackexchange.com/questions/148356/how-to-know-if-im-booting-using-uefi)

done!

---

when installing on EFI mode, install windows first....because windows creates the EFI partiton automatically so you don't need to create it while installing. and better turn off secure-boot function in efi-firmware prior installing.

Comments

[user300458]

Does your laptop have a DVD drive? It might be easier to perform installations from DVD.

[Prasad RD]

follow this answer askubuntu.com/questions/221835/…

[NathanielJPerkins]

The laptop doesn't have a dvd drive unfortunately. PRasad RD: I've looked at that method and it is impossible to follow. It mentions that UEFI has to be enabled for this method. Enabling UEFI means I can no longer boot into anything, not even if an install of windows is present. This includes any USB install, windows or linux.

[Prasad RD]

@Thallazar you can use vbox instead of a dualboot setup. It's much easier and efficient in every way(only if you have enough memory). I am also using vbox. i.imgur.com/3p3ZG66.jpg << kubuntu 14.10 X64 with 8GB ram, 3.5GB shared with windows guest

[NathanielJPerkins]

I've never had any experience running a virtual box. Is it hard to setup and run? What's the overhead like, do programs run a lot slower?

[Prasad RD]

it's not hard to setup and if you have enough ram and have a good CPU, you can't notice any slowness of a vbox guest OS. sometimes programs run much faster on Vbox

[NathanielJPerkins]

Hmm interesting. Is it possible to setup permanent programs in a virtual box?

[Prasad RD]

of course yes... it's like two systems running simultaneously.

[Gordon Linoff]

The accepted answer on the proposed duplicate is simply wrong -- and I don't care if it has 600+ upvotes. It removes duplicates. I'm not sure if the right thing to do in this situation is to reopen the question or not.

[MadMike]

Just keep in mind that while mono allows you to write c# programs, parts of the .net library isn't available in mono. If your programming course expects you to use them, you are out of luck. mono-project.com/docs/about-mono/compatibility

[NathanielJPerkins]

The assignments have to be submitted as visual studio project folders.

[Andy T]

In which case its not much help then - worth a shot.

[NathanielJPerkins]

The First method worked and I've got grub installed again detecting both windows 8.1 and Linux mint. I'll probably do the second method tonight or tomorrow when I have time. In 2.1, do I again use Rufus to create a windows usb with GPT partition scheme for UEFI computer?

[Prasad RD]

I'm happy it worked :)...yes you need to recreate the live USB even it worked in the Compatible mode (CSM). those two system types has two different ways of booting, so a EFI-capable USB disk won't boot with MBR mode (CSM/compatible mode - ON)

[NathanielJPerkins]

Thanks for all your help. Out of interest, what was the difference such that loading an ISO through unetbootin would not be detected, but the same ISO through rufus would?

[Prasad RD]

I think unetbootin is only for MBR systems. there is no option to switch between those two system types in it (in rufus you can switch the system type as "MBR PARTITION SCHEME FOR..." or "GPT PARTITION SCHEME FOR...") as I said before,the installation medium used for the EFI system and the installation medium used for the BIOS system are completely two different booting approaches to each system. EFI capable disk has additional folders to boot with efi firmware. that is why unetbootin did not work. learn more about UEFI here >> en.wikipedia.org/wiki/Unified_Extensible_Firmware_Interface

[NathanielJPerkins]

Alright. So now I've installed windows using UEFI GPT options, but through my own idiocy, failed to see your part about disabling CSM/Legacy rom. So atm it's UEFI, secure boot disabled, legacy enabled. I was going to just reinstall it with those options changed so it was UEFI, SB and legacy disabled, but it will no longer boot into USB and there are no options to do so. I can probably just load an ISO into legacy mode and use it to format the HDD and then restart but I'd rather know what's going on. Any idea on that?

[Prasad RD]

if the EFI firmware detects no efi capable boot medium it will fallback to compatible mode and try a MBR capable device, that's why I recommended to turn off compatible mode so you will notice that your USB disk is not working with EFI mode. if you turn both of them ON (EFI, Compatible mode) and your bootable USB did not work with EFI mode then the system will try to boot it with the compatible mode instead. if it worked and booted to the installation setup, you can't tell which way it booted up, EFI or Compatible mode. so better turn the other guy before using.

[Prasad RD]

unlikel windows, linux can be converted between EFI mode and MBR mode by just executing some commands while running the OS.so don''t get bothered with the linux installation.just install windows correctly... as I understood, your USB disk is not EFI-capable...please make sure you use "GPT PARTITION SCHEME FOR UEFI COMPUTERS" parameter while creating it.other settings (except device) will be generated automatically.

[Prasad RD]

check your windows system eightforums.com/tutorials/…

[NathanielJPerkins]

BIOS mode is definitely in UEFI for the install. Both of my USB drives for linux and windows are both formatted for GPT partition for UEFI mode. I"m just in the process of putting on a legacy USB install for windows which I'll use to format the HDD and then start again but now with UEFI enabled, secure disabled and legacy disabled.

[Lakshya Sharma]

Thanks, left join did the job for me!