I recently joined a team that was formerly a one man show to maintain and develop a company's PHP-mysql website. The current localization method is, for each section of the site, there exists a file ending in _en.php and _fr.php that contains long lists of same named variables with text in the appropriate language. At the top of each c...
Can anyone help me on how can I update one table having a selection to another table in WHERE clause.. My query is looks like this but it is an error.. UPDATE empinfo e SET e.tellno='32154' WHERE e.empno IN (SELECT ei.empno FROM empinfo ei WHERE ei.tellno <> '123456'); Your response is highly appreciated.. :) ...
Is there a way to load exact octal, hex or binary representations of IEEE 754 floats (as text) into a MySQL table using the correct single- or double-precision data type? E.g. the number pi written as 1078530011 or 40490fdb (single-precision). Preferably with LOAD DATA INFILE/mysqlimport, in the interests of speed... ...
Hi mysql_connect is not working but mysql_iconnect is working. Please help. Thanks ...
Hello, For the query below, I would like to set a variable called $totalcount equal to the count of all loginids in table called login. How can I do this? Thanks in advance, John $sqlStrcount = "SELECT loginid FROM login"; ...
I have three tables I'd like to join in a way that produces all records from one table and any matching records or NULL from another table. It is imperative that all records from the first table be returned. I thought I had done this before but I can't remember when or where and MySQL just isn't playing ball. SELECT VERSION(); 5.0.51a-3...
I have to query a database of thousands of entries and order this by the distance from a specified point. The issue is that each entry has a latitude and longitude and I would need to retrieve each entry to calculate its distance. With a large database, I don't want to retrieve each row, this may take some time. Is there any way to bui...
I'm trying to get some aggregate values from different tables, but my problem is that they're being returned incorrectly, i.e. as multiplications of each other. I've got these tables: Institutes ---------- ID name Conversions ----------- ID institute_id training_id Trainings --------- ID institute_id And I want to do get the Instit...
(if i searched for "phpmyadmin and excel", i get answers like "hot wo import excel-files"....) i searched for a phpmyadmin-alternative that works faster with ajax and i want to edit once fields directly like EXCEL! click n edit via ajax!! i dont like to click the row and say "now edit", then edit, and click "ok", return and new loading t...
Hello, I'm having some trouble with MySql right now. I have an query that works just fine, I'm using it for a while, but today I got stuck with this. The query is: select avg(valor), tipo_id, users_id, datetime from entries where users_id = '1' and tipo_id = 1 and date_format(datetime,"%Y-%m-%d") between "'2010-09-20" and "2010-10-20"...
What kind of data type should I choose in MySQL to store digit like this 50.078294547389426 ...
Hello! How can i export from MySQL to MS ACCESS 2007 in c#? Any tutorials? Regards, Alexandru Badescu ...
I'll write it, but if there's a ready, tested code snippet that does this I'll be happy to steal it. COUNT(*) SUM(cnt) 0 1 Edit - Thanks for the votes to close, I can always count on the good souls in Stack Overflow to be quick with the close votes. I'll add some details to the question. I am looking for a java code snippet that...
I've been having quite a bit of trouble getting an MVC2 web application to find the MySQL connector. I am running CentOS 5. I've installed the DLL into the GAC using the 2.0 version of the tool $ mono /usr/local/lib/mono/2.0/gacutil.exe -i v2/mysql.data.dll Installed v2/mysql.data.dll into the gac (/usr/local/lib/mono/gac) I verify t...
Hi There, I have a MySQL select statement dilemma that has thrown me off course a little. In a certain column I have a category term. This term could look something like 'category' or it could contain multiple CSV's like this: 'category, bank special'. I need to retrieve all rows containing the term 'bank special' in the comma separat...
I'm trying to show the boroughs and postcodes a particular town in is. My database is fairly well structured, with a table such as town, postcode and borough. There are also tables for each of the relationships town_postcode & town_borough. Ideally I want the data returned as: "Abbey Wood", "SE2", "Bexley, Greenwich" "Barbican", "EC1,...
Is there any reason to migrate from MySql to SQL server 2008 if one's main concern is the blocking of SQL injection attacks? Does Linq2Sql or EF provide additional protection? ...
I know I am pretty close with this, as I have recieved some help on this topic earlier, but when it cam to making the same code work for another part of the site it seems I cannot get it working again. What I am doing is trying to get the first part of a string (which is broken by a - delimiter in the database) so the db entry slug woul...
Hi, I have a simple database table with 170MB overhead. Is this something I need to worry about? When I run optimize on it, it tells me that innodb doesn't support optimize and so recreates the table but still has 170MB overhead. Is this something I can comfortably ignore? cheers! ...
Hai all, I have two tables a and b as follows to implement a simple block list where users can block other users..... Table A +------------+--------------+------+ | Name | phone |userid| +------------+--------------+------+ | Mr Sasi | 01225 708225 | 1 | | Miss Brown | 01225 899360 | 2 | | Mr Black | 0138...