Questions tagged as 'mysql'

Tagged questions
0
answers

How to use Google Analytics with ionic 3

Good afternoon, I'm making an app using ionic 3 and I use the RESTful API with php to connect to the Mysql database, and I need to use Google Analytics in the project, but I can not find a functional tutorial, if someone can send me some link,...
asked by 27.07.2018 / 18:40
1
answer

Pass the data of a spinner to mysql

Hello, so my question is small and simple (but I can not solve kkk) I just want to know how to pass the value that was selected in Spinner to the database when clicking a button, here my script sp.setOnItemSelectedListener(new AdapterView.O...
asked by 18.07.2018 / 21:41
1
answer

how to use the LPAD function with COUNT?

Just for example: I'm trying to make a select where a leading zero will be added if the number is less than 10. Examples: SELECT COUNT(1); Returns = > 1 SELECT LPAD(1, 2, 0); Returns = > 01 SELECT LPAD(COUNT(1), 2,...
asked by 18.07.2018 / 22:25
0
answers

Convert charset Latin1 to Utf-8 at column level

I have a huge bank in Latin1 and I need to convert ALL the values of ALL the columns of the bank. Searching discovered a command that does this manually. UPDATE tabela SET coluna = CONVERT(cast(CONVERT(coluna USING latin1) AS BINARY) US...
asked by 18.07.2018 / 18:38
0
answers

Error - Connect with Mysql with PDO

I'm trying to connect to a Mysql Bank remotely, through PDO + PHP. Mysql Bank is managed by a team, I do not have access to it. The Bank was created and the tables too. I was given the appropriate permissions to the bank by my user. However, whe...
asked by 14.07.2018 / 00:20
0
answers

ASP Classic & MySQL - Find out what page the X-register is in

I have a problem that I think is more logical than the language itself, but if they can respond in ASP Classic it helps a lot. I need to create a function, where given an X record, and a quantity of records per page, indicate on which...
asked by 13.07.2018 / 20:02
1
answer

See how much time is left for a given event to happen - [mysql]

I'm new to mysql and have an event created in the mysql database, and was wondering if you have any way to check when it's still time for that event to run. Is that possible?     
asked by 11.07.2018 / 22:32
0
answers

Run WebSocket with the hosted application

The project is a chat with php, Mysql and AJAX. I'm using a WebSocket with Ratchet to run in real time. It ran all right on localhost, but when hosting the project I could not open the connection again when I accessed the websocket url. &l...
asked by 11.07.2018 / 21:39
1
answer

Mysql Join check if given data does not exist in another table

TABLE "profile" id nome 1 UserA 2 UserB 3 Usuario1 4 Usuario2 5 Usuario3 6 Usuario4 TABLE "friends" id amigo1 amigo2 status 2 3 2 1 4 4 1 1 5 2...
asked by 11.07.2018 / 20:29
0
answers

Synchronize sqlite with an online database

I need to synchronize (one playing information to the other) a sqlite DB with some DB server like sqlserver or mysql, and I would like to know how I can do this, I'm using C # language with visual studio, Thanks Edit: Just to be clearer, I'm...
asked by 11.07.2018 / 20:24