I need to launch a server side process off a mysql row insert. I'd appreciate some feedback/suggestions. So far I can think of three options: 1st (least attractive): My preliminary understanding is that I can write a kind of "custom trigger" in C that could fire off a row insert. In addition to having to renew my C skills this would r...
Here is my desired transaction order: User1 select field, perform operation, update with new value. User2 select field, perform operation, update with new value. User3 select field, perform operation, update with new value. From what I understand the first select only perform a write-lock while the second one perform read and write l...
I have a query like this (Mysql 5.X, PHP - formatted for legibility) $query =" SELECT p.p_pid, p.p_name, p.p_url FROM activity a, products p WHERE a.a_uid= ".$uid_int." AND a.a_pid > 0 AND p.p_pid = a.a_pid GROUP BY a.a_pid ORDER BY a.a_time DESC LIMIT 6 "); In general it should produce a unique list ...
Hello, I am using LAMP on localhost. I can login which uses mysql db, get to the main page (data driven), but when i enter this particular page, its fine, but when i refresh the error is "No Database Selected" then one every page says so. I restarted the Apache, MySQL server Browsers FF,IE, Chrome all show the same errors, cleared ca...
Hi, I'll rewrite a different question of mine, because the problem case somewhat changed: If I want to get mails from my mailserver (different machine) into my Rails App to process it there, what is faster: Connecting via net/Pop or net/imap to download the mails Storing the Mails on the Mailserver in a MySQL Database (using somethin...
What, if any, is the performance overhead of using XML as the interface between a Php application (A) and a MySQL database via another Php application (B), rather than direct querying from Php application (A) to the database? How much will this change between application (A) and the database being on the same server, and being on separa...
I'm trying to create a simple database table using the PHP MySQL Querry "Create Table", but it's not working. What is wrong with the below code? // Make a MySQL Connection mysql_connect("localhost","the_database_name","the_database_password") or die(mysql_error()); mysql_select_db("the_database_name") or die(mysql_error()); // Create...
Hi, We can synchronize the data from SQL mobile with SQL Server. But i need to synchronize the mobile data with mysql server. Is there any way to accomplish my requirement...? ...
Is there another way to do this Query ? $query = "SELECT * FROM produto, pt WHERE produto.refPT = pt.ref AND produto.refPT IN (SELECT idProduto FROM amb_prod WHERE idAmbiente='1');"; $result_set = mysql_query($query); The problem is my localhost have the MySQL version 5.1.30-community, but my Online server have the 5.0....
Hi, I have a bean which I map to the database using Hibernate. I'm using Hibernate Annotations to indicate the mapping I want, and to create the indices. The thoroughly simplified code is shown below. The problem I have is that the indices on my byte[] field are not created; specifically that my multi-field index sysUuid does not get c...
hello, i have aweird problem that has only just started happening. i have a small cluster (one web and one db) setup and i host a rather popular group of4 -5 sites that allow users to dynamicly create their own mobile chat communitys automaticly. each site gets its own mysql db createdand populated automaticly. this is all fine, but ...
Hello, I have an ongoing difficulty grasping the technical implementation details of connection pooling. I have read quite a few of related articles such as this one and this one, but still not 100% clear. Is connection pooling tied to tomcat, mysql, or the other development frameworks (struts2, spring, hibernate)? I mean do each of thes...
Hi: I have a large table and would like to at least find the most repeated works so I can have a trends keyword list. The database is mysql and I am running php5. Is there any other way besides exploding the data and searching for repetitions on the php side? What about having combinations of 2/3 words keyword trends? Any thoughts? ...
I have a ubuntu server which I've locked down to only HTTP, HTTPS and SSH (port 30000). On this box I have a MySQL server which 99.9% of the time is only used locally. Every now and then I want to connect to the MySQL instance with the GUI tools, but without touching the firewall. Therefore, it is possible to set things up so that I c...
In response to another question here on stackoverflow (How do you select every n-th row from mysql), someone supplied this answer: SELECT * FROM ( SELECT @row := @row +1 AS rownum, [column name] FROM ( SELECT @row :=0) r, [table name] ) ranked WHERE rownum % [n] = 1 Could someone provide or point me to more information about the synta...
I need to document a legacy database schema for a new employee and as there's no design document I'd like to generate one from the existing schema. As the tables are MyISAM the foregin key relationships won't produce a nice graph. I'm interested in producing a document showing the important tables, their columns, types and remarks. Are ...
In MySQL, you can use the keyword USING in a join when you join on columns from different tables with the same name. For example, these queries yield the same result: SELECT * FROM user INNER JOIN perm USING (uid) SELECT * FROM user INNER JOIN perm ON user.uid = perm.uid Is there an equivalent shortcut in SQL Server? ...
I'm confused how to import a SQL dump file. I can't seem to import the database without creating the database first in MySQL. This is the error displayed when database_name has not yet been created: username = username of someone with access to the database on the original server. database_name = name of database from the original ser...
Hi! I want to make a simple news system using PHP and MySQL, right now I got a working post and read system but there is only one problem, I want it to show the 10 latest news but instead it shows the 10 oldest news. My question is: Is there a way to make MySQL return the results from the bottom of a table or do I have to first get the ...
I am having a very strange issue with Joomla. When I link to or directly pull up record # 571, what gets displayed is NOT what is in the database. In fact what is being displayed is not in the database at all. I have searched on all fields for any likeness to the contents of this article (which was created in the past) but I can not f...