I have a web application running over a MySQL database (in development). I'm considering to migrate my application to Google App Engine, and would like to better understand how my simple relational database model can be transformed to the non-relational approach. I'm a long time relational database person, and I have no experience with ...
I have the following situation: If have a MySQL db with a InnoDB table which I use to store unique numbers. I start a transaction, read the value (eg. 1000471), store this value in another table and update the incremented value (100472). Now I want to avoid that somebody else even reads the value while my transaction is running. If I w...
Hi guys, I need to know how can I backup my MySQL databases on a periodic basis and have the backups downloaded to my local server. I'm using navicat and it has an easy backup interface and tasks schedule facility but it backs up the db and stores the backup on the server itself. I would like to have a way to download the backups once ma...
I asked a similar question yesterday which may have been poorly worded, either way I didn't understand and this is something I really need to crack :) I've never done it before and would be very useful for so many of my projects. This is for a directory website. I have three tables: entry, location, and entry-locations. entry contains i...
So, i'm building a members rewarding system for my forum and got stuck on this query for selecting "forum topic with most different participants". I already have this query that counts how many posts (replies) each forum topic in last 24 hours has. SELECT poster . * , count( odgovori.id_odgovor ) AS broj, members.username FROM poster I...
I am using Hibernate 3 +Mysql 5.1 and after 98 insertion i am getting this Exception : com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" My hibernate.cfg.xml file is : com.mysql.jdbc.Driver jdbc:mysql://localhos...
I have a multi page form which uses multiple tables in mysql for the entered values. One of the pages has a form which needs to have the option of enabling the user to click a + to add an extra line if they want to include extra information. There can be any number of lines added. When the user clicks the +, jquery and php inserts the c...
This is how things work I use Wordpress category tables and have 2 main categories. The first one is called "location" and the other one "subject". Both categories have sub categories of their own. In my example we have "location" category 17 and "subject" category 3. This is what I want to do I want to select ONLY the data where BOTH ...
I have two tables: posts - holds post information listen - holds information on what other users you are listening to. (what users posts you want to view) The structure of listen is: id(uniqueid) userid(the users unique id) listenid(id of a user they are listening too) How would I gather all the entries from listen that mach...
Hello everyone. I get the following error: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set' This is the query I was trying to execute: SELECT ID FROM xs_user_profiles WHERE ID='' AND FIND_IN_SET('1',site_structure); I looked up the properties of this table a...
I wonder if anyone has come across this issue before. I have a string converted to a date and sorted ascending. The date is sorting numerically but it is not sorting on the month. I wonder if anyone has had this issue and can shed some insight as to how to get the date to sort correctly. SELECT u.url_id, url, title, descripti...
Problem: I have a database of sensor readings with a timestamp for the time the sensor was read. Basically it looks like this: Sensor | Timestamp | Value Now I want to make a graph out of this data and I want to make serveral different graphs. Say I want one for the last day, one for the last week and one for the last month. The reso...
I'm trying to enter a list of items into Google Base via an XML feed so that, when a user searches for one of these items and then clicks the search result link in Google Base (or plain Google), the user is directed to a dynamic Web page on my Web site. I'm assuming that the only way to specify a specific link (either static or dynamic) ...
I added a new column to a table called price_request_date because I now need to track the date each one was made. I made it so new ones enter the current date when they insert a new row. I was just wondering if there was any way to fill in the previous rows with the dates they were entered? I don't know if MySQL keeps track of that sort ...
I don't know almost anything about this so if you have some experience let's share! Thanks!!! sorry Matt: OpenOffice 3.0 MySQL 5.0.75 Ubuntu 9.04 ...
I have an old MySQL database with encoding set to UTF-8. I am using Ado.Net Entity framework to connect to it. The string that I retrieve from it have strange characters when ë like characters are expected. For example: "ë" is "ë". I thought I could get this right by converting from UTF8 to UTF16. return Encoding.Unicode.GetString(...
There are 2 columns that I want data from. Basically I want to see new signups per day. Go easy on me, my first day with mysql (or any DB for that matter) So far I have this mysql> select created, count(id) from user group by created; +---------------------+-----------+ | created | count(id) | +---------------------+-------...
mysql> show create event online_event; +--------------+-----------------------------------------+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+---------...
I'm trying to use the prepareStatement function. The code is below. After it executes, it returns me a bunch of string 'vlicense' instead of the the values. When the code finishing the statement.setString(), the statement becomes "select 'vlicense' from Vehicle". However, it needs to be "select vlicense from Vehicle" without the quotatio...
It's written in PHP, and sometimes when I restart mysql, will report: Debug Warning:line 24 - mysql_fetch_array(): supplied argument is not a valid MySQL result resource Is there any way to detect if $result is a valid MySQL result resource? ...