Tagged Questions
-2
votes
0answers
13 views
Configuring the mysql server [closed]
I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
-1
votes
1answer
27 views
mysql select user who have not posted on site [closed]
I would like to select users who have not posted a job.
I have tried this:
SELECT
e.id, e.companyName, ee.emailAddress, ee.firstName, ee.surname
FROM
employer as e, country as country, ...
-1
votes
2answers
60 views
TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT in mysql maximum storage sizes ..? [closed]
There are 4 kinds of DATATYPES
TINYTEXT
TEXT
MEDIUMTEXT
LONGTEXT
In mysql 5 what is the Maximum length that I can store in a column of each data type assuming the character encoding is UTF-8.
1
vote
1answer
37 views
Query no longer works in MySQL 5
SELECT xp.productid, xp.product, xc.classid, xiW.date, xco.optionid, xco.option_name, xiW.id, xiW.image_path, xiW.path_on_server
FROM xcart_products xp
INNER JOIN xcart_variants xv ON ...
2
votes
2answers
53 views
COALESCE two dates returns binary?
Why does COALESCE(date1,date2) return Blob(binary)? Both columns are of type DATETIME.
Here's the complete sql query:
SELECT COALESCE( last_modified, date_purchased )As LastModifiedOrPurchased
FROM ...
0
votes
1answer
44 views
How to execute select queries, while not locking update queries
I have a table on which i get heavy select queries every few seconds. Due to this, my update queries get locked for a long time. Is there any way by which I can let my select queries execute, while ...
0
votes
2answers
25 views
Finding Duplicates Of Table data : Optimized Way?
I have a main table with 80lacs record (say TABLE : MAIN_TABLE)
I want to fire many queries in which i need to find all records matching approx 10 criteria that are register in 6 months(11 lacs)
I ...
0
votes
2answers
138 views
MySQL Levenshtein
I'm trying to create a MySQL function for calculating the levenshtein distance. I found a function which looked pretty close to what I need, however it keeps throwing errors everywhere - I am new to ...
0
votes
0answers
37 views
Changing special formatting to regular formatting in Flex
The application is a Flex front end, Coldfusion 9 middle tier and MySQL back end. I am using a RichTextEditor in the Flex front end text boxes
so that users have an option of formatting. However, ...
0
votes
1answer
38 views
full text indexing only returns 2 rows
I have a table for food and hotels
like
CREATE TABLE `food_master` (
`id` int(6) unsigned NOT NULL auto_increment,
`caption` varchar(255) default NULL,
`category` varchar(10) default NULL,
...
0
votes
2answers
69 views
MySQL unique key only where another key contains a specific value
I have a table which contains meta data for users. There are 4 fields...
`ID`,`meta_name`,`meta_value`,`user_id`
I want to store emails in this table. Naturally these must be unique. However I want ...
-2
votes
4answers
50 views
Determining which users uploaded an image? [closed]
I have a database of users that I have allowed to upload their images to their profiles. There is no indication in the database that each has uploaded an image to their profile and that is exactly ...
2
votes
1answer
123 views
What is wrong with my MySQL CASE/WHEN syntax?
I'm trying to learn the ropes of some new MySQL syntax and am having trouble. This should be simple...
I'm following along with the manual here:
http://dev.mysql.com/doc/refman/5.5/en/case.html
but ...
0
votes
2answers
38 views
logging into sql
I am a student learning sql and working an assignment to set up a database in mySQL 5.5 community version. The command I am given does not work as detailed. Here is what I have done so far:
This is ...
0
votes
1answer
147 views
Unable to run magento on a virtual machine
I'm setting up a VM to work on magento.
I set up correctly the webserver (apache2), PHP, mysql like I did on other server where I got magento working, but this time it doesn't want to run...
All I'm ...
