Hey all,
I have a forum that I use AEF Forums for. I backup up the database so that I can install fresh (server and board). I got everything up again and installed the board. I'm now trying...
I've a table using the utf8_general_ci collation and I'm building a search tool for text fields within the table, with each field representing a different language.
The problem I'm having i...
Hello Lets say I have a table that has info such as
contractnumber
-------------------
12345
23456XXX
Lets say I want to select the last three characters if there is an XXX, but if th...
With the nested query below, I get the following error:
"You can't specify target table 'tablename' for update in FROM clause"
Any ideas?
MySQL server accessed from PHP 5
Hello all,
In my situation, I've got huge volume of messages coming to ActiveMQ, probably up to a hundred messages per minute. I've got a JAVA client app waiting to receive message and writ...
hi
i have a log table where it just logs simple things like, time in out etc. what i would like to do is display the user name as opposed to a number when i browse log file entries. for examp...
Hello experts,
I have to populate an advertisement column in my site. I'm using full text with match-against to search for tags.
That works fine, but if I get less than 2 rows I want to sea...
Curious about dong math in a query.
Simple question, is this correct? if not, how would I change it?
INSERT INTO categories (name, sort_order) VALUES ("new name", (SELECT COUNT(id) FROM ...
Dear Experts,
Is this MySQL selection valid?
With this query, I want to only select rows with CatStatusID 1. But this query will select rows with any CatStatusID. If I remove one of the ...
I have 2 devices that I would like to calculate the amount of time that they are both running at the same time for x period of time. The data looks like this.
So if the the first value is ...
I have successfully installed MySQL and I am trying to connect it to Open Office Calc. From some instrunctions I got I need to install the MySQL JDBC.
I have downloaded the files from
h...
I am loading a text file into a MySQL database that has Table CharSet as utf8. See Code below for sample.
However, during the load, I get several lines similar to:
Incorrect string value:...
Hello,
After googling and reading some solutions here, I still have some doubts about what is the best way to "implement" a sequence in Mysql.
I have a database where, of course, there a...
Hi, i have server with high spec :
two quad xeon with 16Gb RAM and 2x500Mb Harddisk.
i insatll centos 5.3 64 bit with mysql 5.045 64bit.
on normal time i have no problem with my serve...
Hi Experts,
For background information and code snippets, please refer to my previous post:
http://www.experts-exchange.com/Database/MySQL/Q_24885871.html
How do i set a condition in m...
Hello,
when I start MySQL Server Instance Configuration Wizard it crashed.
There are four steps
Prepare Configuration
Write configuration file
start service
apply security settings
...
I have two tables, one with about 5000 records, the second with about 3000 records. MySql is the database server for a Cold Fusion server based web site. I have a search form where the user ...
Greetings,
I know this seems like a simple question but I am not sure of the syntax required to perform the following SELECT:
"Select * from Table where ItemID BETWEEN ( max(ItemID) - 1...
wampserver icon stays at yellow
need database information...
is it stored in a file
Hi
The thing is that i have 4 table (originally i have 50+ table linked to the parent table)..
1. Parent
2. Child
3. Child
4. Child
the 2, 3, 4 are linked the the 1 with On update ca...
i am trying to delete the values from multiple tables which have one key common in them:
i am trying to make it simple so as if mysql database cannot be used, it can also work with access a...
Dear Sir:
Iam having linux mail server with the zimbra , which uses mysql for the mail store. i want to access the mysql database for this if i try from the root login like
#mysql -u root ...
hello experts,
i want to upgrade mysql 5.0 to 5.1....can any body give the steps..??
i am using linux-fedora operating system and i have downloaded mysql 5.1 version(mysql-5.1.39-linux-i...
I need to select from some tables and download to a csv. The download works great, problem is there are a few fields where people are putting commans. How can I replace the comma in the fi...
Hi,
What Gui interfaces are recommended with mysql. I need to be able to add data and modify tables easily without writing queries etc....(I am using windows)
