    $query = &quot;ALTER TABLE `&quot; . $table_prefix . &quot;posts_to_bookmark` 
              ADD COLUMN `ping_status` INT(1) NOT NULL 
              AFTER `&lt;TABLE COLUMN BEFORE THIS COLUMN&gt;`&quot;;


I believe you need to have `ADD COLUMN` and use `AFTER`, not `BEFORE`.

In case you want to place column at the beginning of a table, use the `FIRST` statement:

    $query = &quot;ALTER TABLE `&quot; . $table_prefix . &quot;posts_to_bookmark`
              ADD COLUMN `ping_status` INT(1) NOT NULL 
              FIRST&quot;;

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

Is it possible to specify extra header files to include from the command line (using GCC 4 / C++)?

Or is there any other way files can be included except with #include?

Background: I&#39;m trying to compile a large code base on my own PC. The code is usually compiled in a cluster, with a complicated build system (SoftRelTools anybody?), which is intertwined with the operating system, such that it is virtually impossible to install it somewhere else (literally hundreds of makefiles and shell scripts, and hard coded paths to network drives). However, the actual code is fairly straightforward, and compiles fine, BUT it is missing a lot of includes (mostly a la &quot;`include &lt;vector&gt;`&quot; and &quot;`include &lt;math.h&gt;`&quot;). I&#39;m guessing the build system takes care of this usually, but I have to go through the code and add the includes manually, which I&#39;d rather avoid.

Include header files using command line option?

Is it possible to use `nth-child` selectors to wrap 3 divs using `.wrapAll`? I can&#39;t seem to work out the correct equation.

so...


    &lt;div&gt;
            &lt;div&gt;&lt;/div&gt;
            &lt;div&gt;&lt;/div&gt;
            &lt;div&gt;&lt;/div&gt;
            &lt;div&gt;&lt;/div&gt;
            &lt;div&gt;&lt;/div&gt;
            &lt;div&gt;&lt;/div&gt;
    &lt;/div&gt;

becomes...


    &lt;div&gt;
       &lt;div class=&quot;new&quot;&gt;
            &lt;div&gt;&lt;/div&gt;
            &lt;div&gt;&lt;/div&gt;
            &lt;div&gt;&lt;/div&gt;
       &lt;/div&gt;
       &lt;div class=&quot;new&quot;&gt;
            &lt;div&gt;&lt;/div&gt;
            &lt;div&gt;&lt;/div&gt;
            &lt;div&gt;&lt;/div&gt;
       &lt;/div&gt;
    &lt;/div&gt;



Wrap every 3 divs in a div

I have this, but it doesn&#39;t work:

    $query = &quot;ALTER TABLE `&quot;.$table_prefix.&quot;posts_to_bookmark` 
                ADD `ping_status` INT( 1 ) NOT NULL BEFORE `onlywire_status`&quot;;

I appreciate it!


MySQL Alter Table Add Field Before or After a field already present

I have this, but it doesn't work:
<pre><code class="hljs language-ini">$query = "ALTER TABLE `".$table_prefix."posts_to_bookmark` 
 ADD `ping_status` INT( 1 ) NOT NULL BEFORE `onlywire_status`";
</code></pre>
I appreciate it!

What are PHP Namespaces? 

What are Namespaces in general? 

A Layman answer with an example would be great. 



What are namespaces?

I can check all available methods for an object like so:

    $methods = get_class_methods($object);

But how can I see which arguments have to be sent to these methods?

Is there a function for this?

Get method&#39;s arguments?

I expected the following to work but it doesn&#39;t seem to.

    &lt;?php
    
    class Patterns
    {
    	public static const EMAIL = &quot;/^([a-z0-9\+_\-]+)(\.[a-z0-9\+_\-]+)*@([a-z0-9\-]+\.)+[a-z]{2,6}$/ix&quot;;
    	public static const INT = &quot;/^\d+$/&quot;;
    	public static const USERNAME = &quot;/^\w+$/&quot;;
    }

Because it throws this error:

    syntax error, unexpected T_CONST, expecting T_VARIABLE

Can you use static constants inside classes in PHP?

Can someone show me how to get the youtube id out of a url regardless of what other GET variables are in the URL.

Use this video for example: `http://www.youtube.com/watch?v=C4kxS1ksqtw&amp;feature=related`
&lt;br&gt;So between `v=` and before the next `&amp;`



PHP Regex to get youtube video ID?

How do I install the bcmath module on a server? I tried

    yum update php-bcmath

but it said it found nothing.

How to install bcmath module?

Here is my JPA2 / Hibernate definition:

    Code:
    @Column(nullable = false)
    private boolean enabled;


In MySql this column is resolved to a bit(1) datatype - which does not work for me. For legacy issues I need to map the boolean to a tinyint not to a bit. But I do not see a possibility to change the default datatype. Is there any?

Hibernate JPA, MySQL and TinyInt(1) for Boolean instead of bit or char

I&#39;m trying to delete orphan entries in a mysql table.

I have 2 tables like this:

Table `files`:

    | id | ....
    ------------
    | 1  | ....
    | 2  | ....
    | 7  | ....
    | 9  | ....

table `blob`:

    | fileid | ....
    ------------
    | 1  | ....
    | 2  | ....
    | 3  | ....
    | 4  | ....
    | 4  | ....
    | 4  | ....
    | 9  | ....

The `fileid` and `id` columns can be used to join the tables together.

I want to delete all rows in table `blob` where `fileid` cannot be found in the table `files.id`.

So using the example above that would delete rows: 3 &amp; 4(s) in the `blob` table.

Delete sql rows where IDs do not have a match from another table

I have a table in MySQL that have a few columns that have default values specified, but when I try to insert a row, (not specifying values for those default columns), it throws an error saying I cannot insert NULL values.

Here is the table example;

    CREATE TABLE `users` (
      `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `UniqueName` varchar(120) NOT NULL,
      `Password` varchar(1000) NOT NULL,
      `PublicFlag` tinyint(1) NOT NULL,
      `NoTimesLoggedIn` int(10) unsigned NOT NULL DEFAULT &#39;0&#39;,
      `DateTimeLastLogin` timestamp NOT NULL DEFAULT &#39;1971-01-01 00:00:00&#39;,
      `UserStatusTypeId` int(10) unsigned NOT NULL,
      `Private` tinyint(1) NOT NULL DEFAULT &#39;0&#39;,
      `SiteName` varchar(255) NOT NULL,
      `CountryId` int(10) NOT NULL DEFAULT &#39;0&#39;,
      `TimeZoneId` varchar(255) NOT NULL DEFAULT &#39;UTC&#39;,
      `CultureInfoId` int(10) unsigned NOT NULL DEFAULT &#39;0&#39;,
      `DateCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `UserCreated` int(10) unsigned NOT NULL,
      `LastUpdatedBy` int(10) unsigned NOT NULL,
      `DateLastUpdated` datetime DEFAULT NULL,
      PRIMARY KEY (`Id`),
      UNIQUE KEY `UniqueName_UNIQUE` (`UniqueName`),
      KEY `Index 3` (`SiteName`)
    )

It complains about TimeZoneId, and when I populate TimeZoneId, it complains about CultureInforId.

I am using MySQL Version: 5.1.43-community

Here is the insert query I am trying to insert, grabbed from NHibernate Profiler:

    INSERT INTO Users
               (UniqueName,
                Password,
                PublicFlag,
                NoTimesLoggedIn,
                DateTimeLastLogin,
                SiteName,
                TimeZoneId,
                DateCreated,
                DateLastUpdated,
                Private,
                CountryId,
                CultureInfoId,
                UserCreated,
                LastUpdatedBy,
                UserStatusTypeId)
    VALUES     (&#39;zma@zm.com&#39;,&#39;u1uhbQviLp89P9b3EnuN/Prvo3A4KVSiUa0=&#39;,1,
    0,&#39;1/01/1971 12:00:00 AM&#39;,&#39;V9O1T80Q6D&#39;,NULL,&#39;2/08/2010 2:13:44 AM&#39;,
    &#39;2/08/2010 2:13:44 AM&#39;,0, NULL, NULL, 4, 4,31)


MySQL - Cannot insert NULL value in column, but I have a default value specified?

I know that SQL&#39;s `CASE` syntax is as follows:

    CASE
        WHEN search_condition THEN statement_list
        [WHEN search_condition THEN statement_list] ...
        [ELSE statement_list]
    END CASE

However, I don&#39;t understand how this works, possibly because I&#39;m thinking about it as about an `if` statement.

If I have a field in table `user_role`, for example, which contains names like &quot;Manager&quot;, &quot;Part Time&quot; etc., how do I generate a field `role_order` with a different number depending on the role. In the case of this example, &quot;if user_role = &#39;Manager&#39; then role_order = 5&quot;.

Please note I am looking for a *teach a man how to fish* answer rather than *give a man a fish* answer.

How does MySQL CASE work?

I am trying to write a query that will check if a specific table in MySQL has a specific column, and if not —&#160;create it. Otherwise do nothing. This is really an easy procedure in any enterprise-class database, yet MySQL seems to be an exception.

I thought something like

    IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
               WHERE TABLE_NAME=&#39;prefix_topic&#39; AND column_name=&#39;topic_last_update&#39;) 
    BEGIN 
    ALTER TABLE `prefix_topic` ADD `topic_last_update` DATETIME NOT NULL;
    UPDATE `prefix_topic` SET `topic_last_update` = `topic_date_add`;
    END;

would work, but it fails badly. Is there a way?


Content Type	Original Author	Original Content on Stackoverflow
Question	atwellpub	View Question on Stackoverflow
Solution 1 - Php	Chris	View Answer on Stackoverflow

MySQL Alter Table Add Field Before or After a field already present

Php Problem Overview

Php Solutions

Solution 1 - Php

Wrap every 3 divs in a div

Include header files using command line option?

Attributions