Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [mysql]

MySQL is an open-source, relational database management system.

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ ("My S-Q-L"), but is often pronounced /maɪˈsiːkwəl/ ("My Sequel"). It is named for original developer Michael Widenius's daughter My.

The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Sun Microsystems, a subsidiary of Oracle Corporation.

Useful Reference:

523 questions
23
votes
7 answers

Is saving SQL statements in a table for executing later a bad idea?

Is saving SQL statements in a MySQL table for executing later a bad idea? The SQL statements will be ready for execution, i.e. there will be no parameters to swap or anything, for example DELETE FROM users WHERE id=1. I guess I'm being lazy, but I…
Amged Rustom
  • 373
  • 1
  • 3
  • 9
13
votes
4 answers

How to really master MySQL?

I have been using mysql for the same amount of time I have been using PHP. However I feel about 10x more confident in PHP; or any other programming language. But I just can't seem to really really grasp SQL. I mean, I can select, update, insert,…
JD Isaacks
  • 8,936
11
votes
2 answers

Is a blob more efficient than a varchar for data that can be ANY size?

When setting up a database I want to use the most efficient data type for potentially fairly long data. Currently my project is to store song titles and thoughts pertaining to that song. Some titles might be 5 characters or longer than 100…
BillyNair
  • 259
10
votes
4 answers

What is the main difference between HAS_MANY and BELONGS TO relationship in mysql?

After making little progress in web development and php I figured out if I can make my grip strong on database designing, I will be able to reduce much code and time in developing the application. But I happen to be a dumb in database designing so…
Umair Abid
  • 890
4
votes
1 answer

How to parse events and pull specific events - triggers vs ad hoc queries

What is the best method to parse events in daily batches from external source (csv file) that produces entries in a separate table if any of a multiple of conditions are met. Conditions can vary through time and need to maintain certain level of…
nbayly
  • 123
3
votes
1 answer

What is the purpose of stopwords?

I've just started learning about fulltext indexing and searching in MySQL and I've stumbled upon this list containing all of the "stop words" used in MySQL. I cannot understand what is tue purpose of these stop words, since this list contains a lot…
php_nub_qq
  • 2,224
3
votes
5 answers

When do I bite the bullet and hire a developer?

I have an awesome URL, I've had it since the mid 90's, and up until around 2002 I was having an awesome time writing music reviews and features into static pages and adding their URL to static index pages and everything was just great. Then things…
Paul Seattle
  • 141
  • 3
3
votes
1 answer

Voting System like Stack Exchange

I am trying to create a voting system like Stack Exchange. Should I create a table and insert values like following and then sum up the "vote" or there are some better ways to do this? Table name: vote id userid article_id vote 1 1001 …
black_belt
  • 171
2
votes
2 answers

How do MySQL joins really work?

In my case joining table inside subquery or outside subquery gives very few difference with COUNT CASE 1: about 6202 rows. In this case table_c is joined inside subquery, but is only joined (No other actions for the table, not selecting any data or…
George G
  • 133
1
vote
1 answer

Does it ever make sense to create tables dynamically?

I'm building a service where I need to filter activities from different products. The actual data itself lies in another key value store. As the service needs to support filtering on the activities as well was planning to use mysql for the filtering…
dakrpssngr
  • 21
1
vote
0 answers

Cascade reference date through full query

I have created a complex query that references a specific date (year and month to report on) on numerous parts of the script. What would be the best artifact to have to only change 1 line of code and have that cascade to all my script each time a…
nbayly
  • 123
1
vote
2 answers

Process string before or after insert into mysql

I have a device network where each device has different sensors (temperature, humidity, etc..). Each device uploads raw measured weather data every 10 seconds to a apache/php/mysql REST API. There are a few 100 devices sending data and this will…
Enrico
  • 113
1
vote
1 answer

Combine Data from Two Tables-Help Needed

I have developed a web site with a mysql backend, but am not satisfied with how I am getting one set of data and do not know how to get another dataset. The page in question is at: http://whistclub.org/test/ajax.php?vichill/results/1 The results are…
Bill
  • 13
0
votes
2 answers

Machine-Generated Data Sources for Infobright Coding Competition

I'm looking at entering the Infobright Coding Competition. They ask for public machine-generated data. I don't want to create my own. Anyone know where some exists? Here's what I'm looking at: http://www.infobright.org/contest/2011q1.
user19995
0
votes
2 answers

How to handle time differences in MySQL

I'm facing a problem with handling different timezones in MySQL. I have looked into similar questions that were previously raised, but I couldn't find a proper answer. The issue I'm encountering is as follows: I have multiple microservices and a…
Prasad Darshana
  • 29
1
2