How can i connect MySQL database with objective project?
I want to connect MySQl database with my iphone application.Read, write, save some data into the database.How can i do this. ...
mysql
Using results from parent queries in nested select
I'm sure this is a fairly trivial problem, but I'm not sure what to google to find the solution. I have a table that looks like this: CREATE TABLE IF NOT EXISTS `transactions` ( `name` text collate utf8_swedish_ci NOT NULL, `value` decimal(65,2) NOT NULL, `date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_swe...
Sql Server query syntax
Hi Sql Server gurus, I need to perform a query like this: SELECT *, (SELECT Table1.Column FROM Table1 INNER JOIN Table2 ON Table1.Table2Id = Table2.Id ) as tmp FROM Table2 WHERE tmp = 1 I know I can take a workaround but I would like to know if this syntax is possible as it is (I think) in Mysql. ...
SELECT * WHERE NOT EXISTS
Hi guys, I think I'm going down the right path with this one... Please bear with me as my SQL isn't the greatest I'm trying to query a database to select everything from one table where certain cells don't exist in another. That much doesn't make a lot of sense but I'm hoping this piece of code will SELECT * from employees WHERE NOT E...
SQL for parsing multi-line data?
I have the unfortunate task of having to import data from excel into a database on a regular basis. The table looks something like this: IssueID References 1234 DocID1<cr>DocID2<cr>DocID3 1235 DocID1 1236 DocID2 1237 DocID2<cr>DocID3 References is a multi-line text field. What I'm trying to do is cr...
django auth User truncating email field
I am having an issue with the django.contrib.auth User model where the email max_length is 75. I am receiving email addresses that are longer than 75 characters from the facebook api, and I need to (would really like to) store them in the user to continuity among users that are from facebook connect and others. I am able to solve the p...
MySQL - show field value only in first instance of each grouped value?
I don't think this is possible, but I would like to be proved otherwise. I have written a simple report viewing class to output the results of various database queries. For the purpose of improving the display, when I have a report with grouped data, I would like to display the field value only on the first row of each unique value - an...
database locking problems with django
I have a webpage which interacts with several external APIs and in order to speed things up (the speed increase is almost linear because the majority of the time is spent waiting for http responses, etc), the code is threaded so that it pulls the content from several APIs at once. The problem is, I am running into database locking presu...
C# Database abstraction for Microsoft SQL Server, Oracle, MySQL and DB2
I need an example C# source code that abstracts databases (easy to change from one database to another with minimal code modification). Do you know some sample sites or tutorials with good quality? Specific target databases are as follows: 1. Microsoft SQL Server 2. Oracle 3. MySQL 3. DB2 My specific requirements and encountered issue...
Developing a robust PHP postback handler
I'm developing a php based CMS, and I'm currently re-writing it into a state that is usable for customers. (My first version was internal only; and a somewhat kludgy mess :P) In my first version, I had a function called HandlePostBack() which checked for the existance of a significant number of $_POST variables - the submit button from ...
mysql nested SELECT in UPDATE of same table
Hi, Essentially I need to do something like this.... this is just an example... but the syntax of the first query doesn't work in MySQL update people set prize = '' where prize = 'Gold' and class = (select class from people where id = person_id); update people set prize = 'Gold' where id = <id>; Only one person can have the Gold pri...
Codeigniter : Problem inserting accents in Mysql.
Hi everybody, I'm trying out code igniter, and I came across an error message while trying to insert a new row in my Mysql database. The text I'm trying to insert is in French, and contains some accents. Here's my code : $data= array( 'title' => $this->input->post('title'), 'date' => $this->input->post('date'), 'mytext' => $thi...
Why does this MySQL function return null?
Description: the query actually run have 4 results returned,as can be see from below, what I did is just concate the items then return, but unexpectedly,it's null. I think the code is self-explanatory: DELIMITER | DROP FUNCTION IF EXISTS get_idiscussion_ask| CREATE FUNCTION get_idiscussion_ask(iask_id INT UNSIGNED) RETURNS TEXT DE...
how to query without defining table initial name?
Hi, I have following tables. genre: genre_id name actors: actor_id name movies: movie_id actor_id genre_id title I have following query to select all the actors with genre_id 3. select a.name, m.genre_id from actors as a , movies as m where m.genre_id = 3; is it possible to make a query without "movies as m" sin...
jQuery firefox issue with different servers
Hi. I'm developing a simple voting system for my site with jQuery. When I tested it on my local (own PC server), it all worked fine (on IE, Firefox and Chrome). When I uploaded to my main server, Firefox gave me an error. Considering that Firefox works fine on my local server, it has to do with the difference in servers... This is the ...
Any way to select without causing locking in MySQL?
Query: SELECT COUNT(online.account_id) cnt from online; But online table is also modified by an event, so frequently I can see lock by running show processlist. Is there any grammar in MySQL that can make select statement not causing locks? And I've forgotten to mention above that it's on a MySQL slave database. After I added into ...
Complete set in SQL
Hi, I needed to come up with a SQL query that returns rows that satisfy multiple conditions. This article describes what I needed to do and the solution: http://thenoyes.com/littlenoise/?p=58 Basically it uses a bit operation to figure out if a provided string is found.. but I'm having hard time following how it works. SET @q = 'A,...
How do you refresh the MySQL configuration file without restarting?
Apache has such a feature, what about MySQL? Does one exist? ...
SELECT 1 from DUAL: MySQL
In looking over my Query log, I see an odd pattern that I don't have an explanation for. After practically every query, I have "select 1 from DUAL". I have no idea where this is coming from, and I'm certainly not making the query explicitly. The log basically looks like this: 10 Query SELECT some normal query 10 Query...
Are asynchronous Django model queries possible?
I'm new to Django, but the application that I have in mind might end up having URLs that look like this: http://mysite/compare/id_1/id_2 Where "id_1" and "id_2" are identifiers of two distinct Model objects. In the handler for "compare" I'd like to asynchronously, and in parallel, query and retrieve objects id_1 and id_2. Is there a...