Tagged Questions
MySQL is an open-source, relational database management system.
0
votes
0answers
7 views
Mysql-client cannot connect new ip
Mysql client is behaving strangely on one of my servers.
I have my mysql server (ip 10.0.0.190, used to be 172.16.0.190).
I have another server from which I try to connect, which I will refer to as ...
0
votes
0answers
13 views
How to retrieve data from a single cell in mysql?
I'm trying to retrieve an email address from a table in mysql using $keyword (keyword can be anything in the question field) to identify the row. I am successful in finding the row I need with the ...
0
votes
0answers
4 views
mysqld.exe keeps crashing
I appear to be in a bit of a bind. I have been working on some simple design changes to our website and having finished went to release them live. No sooner than I uploaded the affected pages, the ...
0
votes
0answers
4 views
How to run the sql script from the EER designed on MySQL Workbench to MySQL Server (Ubuntu)
I have generated this script from MySQL WorkBench but when i try to run it in my MySQL Server, i get the following error:
'17:28:11 DROP SCHEMA IF EXISTS MYA_Database_Schema Error Code: 1044. Access ...
0
votes
0answers
14 views
Export data from mysql to excel with UTF-8 encoding
I have a mysql row with utf8_general_ci collation, when I export it to csv, instead of correct utf-8 characters I get Ć…ā€¦I etc, how to make excel understand UTF-8 encoding here is my code:
$conn = ...
0
votes
2answers
17 views
A way to get information from mysql to Android app
I have an Android app which handles strings with web adresses and connects to them with a webview.
Then I have a mysql db with the strings and some more information.
I've read that I should connect ...
android
0
votes
2answers
19 views
Apostrophy and quotation marks won't add to mysql from a form
I need some help here!
I have a form on a site admin page, the owner fills in his projects and the get added to a mysql db, but sometimes the data contains single or double quotes so it won't add to ...
0
votes
1answer
34 views
MySQL COUNT() with multiple joins
I am building a course system, with courses, instructors and a table to relate the two.
Symplified table instructors:
id | name | ...
Symplified table courses:
id | name | instructors_needed | ...
0
votes
1answer
7 views
Get entries between one date and another via a unix timestamp
If I have a column in a table called creation_date in the database that contain unix timestamp values, how do I get results returned that were only created between for example May 10th 2013 and June ...
0
votes
1answer
20 views
preventing dynamic php table display correctly
I have the following code to display a block of six products from a mysql database.
It displays as two columns three rows and I get individual photos and correct page links in each of the six ...
0
votes
0answers
8 views
unable to get the column name for multiple tables using hibernate
I have three tables and three .hbm files and the bean classes with getter and setters created by hibernate tool in eclipse.
I am returning the result to a web services and converting to a j son.
...
1
vote
1answer
15 views
mysql right join as discussed in the example is not giving right result
i have a table A with a as a column and table B as a , name, address
table A has 1,1,2 as input
table B has (1, hello , india), (1,hi, nowhere),( 2,hukka,china) as values
SELECT * FROM a
right ...
-1
votes
0answers
24 views
how can i connect SQLite and MYSQL
I have installed sqlite3 in my local sytem and mysql in the main server.here sqlite for off-line support when the internet connectivity is closed user can retrieve and send the data from local ...
0
votes
0answers
39 views
return nothing from multiple tables join in mysql - three tables
I wrote the below sql query to get one video that not seen by the current user IP. But I always get no video. This is my code
SELECT ...
0
votes
0answers
19 views
is it possible to export the search data into a csv file
i m working on php with mysql and there is a search form in my site by which a user can search by name and location from mysql database.so i have a table in database named customers which have 5 ...
