MySQL is an open-source, relational database management system.
0
votes
0answers
4 views
MySQL WHERE IN Or Filter Using C # List
Basically I have a List of IDs (Int32) in a C# Class. When a user logs into our application I need to check the List of IDs against a list on a MySQL Innodb table to see if they have access to these ...
0
votes
0answers
8 views
PHP multiple entries
I'm creating a small project with PHP/MYSQL but i can't get my query working the way i need it. I have 2 tables
Table 1 (char):
Id, name.
Table 2 (spells):
Id, char, spell_name.
I'm getting the ...
0
votes
0answers
4 views
Passing a serialized array to an mySQL cell in wordpress when it contains characters that break the mySQL statement
How do I pass a serialized array to a database in wordpress. In this scenario $push_votes is a serialized array.
global $wpdb;
$tablename = $wpdb->prefix . "myplugin";
$wpdb->query("UPDATE ...
1
vote
0answers
15 views
What would be a good way to write this SQL query in a better way?
SELECT
MAX(timestamp) as end,
MIN(timestamp) as start,
(MAX(odometerKM) - MIN(odometerKM)) as distanceTravelled,
( SELECT COUNT(*) FROM EventData WHERE speedKPH = 0 AND timestamp ...
0
votes
0answers
6 views
Gem mysql2 doesn't compile with the latest mysql, 5.6.12, in MacOS X with Homebrew
I updated all the packages I installed with Homebrew. MySQL got upgraded to 5.6.12 (from 5.5.27 or so):
$ mysql --version
mysql Ver 14.14 Distrib 5.6.12, for osx10.8 (x86_64) using EditLine wrapper
...
-3
votes
0answers
19 views
Exit if user has already applied
So i've made a form on my website to hire people.
But I want so they can only apply one time.
So if applied = 1 return to another page.
I hope someone could help me with this.
0
votes
1answer
26 views
File or Table on PHP to store purchase information
I write in order to have an advice about this considerations:
I have to develop my first web site that allow visitors to buy items.
The items that a client buy have to be memorized also when he ...
-1
votes
1answer
16 views
mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO)
i am new to php. i am trying to connect mysql using xampp php myAdmin.
i HAVE TAKEN THIS CODE FROM MY INSTRUCTOR. EVEN HE HAS FAILED TO CONNECT IT. THERE SEEMS TO BE NOTHING WRONG WITH THE CODE. EVEN ...
0
votes
2answers
13 views
how to establish in models file that a django model should be defined as NOT NULL?
In my models.py file I would like a way to explicitly state that certain fields in my model should be defined as NOT NULL such that the MySQL code would be
CREATE TABLE Minion_job(MyColumn ...
-1
votes
1answer
15 views
UNION - MySQL vs SQLight
I have the following SQL-Query:
SELECT *
FROM (SELECT sku,
price
FROM pricelist_98
UNION
SELECT sku,
price
FROM pricelist_10) AS ...
-3
votes
0answers
35 views
Secure registration php [closed]
Recently i've been creating a registration system for a game, I've tested it against injections, and XSS attacks, none have worked for me so far which is great. Although, I am not very experienced ...
0
votes
2answers
16 views
Replacement throughout the database MYSQL
I'm looking to replace all occurrences of characters in all columns of all tables in my database.
I got the name of my column like this:
select table_name, column_name from ...
0
votes
3answers
29 views
How to use OR in MySQL query
I'm new to SQL and can't figure why this query returns no results BUT I do know it's becuase I'm using the OR condition incorrectly. If
Can someone please show the correct way to go about this?
...
0
votes
0answers
25 views
MySQL distinct not returning some rows
I am having this problem with a distinct query that i do not fully understand. I think showing an example is the best way to describe it
query:
SELECT *
FROM bestride_dealers
ORDER BY ...
0
votes
0answers
27 views
MySQL - add zeroes to a time based query where no result found
I have a query that prints out times and averages. The only problem is - if nothing happened in the time period of the 6 weeks that I'm running this for - it skips right over it... I need that 15 ...
