Alter column length in Schema builder?

database schema builder laravel alter
qwerty picture qwerty · Dec 10, 2012 · Viewed 11.3k times · Source

I have two fields i need to increment the character limit on. I're read through the documentation and to my surprise i found no option for it. Is it possible to do? If not, how should i go about solving this?

I could drop the column and re-create it with the correct properties, but i don't want to loose any data in the database.

Answer

ademers picture ademers · Jul 3, 2013

For Laravel 4

DB::update('ALTER TABLE `my_table` MODIFY `my_column` VARCHAR(<new length>)');

Related questions

How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

Read More
How to create a new schema/new user in Oracle Database 11g?

I have applied for an internship in a company and as a question they have asked me to create a schema for their company with certain requirements and mail them the DDL file. I have installed Oracle database 11g Express …

Read More
What is the difference between a schema and a table and a database?

This is probably a n00blike (or worse) question. But I've always viewed a schema as a table definition in a database. This is wrong or not entirely correct. I don't remember much from my database courses.

Read More