sql - CREATE TYPE on MySQL -

-

I can not create a new data type on MySQL, the query is given below 

  Type person as object (name VARCHAR (30), SSN VARCHAR (9));

How can I do this on MySQL

MySQL can not contain user-defined types I (at least, not in the current version.)


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

objective c - How to open front/back camera at the same time in iOS developing? -

-
I want to use the front and rear camera at the same time in iOS development: when I take a photo back After the camera, the front camera can be opened and another can take a photo. By the way, these two photos are in a picture: vertical arrangement. Has anyone done this before? UIImagePickerController to take the picture, and to determine which camera is used Is in. / P> To merge the pictures, I found an example through search (its recommendation in the future)
Read more

xml - XMLStarlet - UTF-8 Nordic characters -

-
To use an XMLStarlet (windows) to edit an RSS feed, but the Norwegian letter 'ANSA' There are some issues with. I am using an example found on this site () This is my feed. Xml is (Notepad ++ says it is encoded in UTF-8) I am not using the following example because it is for Linux script, but my long command line is similar. # ! / Bin / sh TITLE = "Test Title ÆØÅ" LINK = "http://www.example.com" DATE = "` Saturday, 26 July 2014 01:14:30 + 0200` "xmlstarlet ed -l -a" / / Channel "-tmm-nmad-v" "\ -s" // item [1] "-t emil - t-- v" $ tITLE "\ -s" // item [1] "-t Elem -n link -v "$ LINK" \ -s "// item [1]" -t elem -n pubDate -v "$ DATE" \ -d "// item [condition ()> 10]" Feed .xml; Windows Command Line (What I'm using): xml.exe ed -l -a "// channel" -t elem - N item-v "" -s "// item [1]" -t elem -n title -v...
Read more