I have MySQL on shared hosting. Is there any way how to change value of ft_min_word_len without administrator access? I found one workaround, where every word, that has less than 4 characters is supplemented with _ or some other char, and the same is done with every searched keyword that is less than 4 characters. Is there any bett...
Hi, That´s a general question. I need do retrieve the value of about 20 strings of about 100 characters each. Which of the following methods would be the quickest, in order to retrieve the variables? 1) reading from a separate include file, where the variables values are assigned (e.g. $var1 = "blablablah...."; etc) 2) reading from a t...
I have created an app in xcode with sqlite3.I want to create a button named sync to sync with my mysql database in my server. Any suggestion about sync process? Please let me know. ...
Hi All, I want to know whether is it a good idea to catch exception based on unique index of sql in java. i want to catch an exception like 'duplicate entry for 1-0' if so then handle exception otherwise insert properly in database table? ...
Hi, I am using CakePhp and MYsql for my application I am having three tables Forms(id,name,created,modified) Attributes(id,form_id,label,type,sequenceno) Results(id,form_id,attribute_id,label,value,submitted_by) The application i am developing is like form Builder. Generating the fields based on the type (eg .. If type="text"...
I'm getting the following error: Column count doesn't match value count at row 1 from this query: $movetohistory = mysql_query("INSERT INTO $storehistory SELECT * FROM $storetbl WHERE $time - datecreated >= 432000") or die ("Query failed: " . mysql_error() . " Actual query: " . $query); I've echo'd out $storehistory, $storetbl, $time ...
I'm developing an application which relies heavily on jQuery for user interaction. (and if you're browser doesn't support jQuery, then upgrade or don't use my application :) As normal, one have functions to GET, SET and DELETE data from a table. In my application, I'm GET'ing and SET'ing a lot of information without page reload. To do ...
I have an Excel sheet with some cols and i want to import those into the mysql table. The Problem is that there are more colums in the mysql table than in the sheet (which is absolutely fine). What would be the easiest way of getting the data in the right fields? My solution would be export to csv and put it in mysql via php, but there...
I have two columns in the table hours at sea - Would be good to be able to store hours and mins so you could say at sea for 1hr and 20mins and to be able to add up all the hours and minutes easily. team - this stores IDs from the team table, so you may have ids 1,3,10,23,45,34. Number in team changes often. So which types would you us...
Hey , i got this challenge , i got a MySQL DB table 1 with queries or text and table 2 with synonyms and misspellings as CSV [comma separated values]. Now i want to test if any query word in table 1 matches a synonym or misspelling in table 2 , then i would select them separately . example : table 1 row: "i am sick of HIV AIDS , what...
Hey , i got this MySQL Query : select query from HR_Health_Logs where query REGEXP 'masturbation|masturbate|masturbated|wank|wanking|wanked|masturbat|mansturbation|marstabation|marturbation|mastabation|mastarbation|master basion|masterbate|masterbation|masterbeting|masturation|masturbatin|masturbating|masturbatn|masturbtion|mensturbati...
Incorrect key file for table 'widgets'; try to repair it This is the error message MySQL gives me when attempting to apply a new index to an existing (very large) table. Of course when I follow the error message's suggestion of trying to repair it: mysql> repair table widgets; +-------------------+--------+----------+----------------...
I'm trying to parse the MySQL docs. They could be clearer. What they seem to be saying is that there are five possibilities: SET NULL, NO ACTION, RESTRICT, CASCADE, and SET DEFAULT. NO ACTION and RESTRICT do the same thing (prevent any DB change that breaks an FK) and that thing is the default so if you omit an ON DELETE clause you're s...
I'm using the above mentioned Python lib to connect to a MySQL server. So far I've worked locally and all worked fine, until i realized I'll have to use my program in a network where all access goes through a proxy. Does anyone now how I can set the connections managed by that lib to use a proxy? Alternatively: do you know of another Py...
Can someone suggest that out of the two mentioned (odd?) combinations, which is less odd, or in other words, is less trouble to work with + maintain. If it helps, the system is going to have two front-ends - one web application and one desktop application. The desktop application is going to be coded using VB.NET, and the web applicatio...
So I am trying to Sync a bunch of Videos I've retrieved from a particular user from Youtube to a database table of Video Ids. This is because YouTube does not allow the adding of meta information to a video. Hence I've created a video table on my server and would like to sync up videoids. i.e. php/mysql app <-> youtube The datastructu...
What is the code to show how long it took for PHP to process a page? Also, how many sql queries were performed to generate that page? ...
Okay. I've built here a mysql query browser, like navicat. Using MySQLdb to perform queries. Here's the weird part. When i run the query through the program(using MySQLdb), it gives me success, affected rows = 1, but when i look at it in phpmyadmin, the value hasn't changed. so before i perform the query, i print it out, copy and past...
I have a SQL Server query that I need to convert to MySQL. I've never used SQL Server/T-SQL before, so I have no experience with FOR XML PATH. There's surprisingly little documentation on this sort of thing. If I remove the FOR XML PATH statement, MySQL returns the error "Operand should contain at least 1 column(s)." It seems like the n...
According to the MySQL documentation on database replication, "All tables replicated using row-based replication must have explicit primary keys." Is it safe to assume that database replication will work with a composite keys? ...