Help with SQL commands to interact with a MySQL database
- Mac /usr/local/mysql/bin
- Windows /Program Files/MySQL/MySQL version/bin
- Xampp /xampp/mysql/bin
| /** Sample JSON response for a USGS query */ | |
| private static final String SAMPLE_JSON_RESPONSE = "{\"type\":\"FeatureCollection\",\"metadata\":{\"generated\":1462295443000,\"url\":\"http://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=2016-01-01&endtime=2016-01-31&minmag=6&limit=10\",\"title\":\"USGS Earthquakes\",\"status\":200,\"api\":\"1.5.2\",\"limit\":10,\"offset\":1,\"count\":10},\"features\":[{\"type\":\"Feature\",\"properties\":{\"mag\":0.2,\"place\":\"88km N of Yelizovo, Russia\",\"time\":1454124312220,\"updated\":1460674294040,\"tz\":720,\"url\":\"http://earthquake.usgs.gov/earthquakes/eventpage/us20004vvx\",\"detail\":\"http://earthquake.usgs.gov/fdsnws/event/1/query?eventid=us20004vvx&format=geojson\",\"felt\":2,\"cdi\":3.4,\"mmi\":5.82,\"alert\":\"green\",\"status\":\"reviewed\",\"tsunami\":1,\"sig\":798,\"net\":\"us\",\"code\":\"20004vvx\",\"ids\":\",at00o1qxho,pt16030050,us20004vvx,gcmt20160130032510,\",\"sources\":\",at,pt,us,gcmt,\",\"types\":\",cap,dyfi,finite-fault,genera |
| /* | |
| * Copyright (C) 2014 The Android Open Source Project | |
| * | |
| * Licensed under the Apache License, Version 2.0 (the "License"); | |
| * you may not use this file except in compliance with the License. | |
| * You may obtain a copy of the License at | |
| * | |
| * http://www.apache.org/licenses/LICENSE-2.0 | |
| * | |
| * Unless required by applicable law or agreed to in writing, software |
| public final class StoreContract { | |
| public static abstract class HeadphoneEntry implements BaseColumns { | |
| public static final String TABLE_NAME = "headphones"; | |
| public static final String COLUMN_NAME = "name"; | |
| public static final String COLUMN_PRICE = "price"; | |
| public static final String COLUMN_STYLE = "style"; | |
| public static final String COLUMN_IN_STOCK = "in_stock"; | |
| public static final String COLUMN_DESCRIPTION = "description"; |
| /** | |
| * Encode string into Base64, as defined by RFC 4648 [http://tools.ietf.org/html/rfc4648]. | |
| * As per RFC 4648, no newlines are added. | |
| * | |
| * Characters in str must be within ISO-8859-1 with Unicode code point <= 256. | |
| * | |
| * Can be achieved JavaScript with btoa(), but this approach may be useful in other languages. | |
| * | |
| * @param {string} str ASCII/ISO-8859-1 string to be encoded as base-64. | |
| * @returns {string} Base64-encoded string. |