MySQL is an open-source, relational database management system.
0
votes
2answers
7 views
Select from table named 'key' in MySQL
I have table created by ORM named 'key'. 'key' is MySQL keyword so I cannot select it just SELECT * FROM key;.
How to perform select from table named 'key' in MySQL?
1
vote
2answers
18 views
Fetch mysql data using while condition in div
Before i was displaying zones records static although i have records in database table
HTML
<div class="pub_fot_sec_menu pub_fot_list_fst">
<h2><a ...
0
votes
0answers
22 views
Should I allow \n store into database
I have textarea in my form
when user type Enter key, it will store \n into database
should I allow \n to store into mySql database? or should I str_replace it, what if user type abc\n\n\n\n\n\n\n\n ...
1
vote
1answer
15 views
echo single value from mysql table
I've been driving myself mad with this for the last hour. It should be so easy but I just cannot work it out:
All I am trying to do is echo 1 value (in column "active") from a mysql table where the ...
0
votes
1answer
12 views
Import google calendar into mysql database
I'm looking for a way to import a google calendar into a database. All the entries are in the format of (confirmed) name1, name2, name3 name event or ?,?,? name event if not confirmed or (confirmed) ...
0
votes
0answers
5 views
How to render a python tkinter file along with the mysql database tables?
I am currently developing a GUI as a part of my internship using Tkinter. Now I have a mysql server in place which has tables which I query often in my python script to fill in certain values and do ...
0
votes
2answers
28 views
PHP teminates(?) before finishing the script while loading CSVs
I have a PHP script file that loads a series of CSV files into a MYSQL database.
when I run the script from the command line all going well but when I run it from a browser it quits in the middle ...
-1
votes
0answers
13 views
create a procedure/view with consecutive entries of two table
I have created two different queries as follows-
Stock In table:
mysql> SELECT stockin_id, serialno, productid, group_concat(serialno) AS sisn,
count(serialno) AS cnt FROM stockin WHERE ...
0
votes
1answer
6 views
web service connection to mysql fails
Spent a long time looking for an answer for this one - the web service I posted and which resides on my IIS server (on my computer) fails to make a connection to MYSQL (ADODB connection.open fails) ...
0
votes
0answers
9 views
Handling a form from jquery UI dialog
I have jquery UI dialog box to add new users to database.
This is HTML for dialog box -
<div id="dialog" class="new_user_dialog_box" title="Add New User">
<p>Fill this form with ...
0
votes
0answers
6 views
How to add or save file path in xampp (mysql) field?
I'm trying to create a program that will display an image from mysql database (xampp) to picturebox (vb.net). I don't know where to start on how to save the file path on my image field. Can anyone ...
0
votes
2answers
11 views
MySql “For Update” results in Error
A new project has forced me to lock a table while updates are processed. I have followed every suggestion and guide I can find, including How to lock mysql tables in php and
...
1
vote
3answers
17 views
PHP MYSQL Join and output unmatched results
I've two tables : One called "Collected_items" and the Other "Wrong_Collected"..As shown below :
**collected_items**
item_no qty
x1 10
x2 20
BB 5
Z1 20
x13 13
...
0
votes
2answers
27 views
mysql, zero characters in strings
In my table, among the other things I need an array of ints and 1 byte is big enough, so I though I can use a string and I was wondering can my string contain the zero character or dose that represent ...
0
votes
3answers
20 views
MySQL INNER JOIN not working
Im trying to write this statement for a game ladder I am making. All the inner joins worked until I added the team names into the equation.
SELECT tblMatch.AttackingTeam,
...
