If i use full text search in mysql using a keyword that can be found in more than 50% of the records, MySQL will an empty result. How can i avoid this behavior but preserve the relevance coeff...
I have a table with column C1 that has a paragraph symbol at the end of the data (guess it is a CR or LF or CR/LF).
1) How do I strip these characters out of the data?
2) How do I search thi...
I have a form that submits records to a table and also records which user posted the record. How do I select only the records submitted by a logged in user and print them in a table?
My co...
I have error complaining about undeclared variable balance_unapprove on 1 single string to get 2 variables.
If i split the it to 2 separate string, then there is no problem.
I think that...
I try to dump mysql db but I get this msg :
mysqldump ibtesama_montada > ibtesama_montada.sql
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'sigpic'': Can't create/write to file '/tmp/...
I'm using MySql Administrator 1.2.17, managing two separate, identical TikiWiki DB's on one GoDaddy site. I have used this set up for backup and restore (to and from my local machine) in the ...
I went into my PHPAdmin and deleted one of my databases that I thought was not being used by anything. I am left with another database almost that has almost the same number aer0918806465149 ...
Can you please tell me how to change the name of my database in mysql 5 using phpAdmin
I have been reading that mysql 5 use different method for database name ? I am not sure and I am not ...
Hi experts -
When I run this: select cast ('461129' as datetime)
i get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000
Can you please let me know why and what I need to do ...
I am about to start developing a property website. My client will be uploading new properties via a php form which will send to a MySql database. These properties also need to appear on a numb...
Hi,
I have a future date (in my database) and i want to get the days and hours from current datetime to this future date.
how do i do that? Is there a function that i can used in mysql?
...
is there any way to connect two server's hdds as one on one server with raid or is there any alternative method
I am working with an insurance company that processes insurance claims from providers. I was told that in addition to a standard html form, they want the functionality to send multiple claims ...
i have info that i stored in mysql database
now i want to get the info from database
i only want to get the info of last 2 days.
i have a table call studentPerformance
in studentPer...
Hi,
i have been asking this question before, so please anybody send me solution.
I am developing a online lottery website, in this website user can play and will get result in every two m...
I have a mysql database that I use with my website. I normally connect to it using a php script running on the site which contains the code "mysql_connect(server,user,pwd)" where server equals...
I have a centos server running MySQL that I just built and I have years worth of DBF files I want to insert into it. They are just flat DBF files and I have added a few on my own so I know th...
Hi,
Im looking for a mysql tool which has datagrid view
to which I can copy paste data from excel worksheet.
I have to edit huge number of records & I wish I could copy paste
the d...
I have setup freeRadius on a SUSE server and I also have Mysql running.
It has been alot of effort to get to this stage, I have finally got dialup admin working for freeRadius, and when i g...
Dear Gurus,
I am trying to load text files which are delimited by spaces, the number of which are not fixed.
So using FIELDS TERMINATED BY ' ' will not work. I tried using some regular e...
Here's an odd question.. I have some code that was written for me that lists a manufacture name from a table , but it's doing it in order of manufacturer_id instead of manufacturer_name, this ...
MySQL uses backslash as the default escape character.
I have a tab delimited text file. Some of the fields contain a backslash as the last character of the field.
mysqlimport escapes th...
Hi
I do a little bit with databases but I'm a beginner really and I need help with a query please.
My database stores information for a gps tracking system. A Journey can have multiple GPS...
