    ALTER TABLE `tablename`
    DROP `column1`,
    DROP `column2`,
    DROP `column3`;

To drop multiple columns actual syntax is

    alter table tablename drop column col1, drop column col2 , drop column col3 ....

So for every column you need to specify &quot;drop column&quot; in Mysql 5.0.45. This is same as that of above answer. Just adding one point here. Alter table wont free up the actual space on the disk. So run optimize table on after running optimize table.

A common senario: A model with a collection of item models.  
E.g a House with a collection of People.

**How to structure this correctly for MVVM - particulary with regard to updating the Model and ViewModel collections with additions and deletes?**

Model `House` contains a collection of model `People` (normally a `List&lt;People&gt;`).  
View model `HouseVM` contains the House object that it wraps and an ObservableCollection of view model `PeopleVM` (`ObservableCollection&lt;PeopleVM&gt;`).  Note that we end up here with the HouseVM holding two collections (that require syncing):  
1. `HouseVM.House.List&lt;People&gt;`  
2. `HouseVM.ObservableCollection&lt;PeopleVM&gt;`

When the House is updated with new People (add) or People leave (remove) that event must now be handled in both collections the Model House People collection **AND** the the VM HouseVM PeopleVM ObservableCollection.

**Is this structure correct MVVM?  
Is there anyway to avoid having to do the double update for Adds and Removes?**

MVVM and collections of VMs

In Laravel 4, when working with many-to-many relationships as described in [the 4.2 docs](https://laravel.com/docs/4.2/eloquent#many-to-many), how can I actually get Laravel to create the pivot table for me? 

Do I need to add something in my migrations for the two models that are involved? Do I need to manually create a migration for the pivot table? Or how does Laravel know to create the pivot table?

All I&#39;ve done so far is add the `belongsToMany` information to the two respective models, i.e.

    class User extends Eloquent 
    {
        public function roles()
        {
             return $this-&gt;belongsToMany(&#39;Role&#39;);
         }
     }

However, that does not trigger creation of the pivot table. What step am I missing?

How is a pivot table created by Laravel?

I&#39;m trying to drop multiple columns, but having some trouble. The syntax below works when I do `ALTER TABLE` and `ADD` with multiple values in the brackets `()` but it doesn&#39;t work with `DROP COLUMN`. Am I using the wrong syntax?


		$table3 = &quot;
			ALTER TABLE $table3_name
			DROP COLUMN (
				user_firstname,
				user_lastname,
				user_address,
				user_address2,
				user_city,
				user_state,
				user_zip,
				user_phone
			);
		&quot;;

MySQL Drop Multiple Columns

I'm trying to drop multiple columns, but having some trouble. The syntax below works when I do <code>ALTER TABLE</code> and <code>ADD</code> with multiple values in the brackets <code>()</code> but it doesn't work with <code>DROP COLUMN</code>. Am I using the wrong syntax?
<pre><code class="hljs language-ini">	$table3 = "
		ALTER TABLE $table3_name
		DROP COLUMN (
			user_firstname,
			user_lastname,
			user_address,
			user_address2,
			user_city,
			user_state,
			user_zip,
			user_phone
		);
	";
</code></pre>

I saw in some frameworks this line of code:

    return new static($view, $data);


how do you understand the `new static`?



what means new static?

I have following three strings (current time, sunset and sunrise), how can I find if the current time is between the sunrise and sunset?


    $current_time = &quot;10:59 pm&quot;;
    $sunrise = &quot;5:42 am&quot;;
    $sunset = &quot;6:26 pm&quot;;

How to check if time is between two times in PHP

I receive a datetime from a plugin. I put it into a variable:

    $datetime = &quot;20130409163705&quot;; 

That actually translates to *`yyyymmddHHmmss`*.

I would need to display this to the user as a transaction time but it doesn&#39;t look proper.

I would like to arrange it to be like *`09/04/2013 16:37:05`* **or** *`09-apr-2013 16:37:05`*.

How do I go about and change the orders of the string?

As for now I could think is to use **substr** to separate the date and time. I&#39;m still not sure on how to add the additional characters and rearrange the date.


how to re-format datetime string in php?

I want to be able to create a table using

    Schema::create(&#39;mytable&#39;,function($table)
    {
        $table-&gt;increments(&#39;id&#39;);
        $table-&gt;string(&#39;title&#39;);
    });

But before that I would like to check if the table already exists, perhaps something like

    Schema::exists(&#39;mytable&#39;);

However, the above function does not exist.  What else can I use?

Is there any way to detect if a database table exists with Laravel

I&#39;d like to know if I can install or use the [Laravel][1] PHP framework on any web server without using [Composer][2] (PHP package/dependency manager) every time?

I would like to be able to drop my app on to any web server (like a shared server without access to the command line).

If I run `composer install` the first time (locally), then all the dependencies should be present, correct?

Then, I should be able to drop it onto any server with all of the files (including the vendor directory)?

  [1]: https://github.com/laravel/laravel/tree/develop
  [2]: http://getcomposer.org/

Can I Install Laravel without using Composer?

I have a server with Rackspace. I want to access the database from my local machine command line.

I tried like:

    mysql -u username -h my.application.com -ppassword

But it gives an error:
    
&gt; ERROR 2003 (HY000):
&gt;
&gt; Can&#39;t connect to MySQL server on &#39;my.application.com&#39; (10061)

What causes this error and how can I connect to the remote database?

Access mysql remote database from command line

I have a backup script for my MySQL database, using `mysqldump` with the `--tab` option so it produces a `.sql` file for the structure and a `.txt` file (pipe-separated) for the content.

Some tables have foreign keys, so when I import it I&#39;m getting the error:

&gt; ERROR 1217 (23000) at line 8: Cannot delete or update a parent row: a foreign key constraint fails

I know about using `SET FOREIGN_KEY_CHECKS=0` (and `SET FOREIGN_KEY_CHECKS=1` afterward). If I add those to each `.sql` file then the import works. But then obviously on the next `mysqldump` those get overwritten.

I also tried running it as a separate command, like below but the error comes back:

    echo &quot;SET FOREIGN_KEY_CHECKS=0&quot; | mysql [user/pass/database] 
    [all the imports]
    echo &quot;SET FOREIGN_KEY_CHECKS=1&quot; | mysql [user/pass/database] 

Is there some other way to disable FK checks on the command line?

Disabling foreign key checks on the command line

I am not sure what is this error!

    #1292 - Truncated incorrect DOUBLE value: 
I don&#39;t have double value field or data!


I have wasted a whole hour trying to figure this out!

here is my query

    INSERT INTO call_managment_system.contact_numbers 
        (account_id, contact_number, contact_extension, main_number, created_by)
    SELECT
        ac.account_id,
        REPLACE(REPLACE(REPLACE(REPLACE(ta.phone_number, &#39;-&#39;, &#39;&#39;), &#39; &#39;, &#39;&#39;), &#39;)&#39;, &#39;&#39;),&#39;(&#39;,&#39;&#39;) AS Phone,
        IFNULL(ta.ext, &#39;&#39;) AS extention,
        &#39;1&#39; AS MainNumber,
        &#39;2&#39; AS created_by
    FROM 
        cvsnumbers AS ta
        INNER JOIN accounts AS ac ON ac.company_code = ta.company_code
    WHERE 
        LENGTH(REPLACE(REPLACE(REPLACE(REPLACE(ta.phone_number, &#39;-&#39;, &#39;&#39;), &#39; &#39;, &#39;&#39;), &#39;)&#39;, &#39;&#39;),&#39;(&#39;,&#39;&#39;) ) = 10




here is my show create table for the table which the results are going into

    CREATE TABLE `contact_numbers` ( &#160;
        `number_id` int(10) unsigned NOT NULL AUTO_INCREMENT, &#160;
        `account_id` int(10) unsigned NOT NULL DEFAULT &#39;0&#39;, &#160;
        `person_id` int(11) NOT NULL DEFAULT &#39;0&#39;, &#160;
        `contact_number` char(15) NOT NULL, &#160;
        `contact_extension` char(10) NOT NULL DEFAULT &#39;&#39;, &#160;
        `contact_type` enum(&#39;Primary&#39;,&#39;Direct&#39;,&#39;Cell&#39;,&#39;Fax&#39;,&#39;Home&#39;,&#39;Reception&#39;,&#39;Office&#39;,&#39;TollFree&#39;) NOT NULL DEFAULT &#39;Primary&#39;, &#160;
        `contact_link` enum(&#39;Account&#39;,&#39;PDM&#39;,&#39;Other&#39;) NOT NULL DEFAULT &#39;Account&#39;, &#160;
        `status` tinyint(1) NOT NULL DEFAULT &#39;1&#39; COMMENT &#39;0 = inactive, 1=active&#39;, 
       &#160;`main_number` tinyint(1) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;1 = main phone number&#39;, &#160;
        `created_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, &#160;
        `created_by` int(11) NOT NULL, &#160;
        `modified_on` datetime DEFAULT NULL, &#160;
        `modified_by` int(11) NOT NULL DEFAULT &#39;0&#39;, &#160;
        PRIMARY KEY (`number_id`), &#160;
        KEY `account_id` (`account_id`), &#160;
        KEY `person_id` (`person_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=534 DEFAULT CHARSET=utf8

Error Code 1292 - Truncated incorrect DOUBLE value - Mysql

I&#39;m executing some SQL statements in batch (using the `mysql` command-line binary). I want one of my several SELECT statements to not print the column headers, just the selected records. Is this possible?

How can I suppress column header output for a single SQL statement?

I am trying to add a new column to my MYSQL table using PHP. I am unsure how to alter my table so that the new column is created. In my assessment table I have:

    assessmentid | q1 | q2 | q3 | q4 | q5 

Say I have a page with a textbox and I type `q6` in to the textbox and press a button then the table is updated to:

    assessmentid | q1 | q2 | q3 | q4 | q5 | q6

My code:

    &lt;?php 
      mysql_query(&quot;ALTER TABLE `assessment` ADD newq INT(1) NOT NULL AFTER `q10`&quot;);
    ?&gt;
      &lt;form method=&quot;post&quot; action=&quot;&quot;&gt;
        &lt;input type=&quot;text&quot; name=&quot;newq&quot; size=&quot;20&quot;&gt;
        &lt;input type=&quot;submit&quot; name=&quot;submit&quot; value=&quot;Submit&quot;&gt;
   


Content Type	Original Author	Original Content on Stackoverflow
Question	Cory Nickerson	View Question on Stackoverflow
Solution 1 - Php	void	View Answer on Stackoverflow
Solution 2 - Php	MANISH ZOPE	View Answer on Stackoverflow

MySQL Drop Multiple Columns

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

How is a pivot table created by Laravel?

MVVM and collections of VMs

Attributions