OK, I have a complicated query from a poorly designed DB... In one query I need to get a count from one database, information from another with a link from another, here goes: Each blog has a type (news, report etc) and a section Id for a certain part of the site but it also can be linked to multiple computer games and sections) type (...
Is it posible too run the Management node of the mysql-cluster on a different OS ( linux ) and 2-3 cluster servers on windows hosts? ...
is it possible to insert data into mysql in a hidden format?? I did not want to insert in encrpted format?? becoz encryption and decription takes much time.. So i want to insert data into tables which is not seen by others... But Data should be raed via query.... ...
i have this "SELECT SUM( state ) FROM `vote` WHERE id ='5'" now when add it in php how i can do $xx= mysql_fetch_array(mysql_query("SELECT SUM( state ) FROM `vote` WHERE id ='5'")); is i can do it like that echo $xx['SUM( state )']; ...
Hello! I have created a table in DB with name "member" having field "name", "college", "email", "zid" now I have created a class(in php) like class member { private $name,$college,$email,$zid; private function adduser { //function definition } public function autherise($id) { //function definition } } now at index page...
Given an input string, I'd like to return the rows from a (MySQL) database that contain a wildcard expression that would match the string. For example, if I have a table containing these wildcard expressions: foo.* foo.bar.* erg.foo.* and my input string is "foo.bar.baz", then I should get the rows "foo.*" and "foo.bar.*". Any ideas ...
Hi, We are using Load data local infile command very frequently. when run on mysql prompt it throws following summary output Query OK, 676446 rows affected (25.61 sec) Records: 676446 Deleted: 0 Skipped: 0 Warnings: 0 I have started executing that mysql load data query from java But from java code, i do not know how to capture followi...
I'm trying to install MySql interface for python,but I got an error(mentioned below).And I know the solution,install the Microsoft Visual C++.So what my question is there any alternative solution apart from installing Microsoft Visual C++,I mean it's really hurt me,why should I install Microsoft Visual C++ just because to build this sing...
I'm debugging an old application in Delphi 5, connected with a recent version of MySql via ODBC connector. When using a CAST conversion function, even the following query: select cast(1 as char) returns an empty column without column name. If I run the query directly into the mysql query analyzer it runs fine, so I suppose the proble...
Hello all, I have a table like below: MyTable -------- A B C A,B,C are columns and MyTable is the table name and i want run a mysql query like: SELECT MT1.A, MT2.A, MT2.B FROM MyTable MT1, MyTable MT2 WHERE MT1.B<>MT2.B and MT2.B like "MT1.B%" and MT2.status=0; As you see from the query above i have a table and i wa...
I'm trying to get the new rating from an UPDATE statement in java int userID = 99; String sql = "UPDATE table SET rating=rating+1 WHERE user_REF="+userID; statement.executeUpdate(sql); I can just do another SELECT statement, but isn't there a better way to retrieve the value or row while updating? ...
Hi everybody, i am trying to use a container managed datasource (via context.xml) in tomcat. The corresponding jar file needs to go in $catalina_home/lib, otherwise tomcat can't find it. (not in webapp/WEB-INF/lib, because it is managed by the webserver, not by the application itself) the problem is: I am using maven with the maven-to...
I am developing some Python modules that use a mysql database to insert some data and produce various types of report. I'm doing test driven development and so far I run: some CREATE / UPDATE / DELETE tests against a temporary database that is thrown away at the end of each test case, and some report generation tests doing exclusively...
Hi I m selecting data from two different tables with no matching columns using this sql query select * from (SELECT s.shout_id, s.user_id, s.time FROM shouts s union all select v.post_id, v.sender_user_id, v.time from void_post v) as derived_table order by time desc; Now is there any other way or with this sql statement ...
I'm trying to have an html form which updates mysql data. Now , I have this code(which is also a form action) and I'm trying to also use this as a form for my update. Because I will need the data that this form would show, so that it will be easier for the users to update only what they wish to update. this is the form that will try to...
I'm using MySQL 4.1. Some tables have duplicates entries that go against the constraints. When I try to group rows, MySQL doesn't recognise the rows as being similar. Example: Table A has a column "Name" with the Unique proprety. The table contains one row with the name 'Hach?' and one row with the same name but a square at the end in...
Here where I work I am attending a series of lectures about database query optimizers. While the speaker was introducing databases, he made a very insightful comment about a kernel having basically to administer tables of processes, pointers to open files, inodes, etc, and it's therefore basically a POSIX-compliant database engine. Clear...
I was developing a small WAMP web application on my laptop, where I have an instance of mySQL running and I chose InnoDB for my DB engine. After several weeks' development I wanted to make it available to the public and found out the database server provided by my web host does not support InnoDB, only MyISAM. The create-and-populate sc...
I have a table with postcode districts such as SA1,SA3,SA11, LL41,NP20 and I need to do a search based upon a customer entering a postcode, and then matching the relevant record, i've tried : SELECT MATCH(postal_district) AGAINST ('SA1 1EG') FROM `postcodes` WHERE MATCH(postal_district) AGAINST ('SA1 1EG') > 0 but it returns nothing, ...
I expected either index to be used for my SELECT DISTINCT query below: CREATE TABLE test( value TEXT ); INSERT INTO test (value) VALUES ('a'); INSERT INTO test (value) VALUES ('b'); INSERT INTO test (value) VALUES ('c'); CREATE INDEX value_i ON test(value(32)); CREATE FULLTEXT INDEX value_i_ft ON test(value); SELECT DISTINCT value ...