MySQL is an open-source, relational database management system.
0
votes
0answers
19 views
mysql fetch array is adding backslashes
i seem to be getting this from mysql, although when i look at phpmyadmin it looks fine. This is the output json. The exact mysql_fetch_array echo is exactly the same
...
0
votes
1answer
19 views
insert update delete in mysql with single query
I have two table source and target. Is it possible to perform following operation in single query?
If the row exists in both the source and target, UPDATE the target;
If the row only exists in the ...
0
votes
0answers
26 views
Combined two MySQL query into one
I have two different queries as follows-
SELECT s.serialno, s.productid, s.description, s.in_quantity, s.uom,
s.shiptype,s.receiveddate, s.project_id, IF(EXISTS(SELECT so.serialno
FROM stockout so ...
1
vote
1answer
24 views
mysql return print in array twice
I am trying to get mysql to put everything into a array which would be easier for me to work with later down the road.
I currently am using the following
$result = mysql_query('SELECT * FROM ...
0
votes
0answers
15 views
Load infile query issue in mysql
We are using Load data infile query to load txt files in the database (mysql) .
we have a continues flow of text files to process using load query and is dumped in the table
but sometimes the load ...
0
votes
1answer
19 views
How to show row as a column in MYSQL tempTable result
Net, MYSQL web Application.
We have created stored procedure which will return table, But now we want to change structure of that procedure for display purpose.
So How to make Mysql stored ...
0
votes
0answers
14 views
Storing string in binary format in MySQL
Why page title are stored in binary format instead of char format in MediaWiki? http://www.mediawiki.org/wiki/Manual:Page_table#page_title
SELECT page_id, BINARY CONVERT(page_title USING utf8) as ...
2
votes
1answer
26 views
MYSQL formate string to number
How to format string to number in mysql.
In example,
Convert value 1,222,333.22 to result: 1222333.22
Regards,
0
votes
0answers
23 views
Adding filter to the query
I have a script in which I have filter based on UserName but I also want to add filter for LoginTime and LogOutTime where I can find information between LoginTime and LogOutTime with username..
how ...
0
votes
2answers
18 views
Given these tables how would I select all cases that are not tagged?
A user can have an unlimited number of cases and a case can have zero or more tags. How would I SELECT all of a specified user's cases which are not tagged? I'm using MySQL.
cases:
id INT
...
0
votes
1answer
23 views
ERROR 1054 (42S22): Unknown column 'ââ' in 'field list'
I get this annoying error when I try to insert data from db1 to db2 in MaridaDB 10 using mysql CLI. This is while all the columns exist.
INSERT INTO db2.thread (threadid, title, postuserid, ...
0
votes
1answer
35 views
Updating image issue with php using form
I am having an issue with my php form when i try and update the image which i hope someone can help with.
The form submits the updated fields to the database, however the image upload function which ...
-1
votes
2answers
44 views
MySQL as a database server
Is there any way to configure mySql as a database server with concurrency access?
I want to develop a windows application with a open source database where multiple access at the same time. as per ...
0
votes
5answers
28 views
Change the selectbox value according to the database value
I have a select box which have more than 750 option value.Actually it is hardcoded in the HTML page.I need it to insert a separate table and using foreach to populate it.Please let me know is it ...
0
votes
1answer
15 views
encoding proplem after moving to a new host with newr ver . php and mysql
this proplem has apeered after moving from i page to a newer host wich uses newer ver of php and mysql ..
the proplem is we use common database to handle two scripts
- main one ( has back end ) ...
