How to allow remote connection to mysql

How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source.How can I do that? 1:That is allowed by default on MySQL.What is disabled by default is re

ng-model for

ng-model for

I tried to use ng-model on input tag with type file:But after selecting a file, in controller, $scope.vm.uploadme is still undefined.How do I get the selected file in my controller? 1:I created

SQL split values to multiple rows

SQL split values to multiple rows

I have table :id | name 1 | a,b,c 2 | bi want output like this :id | name 1 | a 1 | b 1 | c 2 | b 1:If you can create a numbers table, that contains numbers from 1 to the maximum fields to split, you could use a s

Identity increment is jumping in SQL Server database

Identity increment is jumping in SQL Server database

In one of my tables Fee in column "ReceiptNo" in SQL Server 2012 database identity increment suddenly started jumping to 100s instead of 1 depending on the following two things.if it is 1205446 it is jumps to 1206306, if it is 1206321, it j

SQL Server: Examples of PIVOTing String data

SQL Server: Examples of PIVOTing String data

Trying to find some simple SQL Server PIVOT examples. Most of the examples that I have found involve counting or summing up numbers. I just want to pivot some string data. For example, I have a query returning the following.Action1 VIEW

Is there a CSS selector for elements containing certain text?

Is there a CSS selector for elements containing certain text?

I am looking for a CSS selector for the following table:Peter | male | 34Susanne | female | 12Is there any selector to match all TDs containing "male"? 1:If I read the specification correctly, no. You can match on an element, th

Android Studio: Add jar as library?

Android Studio: Add jar as library?

I'm trying to use the new Android Studio but I can't seem to get it working correctly.I'm using the Gson library to serialize/deserialize JSON-objects. But the library somehow isn't included in the build.I had created a new project with jus

What are the best JVM settings for Eclipse? [closed]

What are the best JVM settings for Eclipse? [closed]

What are the best JVM settings you have found for running Eclipse? 1:It is that time of year again: "eclipse.ini take 3" the settings strike back! Eclipse Helios 3.6 and 3.6.x settingsalt text http://www.eclipse.org/home/promotions/frie

Can PHP PDO Statements accept the table or column name as parameter?

Can PHP PDO Statements accept the table or column name as parameter?

Why can't I pass the table name to a prepared PDO statement?$stmt = $dbh->prepare('SELECT * FROM :table WHERE 1');if ($stmt->execute(array(':table' => 'users'))) { var_dump($stmt->fetchAll());}Is there another safe way to insert a table

SQL Show most recent record in GROUP BY?

SQL Show most recent record in GROUP BY?

I have a table that looks like this:id | SubjectCode | Grade | DateApproved | StudentId1 SUB123 1.25 1/4/2012 2012-123452 SUB123 2.00 1/5/2

Visual Studio 2013 Preview: No Publish To File System?

Visual Studio 2013 Preview: No Publish To File System?

So I've built my project and I want to use the VS2008/2010/2012 "Publish To File System" option in Visual Studio 2013 Preview to push my project to a staging server for testing... but I can't find it anywhere in any of the menus.It's bad en

XDocument get XML element by the value of its name attribute

XDocument get XML element by the value of its name attribute

I have an XML result like this 0 16 firstname1 6557 Manager surname1 firstname2 6203 Director surname2

EntityFramework 5 filter an included navigation property

EntityFramework 5 filter an included navigation property

I would like to find a way using Linq to filter a navigation property to a subset of related entities. I know all answers around this subject suggest doing an anonymous selector such as:query.Where(x => x.Users.Any(y => y.ID == actingUser.

Eclipse - How to fix error “No persistence.xml file found in project” JPA issue

Eclipse - How to fix error “No persistence.xml file found in project” JPA issue

Error "No persistence.xml file found in project" in Eclipse.Aim: Create a new project GWT+App engine+Maven Steps to create this:Google eclipse plugin: select "New Web Application Project". set the name etc. right-click on the project > Con

Finding the hash value of a row in postgresql

Finding the hash value of a row in postgresql

Is there a way to get the hash code of a row in postgresql? I need to export some data only if there is some changes in the data after the last export, the last exported data rows can be stored in a table, the when the again I need to expo

How to decorate JSON.NET StringEnumConverter

How to decorate JSON.NET StringEnumConverter

I'm consuming an api which returns string values like this. some-enum-valueI try to put these values in an enum, since the default StringEnumConverter doesn't do the job I try to decorate this Converter with some additional logic. How can I

LG G2 vs980 not recognized by ADB devices command (Win7 on virtualbox)

LG G2 vs980 not recognized by ADB devices command (Win7 on virtualbox)

I have been developing android mobile apps via eclipse in school for some time now, deploying the apps to virtual devices. However, I now want to deploy them to my LG G2 android device for testing and speed purposes. I know there are posts

How do I export particular column in MySQL using phpmyadmin?

How do I export particular column in MySQL using phpmyadmin?

I do have thousands of website list and other info in MySQL database.I want only website column named "web" to be exported to excel or text or csv.I know how to export the whole data but dont know how to export particular column. 1:Query

Convert dictionary values to list using linq

Convert dictionary values to list using linq

Following code giving me 'Evaluation of lambda expressions is not valid in the debugger'. Please suggest where I am doing wrong from below - List lstFiedls;lstFiedls = objDictionary.Select(item => item.Value).ToList();Thanks, 1:You don't

'MOD' is not a recognized built-in function name

'MOD' is not a recognized built-in function name

I wanted to use MOD function in SQL Server 2008R2 and followed this link but still got the message: 'MOD' is not a recognized built-in function name.DECLARE @m INTSET @m = MOD(321,11)SELECT @mError: Msg 195, Level 15, State 10, Line 2

The type or namespace name 'Xamarin' missing in xamarin studio

The type or namespace name 'Xamarin' missing in xamarin studio

I'm getting this error "MyApp\App.cs(7,7): Error CS0246: The type or namespace name 'Xamarin' could not be found (are you missing a using directive or an assembly reference?) (CS0246)". i'm using Xamarin studio to make cross platform app vi

using sql count in a case statement

using sql count in a case statement

I have a table and i need to present the output in the following fashion.tb_a:col1 | reg_id | rsp_ind Count of rows with rsp_ind = 0 as 'New' and 1 as 'Accepted'The output should be NEW | Accepted9 | 10I tried using the following query.

jquery multiple ids same function

jquery multiple ids same function

I have a table that has a date inputI am trying to access it via for the first oneHow do I access everything? 1:You could use the "attribute starts-with" selector:$(function() { $("input[id^='datepicker']").datepicker({ showBut

Protractor “by.css()” vs “$()” Dollar Sign vs “$$()” 'Bling Bling'

Protractor “by.css()” vs “$()” Dollar Sign vs “$$()” 'Bling Bling'

I don't really understand what the $ and $$ commands are for. I thought they are just a replacement for 'by.css' but why the $$? I thought, that given the above, these would be equivalent:element(by.css('#eId'));andelement($('#eId'));Howeve

MAX function in where clause mysql

MAX function in where clause mysql

How can I use max() function in where clause of a mysql query, I am trying: select firstName,Lastname,MAX(id) as max where id=max;this is giving me an error:Unknown column 'max' in 'where clause'Any Help? Thanks in advance. 1:You can't r