Use the **[documented](https://docs.github.com/en/github/writing-on-github/autolinked-references-and-urls)** auto-linking format for issues across repositories.

 - **Syntax:** `{owner}/{repository}#{issue_number}`
 - **Example:** `mojombo/jekyll#1`

When such formatted text is present in a commit message, it&#39;s automatically transformed into a clickable link which will redirect one to `https://github.com/{owner}/{repository}/issues/{issue_number}`

Github share PR/Issue number use the same sequence.

So, one #number either one PR or one Issue.

Just use #number is OK.

Use `#1234` in a comment to reference pull request 1234 from the current repo.

For linking to another repository, if you just paste the link to the issue or pull request, say `https://github.com/{owner}/{repository}/issues/{issue_number}`, GitHub will render it as 
     
    [{owner}/{repository}#{issue_number}](https://github.com/{owner}/{repository}/issues/{issue_number})

For example, https://github.com/jlord/sheetsee.js/issues/26 will render as [jlord/sheetsee.js#26](https://github.com/jlord/sheetsee.js/issues/26).

See https://help.github.com/articles/autolinked-references-and-urls/#issues-and-pull-requests

I&#39;m getting this exception:

&gt; The parameterized query &#39;(@Name nvarchar(8),@type nvarchar(8),@units nvarchar(4000),@rang&#39; expects the parameter &#39;@units&#39;, which was not supplied.

My code for inserting is:

    public int insertType(string name, string type, string units = &quot;N\\A&quot;, string range = &quot;N\\A&quot;, string scale = &quot;N\\A&quot;, string description = &quot;N\\A&quot;, Guid guid = new Guid())
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            SqlCommand command = new SqlCommand();
            command.CommandText = &quot;INSERT INTO Type(name, type, units, range, scale, description, guid) OUTPUT INSERTED.ID VALUES (@Name, @type, @units, @range, @scale, @description, @guid) &quot;;
            command.Connection = connection;
            command.Parameters.AddWithValue(&quot;@Name&quot;, name);
            command.Parameters.AddWithValue(&quot;@type&quot;, type);
            command.Parameters.AddWithValue(&quot;@units&quot;, units);
            command.Parameters.AddWithValue(&quot;@range&quot;, range);
            command.Parameters.AddWithValue(&quot;@scale&quot;, scale);
            command.Parameters.AddWithValue(&quot;@description&quot;, description);
            command.Parameters.AddWithValue(&quot;@guid&quot;, guid);
            return (int)command.ExecuteScalar();
        }
    }

The exception was a surprise because I&#39;m using the `AddWithValue` function and making sure I added a default parameters for the function. 


SOLVED:

The problem was that the some parameters where empty Strings (that override the default)

This is the working code: 

    public int insertType(string name, string type, string units = &quot;N\\A&quot;, string range = &quot;N\\A&quot;, string scale = &quot;N\\A&quot;, string description = &quot;N\\A&quot;, Guid guid = new Guid())
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                SqlCommand command = new SqlCommand();
                command.CommandText = &quot;INSERT INTO Type(name, type, units, range, scale, description, guid) OUTPUT INSERTED.ID VALUES (@Name, @type, @units, @range, @scale, @description, @guid) &quot;;
                command.Connection = connection;
                command.Parameters.AddWithValue(&quot;@Name&quot;, name);
                command.Parameters.AddWithValue(&quot;@type&quot;, type);

                if (String.IsNullOrEmpty(units))
                {
                    command.Parameters.AddWithValue(&quot;@units&quot;, DBNull.Value); 
                }
                else
                    command.Parameters.AddWithValue(&quot;@units&quot;, units);
                if (String.IsNullOrEmpty(range))
                {
                    command.Parameters.AddWithValue(&quot;@range&quot;, DBNull.Value);
                }
                else
                    command.Parameters.AddWithValue(&quot;@range&quot;, range);
                if (String.IsNullOrEmpty(scale))
                {
                    command.Parameters.AddWithValue(&quot;@scale&quot;, DBNull.Value);
                }
                else
                    command.Parameters.AddWithValue(&quot;@scale&quot;, scale);
                if (String.IsNullOrEmpty(description))
                {
                    command.Parameters.AddWithValue(&quot;@description&quot;, DBNull.Value);
                }
                else
                    command.Parameters.AddWithValue(&quot;@description&quot;, description);
                
                
                
                
                command.Parameters.AddWithValue(&quot;@guid&quot;, guid);


                return (int)command.ExecuteScalar();
            }
            
            
        }

The parameterized query ..... expects the parameter &#39;@units&#39;, which was not supplied

My existing table:

    +-----------------+---------------+------+-----+---------+-------------------+
    | Field           | Type          | Null | Key | Default | Extra             |
    +-----------------+---------------+------+-----+---------+-------------------+
    | creation_date   | timestamp     | YES  |     | NULL                        |

I wanted to alter table like this:

    ALTER TABLE enterprise MODIFY creation_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

But I got this error:

ERROR 1138 (22004) at line 7: Invalid use of NULL value

The problem looks like from changing the Nullable which was YES to NOT NULL. Do I need to drop the column and add afterwards?

MySQL Alter table causes Error: Invalid use of NULL value

I&#39;ve seen commit messages that refer to a specific issue / pull request.  What is the syntax to include a specific repository&#39;s issue or pull request?

Github Commit Syntax to Link a Pull Request/ Issue

<p>I've seen commit messages that refer to a specific issue / pull request.  What is the syntax to include a specific repository's issue or pull request?</p>


I&#39;ve read the docs on this several times over and I still don&#39;t completely get the differences between these different commands. Maybe it&#39;s just me, but the documentation could be more lucid:

http://git-scm.com/docs/gitignore

https://help.github.com/articles/ignoring-files

Moreover, a lot of the commentary on this subject seems to use the words &quot;indexed&quot;, &quot;committed&quot;, &quot;tracked&quot; somewhat loosely, which makes the differences between these three less clear.

My current (admittedly limited) understanding:

 - Files matched in `.gitignore` will not be tracked in the future.
   (Though they may have been tracked previously.) This means that they
   won&#39;t ever show up in a future `git status` list as changed.
   _However, future changes will still be synced with remote repos_. In other words, the files are still &quot;indexed&quot;, but they are not &quot;tracked&quot;.
   Because a `.gitignore` file is in the project directory, the file
   itself can be versioned.
   
 - Files matched in `.git/info/exclude` will also not be &quot;tracked&quot;. In
   addition, these files will not ever be remotely synced, and thus will
   never be seen in any form by any other users. These files should be files that
   are specific to a single user&#39;s editor or workflow. Because it is in the `.git`
   directory, the `exclude` file can&#39;t itself be versioned.
   
 - Files that have had `assume-unchanged` run on them also don&#39;t show up in `git status` or `git diff`. This seems similar to `exclude`, in that these files are neither &quot;indexed&quot; nor &quot;tracked&quot;. However, the last version of the file to be committed before `assume-unchanged` will remain visible to all users in the repo.

My questions:
================

 1. Is the above interpretation correct? Please correct me.
    
 2. If a file has already been in a commit, what is the functional
    different between matching it in `.exclude` and running
    `assume-unchanged` on it? Why would one prefer one approach to
    another?
    
 3. My basic use case is that I want to avoid sorting through diffs on
    compiled files, but I still want those compiled files synced along
    with the source files. Will a `gitignore`&#39;d file still be pushed? If not, how to manage final deployment of the compiled files?

Thanks in advance for any help.

git ignore vs. exclude vs. assume-unchanged

I tried git bisect a while ago and it helped me well, but apparently I didn&#39;t stop it. When I do git status I still get:

    You are currently bisecting.
    (use &quot;git bisect reset&quot; to get back to the original branch)

I don&#39;t really want to reset to anywhere, I just want to stop bisecting. It&#39;s really just a matter of getting rid of this message.

How do I stop git bisect?

I have this project where the remote repo has the main development branch, and I have a fork containing the experimental branch. I&#39;m required to `rebase` changes from the development branch to my experimental branch before I push to my fork. So it goes like:

    git checkout experimentalbranch
    git fetch remoterepo
    git rebase remoterepo/developmentbranch

By this time, I hit conflicts. However, *I&#39;m not familiar with any of these changes* (I&#39;m rebasing weeks worth of changes, because they didn&#39;t merge my changes immediately). Also, it&#39;s my first time doing `rebase`. I&#39;m more accustomed to `merge`.

In meld, it usually is like `&lt;&lt;LOCAL||REMOTE&gt;&gt;` for `merge`, which sounds very intuitive. But in `rebase`, it&#39;s `&lt;&lt;HEAD||COMMIT MESSAGE&gt;&gt;`. Who is `HEAD`? Is it the `HEAD` of the development branch? Is it the latest code in the development branch or somewhere else?

Git Rebase Conflict: Who is HEAD?

Is there a command like `git push --tag tag_a`? I only found `git push --tags`.

How to only push a specific tag to remote?

I have a git repository which holds a Drupal site.  I spent the last day trying to build a feature using several different modules.  I have given up on my current approach and have decided to try a different combination of modules.  However, my repository has several commits on the master branch that contain this feature development process (I understand that I did not branch in an effective manner.)  I want to get rid of the last three or four commits and set master to that point in my history (I don&#39;t want to merge my current work with anything, I just want it to go away.)  How do I do this?




How do I move master back several commits in git?

I&#39;m trying to install github private repository by npm that includes other private github repositories as dependency.

Have tried a lot of ways and posts but none is working. Here is what i&#39;m doing :

    npm install git+https://github.com/myusername/mygitrepository.git

in package.json  is like : 

    &quot;dependencies&quot;: {
        &quot;repository1name&quot;: &quot;git+https://github.com/myusername/repository1.git&quot;,
        &quot;repository2name&quot;: &quot;git+https://github.com/myusername/repository2.git&quot;
    }

What is the the right way to do it?


npm install private github repositories by dependency in package.json

GitHub-flavored markdown supports [syntax highlighting in codeblocks](https://help.github.com/articles/github-flavored-markdown#syntax-highlighting). This is done by adding the name of the language next to the triple-grave codeblock markers:

    ```ruby
    require &#39;redcarpet&#39;
    markdown = Redcarpet.new(&quot;Hello World!&quot;)
    puts markdown.to_html
    ```

Standard markdown also supports inline codeblocks by wrapping text in `` `single graves` ``. Is there any way to add syntax highlighting to these inline codeblocks?

Inline code syntax highlighting in GitHub markdown?

I have a CMS theme installed on my machine. I&#39;m tracking changes to it via git
and decided to back it up on GitHub so I could share those changes.

The theme as provided is also available on GitHub. On my machine I have added
this as a remote upstream. Now I can easily see the changes between my master
and the remote upstream by using the following command:

    git diff --color master upstream/number

If I could add the remote upstream on GitHub I could easily share these changes.
Is it possible to set this relationship on GitHub?

I have tried the following:

    git push -u origin upstreambranch

which adds an `upstreambranch` to the master on GitHub. However trying to
compare both branches doesn&#39;t work, the result I get on GitHub is that: &quot;There
isn&#39;t anything to compare&quot;

Is there an alternative way to compare these?

There isn&#39;t anything to compare. Nothing to compare, branches are entirely different commit histories

I&#39;m trying to push one of my projects to github, and I keep getting this error:

    peeplesoft@jane3:~/846156 (master) $ git push

    fatal: The current branch master has no upstream branch.
    To push the current branch and set the remote as upstream, use

         git push --set-upstream origin master

So I tried it and got this:

    peeplesoft@jane3:~/846156 (master) $ git push --set-upstream origin master

    fatal: Authentication failed

Another stackoverflow thread suggested I try the following, with disappointing results.

    peeplesoft@jane3:~/846156 (master) $ git push -u origin master

    fatal: Authentication failed

Then I tried this:

    peeplesoft@jane3:~/846156 (master) $ git config remote.origin.push HEAD

    peeplesoft@jane3:~/846156 (master) $ git push

    fatal: Authentication failed

Any hints?



fatal: The current branch master has no upstream branch

Is there a way to know which people have merge privileges on a public GitHub repository. If the owner is a user and not an organization, then  at least I know one maintainer, but it&#39;s possible that there are other users with merge rights. Also, if the owner is an organization it is possible, that not all members of the organization have merge rights. So is there a way to find the exact maintainers?

How to know who is the maintainer of a GitHub repository?

I&#39;m working on a team with a few developers using git on BitBucket. We are all working on a `dev` branch, not pushing to `master` until a release.

One of the developers committed incorrect code that overwrote my own by accident, and now I am trying to push the correct code  back to the repo. I have been reading about this error for a few days now, I can&#39;t push to the repo anymore because I am getting the following error:


     ! [rejected]        master -&gt; dev (fetch first)
    error: failed to push some refs to &#39;https://myusername@bitbucket.org/repo_user/repo_name.git&#39;
    hint: Updates were rejected because the remote contains work that you do
    hint: not have locally. This is usually caused by another repository pushing
    hint: to the same ref. You may want to first integrate the remote changes
    hint: (e.g., &#39;git pull ...&#39;) before pushing again.
    hint: See the &#39;Note about fast-forwards&#39; in &#39;git push --help&#39; for details.

I follow the instructions and `pull`, but then I receive a merge conflict. After entering a message for the merge conflict, my local code is now the incorrect code that the other developer uploaded by accident (as expected from the `pull`). So I replace the incorrect code with the backup I copied before committing, and when I try to push again, I get the same error. 

It is really frustrating, I really want to help out my team and contribute, but I can&#39;t because of this error. Does anyone know how to solve this issue? I would very much appreciate any help.

These are the commands I run in order to commit if it helps anyone out:

    git pull remotename master:dev
    git add --all
    git commit -m &quot;some message&quot;
    git pull remotename master:dev
    git push remotename master:dev

I would have thought that if I kept this order, I would not receive merge conflicts. I guess I was wrong. Thanks again

Update:
I should add that I have looked for a few hours on Google and StackOverflow, and followed different instructions, but I still can&#39;t `push` to the `dev` branch.

Updates were rejected because the remote contains work that you do not have locally

I have a repository with only one branch (`master`). I&#39;m the only contributor to my repo.

I&#39;ve recently added a `tag`, both locally and pushed to GitHub. After making what I though was the last necessary commit, but now I realize I should have made one more change/commit.

So what I have is:

    commit 124
    commit 125
    commit 126 &lt;-- tag v1.0
    commit 127

and I want to move the `v1.0` tag to the next commit, ie: `127`, both locally and in GitHub.

How can I do that?

Move tag one commit ahead

In IDEA I am trying to push some commits.
 
I have a requirement that on remote server it looks like single action.

I click to push and see following window
![enter image description here][1]


I expected to see squash checkbox here but don&#39;t see it.

Please help me.

  [1]: http://i.stack.imgur.com/K5WUe.jpg




How to combine group of local commits to single push in IDEA?

I would like to check for author&#39;s e-mail and name, surname to verify who&#39;s pushing to my repo.

Is there any way that I can come up with a command in git to show commiter&#39;s name/e-mail given only SHA1 of the commit?

This is what I came up with but it&#39;s far from ideal solution (the first solution is for git hook that&#39;s why it&#39;s using 2 SHA1s with `rev-list`. The second one simply uses `git show`):

    git rev-list -n 1 --pretty=short  ccd3970..6ddf170 | grep Author | cut -d &#39; &#39; -f2- | rev | cut -d &#39; &#39; -f2- | rev
    git show 6ddf170 | grep Author | cut -d &#39; &#39; -f2- | rev | cut -d &#39; &#39; -f2- | rev 

How to get (only) author name or email in git given SHA1?

When I use `git log` to check out my commit explanatory note I want it to look like this:

    1. what I changed
    2. blank line
    3. why I changed it

...being in 3 lines not 1 like this: 

    1. what i changed  2. blank line 3. why i changed

However, `git log` shows it in one line. So, how do I get this to happen using `git commit -m`?

How can I make git commit messages divide into multiple lines?

Is there a way to have &#39;**colspan**&#39; on **github markdown**?

I&#39;m trying to create a table where one row takes up four columns.

    | One     | Two        | Three   | Four          | 
    | ------------- |-------------| ---------| ------------- |
    | One                | Two               | Three          | Four                |
    
    | One     | Two        | Three   | Four          | 
    | ------------- |-------------| ---------| ------------- |
    | Span Across ||||


You can see a live preview by pasting the above here
http://markdown-here.com/livedemo.html


github markdown colspan

I need to document a library on GitHub that output colored text in the terminal.

I&#39;ve tried both span `&lt;style=&quot;color:red&quot;&gt;` and `&lt;font color=&quot;red&quot;&gt;`, but it seems to strip out both tags.

Is the only way to do this is with images of colored text?

&lt;hr/&gt;

I ended up adding screenshots to Git and using image links with GitHub relative URLs.












Is there a way to get colored text in GitHubflavored Markdown?

I have a table:


        | This | Is | A | Table |
        | :--- | -- | - | ----: |
        | foo  | ba | r | elbaT |

I&#39;d like the table to display in the center of my Markdown file instead of left-aligned. I am not trying to align text, but the entire table itself. Do I need to resort to HTML/CSS to achieve what I want?

This is for an Apiary.io project.



Is it possible to center tables in a markdown file?

I&#39;m trying to show a comparison between two photos in my README.md which is why I want to display them side-by-side. [Here](https://github.com/saadq/Sublime-Color-Schemes#solarized-ocean) is how the two images are placed currently. I want to show the two Solarized color schemes side by side instead of top and bottom. Help would be much appreciated, thanks!

How can one display images side by side in a GitHub README.md?

When editing an issue and clicking Preview the following markdown source:

    a
    b
    c

shows every letter on a new line.

However, it seems to me that pushing similar markdown source structure in README.md joins all the letters on one line.

I&#39;d like the new lines preserved in the README.md in this project: https://github.com/zoran119/simple-read-only-test

Any idea how?

Content Type	Original Author	Original Content on Stackoverflow
Question	AlbertEngelB	View Question on Stackoverflow
Solution 1 - Git	nulltoken	View Answer on Stackoverflow
Solution 2 - Git	zw963	View Answer on Stackoverflow
Solution 3 - Git	geg	View Answer on Stackoverflow
Solution 4 - Git	Matt G	View Answer on Stackoverflow

Github Commit Syntax to Link a Pull Request/ Issue

Git Problem Overview

Git Solutions

Solution 1 - Git

Solution 2 - Git

Solution 3 - Git

Solution 4 - Git

MySQL Alter table causes Error: Invalid use of NULL value

The parameterized query ..... expects the parameter '@units', which was not supplied

Attributions