Laravel 5 [PDOException] SQLSTATE[42000]: Syntax error or access violation:

Question

** [PDOException] SQLSTATE[42000]: Syntax error or access violation: 1166 Incorrect column na me 'INTERESTED IN INTERNSHIP JOB '**

**in this column INTERESTED IN INTERNSHIP JOB is radio button **

**in this column SEX , INTERESTED IN INTERNSHIP JOB , AND ABOVE 18 ARE RADIO BUTTON **

public function up()
{
        Schema::create('students',function(Blueprint $table)
  {
    $table-> increments('id');
    $table-> char('FIRST NAME',50 );
    $table-> char('LAST NAME',50 );
    $table-> string('EMAIL',50 );
    $table-> string('SEX',50);
    $table-> string('INTERESTED IN INTERNSHIP JOB ',50);
    $table-> text('SKILLS');
    $table-> string('above18',50);
    }); 

}

Please help me resolve the aforementioned error, as I am stuck.

pinkal vansia · Accepted Answer · 2015-07-03 06:39:19Z

2

One advice though never use uppercase for column names otherwise there can cross platform issues between windows(case-insensitive) and Linux(Case-sensitive)

http://justinsomnia.org/2003/04/essential-database-naming-conventions-and-style/

UPDATE

change 'INTERESTED IN INTERNSHIP JOB ' to 'INTERESTED IN INTERNSHIP JOB'

There is an additional space at the end of column name and '

edited Jul 3, 2015 at 6:39

answered Jul 3, 2015 at 6:32

pinkal vansia

10.4k7 gold badges52 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel 5 [PDOException] SQLSTATE[42000]: Syntax error or access violation:

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related