| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | Hi,
I have a table that includes the following fields, ID, start date,
start time, end date, end time and it includes a huge amount of
records (50...
Iain Adams
|
05-04-2011 09:37 AM
The Natural Philosopher | 1 | 2 |
|  | A Plus-IT Consulting contrata para inicio imediato:
ANALISTA DE SISTEMAS - MYSQL
Local: Valinhos/SP
Inicio: Imediato
Período:...
Plus-IT
|
05-03-2011 11:09 AM
Plus-IT | 0 | 1 |
|  | Hi Team,
We are facing one production issue after enabling replication.
Production Description:
We have one MySQL server with DRBD after enabling...
sudheer
|
05-02-2011 03:40 AM
Axel Schwenke | 1 | 2 |
|  | Jerry Stuckle wrote:
It is not a case of a "poor host" - it is a case of what that host was
designed for.
That's like saying a train is a poor...
Robert Crandal
|
05-01-2011 03:59 AM
Thomas 'PointedEars' Lahn | 101 | 102 |
|  | Hi,
I want to know if there is a certification for mysql or sql server ?
thnx
aziz mhend
|
04-29-2011 07:23 PM
onedbguru | 1 | 2 |
|  | Hi,
If I delete an MySQL database, it appears that users who have privileges
only for that database are still around. How can I remove them?
Thank...
Joe Hesse
|
04-29-2011 03:48 PM
Thomas 'PointedEars' Lahn | 4 | 5 |
|  | Hi,
I am pleased to announce the release of ODB 1.4.0.
ODB is an open-source object-relational mapping (ORM) system for C++. It
allows you to...
Boris Kolpackov
|
04-27-2011 09:35 AM
Boris Kolpackov | 0 | 1 |
|  | I am running a java class that queries mysql via JDBC, the database is
also servicing a GUI via tomcat (connection pool)
All of a sudden the java...
terry433iid@yahoo.com
|
04-27-2011 08:16 AM
Peter H. Coffin | 2 | 3 |
|  | Sex sells. And, although it may seem absurdly out of context, it
definitely sells Business Intelligence (BI) software.
Though somewhat ironic, many...
janpelletier@yahoo.ca
|
04-26-2011 07:45 AM
janpelletier@yahoo.ca | 0 | 1 |
|  | "Caveat: Quantity is not necessarily a measure of Quality"
Newsgroup.................: comp.databases.mysql
Stats Were Taken..........: Mon, 25 Apr...
me
|
04-25-2011 04:29 AM
me | 0 | 1 |
|  | I have Exported a database from a MySQL installation (creating the
DatabaseName-20808-1303309022.sql file).
On another computer (with a new...
Martin
|
04-25-2011 03:38 AM
Álvaro G. Vicario | 5 | 6 |
|  | Below is my my.cnf. In this configuration I had wanted to use mysql
and my web server on an outside IP but I discovered I can't because I
have a...
jrough
|
04-22-2011 09:19 AM
Peter H. Coffin | 3 | 4 |
|  | Hello
I've got a small home server, that hosts a few web pages on a few domains -
a couple of WP and a Drupal based - all of which is using...
Peter Jespersen
|
04-21-2011 08:02 AM
Peter Jespersen | 2 | 3 |
|  | Hi guys, I just upgraded our database to 5.5 so I could start using
partitions. I created a test table to make sure partitions were
working and sure...
David
|
04-20-2011 09:14 AM
Tony Mountifield | 4 | 5 |
|  | Hi,
I come from the Postgres world where one user has one password and
pg_hba.conf decides which hosts that user may connect from.
OK, it can get...
Tim Watts
|
04-19-2011 06:10 AM
Axel Schwenke | 7 | 8 |
|  | "Caveat: Quantity is not necessarily a measure of Quality"
Newsgroup.................: comp.databases.mysql
Stats Were Taken..........: Mon, 18 Apr...
me
|
04-18-2011 04:28 AM
me | 0 | 1 |
|  | hi friends,
i want column names which has the value 1 in row.....
the may have multiple column,, if more then 1 present then i want each
names,,,,...
mada suresh
|
04-14-2011 04:13 PM
Luuk | 10 | 11 |
|  | Look at this (mysql 5.1.30 solaris x86-64):
mysql> select unix_timestamp('1970-01-02 00:00:00')-
unix_timestamp('1970-01-01...
Udo Grabowski
|
04-14-2011 08:25 AM
Axel Schwenke | 4 | 5 |
|  | Hi,
I have an urgent problem:
A colleague changed the "root@localhost" in the user management into
"root@%"
Now we can't access anymore, neither...
Jens Riedel
|
04-11-2011 02:34 PM
Joe Hesse | 3 | 4 |
|  | "Caveat: Quantity is not necessarily a measure of Quality"
Newsgroup.................: comp.databases.mysql
Stats Were Taken..........: Mon, 11 Apr...
me
|
04-11-2011 04:21 AM
me | 0 | 1 |
|  | Specifically, what is the proper URL coding for this?
What exactly do I replace "localhost" with?
As there are three different ways to do this, with...
richard
|
04-09-2011 07:21 PM
Gordon Burditt | 9 | 10 |
|  | I got the message
(1292, "Incorrect datetime value: '2011-03-13 02:18:28' for column
'first_seen' at row 1")
This is because that hour doesn't...
John Nagle
|
04-09-2011 02:26 PM
John Nagle | 0 | 1 |
|  | How does one go about adding columns in the workbench?
richard
|
04-09-2011 12:53 PM
richard | 2 | 3 |
|  | Please help me how can I sum the result of 2 select queries:
SELECT
COUNT(DISTINCT Nodes.Caption) AS COUNT_of_NodeName
FROM
Nodes
contracer
|
04-09-2011 09:58 AM
onedbguru | 2 | 3 |
|  | hi friends ,,,
i want columns from three different
tables..here is my query..
select jp.js_id from js_profile jp join...
mada suresh
|
04-07-2011 10:22 PM
onedbguru | 3 | 4 |
|  | Using MyISam. Assuming a simple table structure of Events with another
table of Event_Bands with 0-many bands associated with each row in Events.
I...
Some One
|
04-07-2011 03:08 PM
Some One | 1 | 2 |
|  | I've a large file of many SQL statements (for the purpose of
populating). I've tried running this through mysql both (1) locally (but
using TCP) and...
Andrew Gideon
|
04-07-2011 11:57 AM
Axel Schwenke | 6 | 7 |
|  | International Business Intelligence (BI) software vendor, Yellowfin,
has partnered with data management experts, Ingres Corporation,
certifying...
janpelletier@yahoo.ca
|
04-06-2011 07:31 AM
janpelletier@yahoo.ca | 0 | 1 |
|  | Hello everybody,
I’m working on “the CCS RFID Development Kit” which used PIC C
compiler. And I trying to establish a connection between the...
shamma al eisaei
|
04-06-2011 04:49 AM
Thomas 'PointedEars' Lahn | 5 | 6 |
|  | I am migrating data from one database schema to another. The old
schema has a categorization system based on an adjacency list, with
id, category,...
Steven Lefevre
|
04-05-2011 11:28 PM
Steven Lefevre | 4 | 5 |
|  | I need to create a UPDATE query as a subquery of a SELECT one (after
the where keyword)
Something like:
SELECT x FROM u WHERE k=i AND y IN (UPDATE o...
Alfio Emanuele Fresta
|
04-04-2011 07:59 PM
Jerry Stuckle | 16 | 17 |
|  | "Caveat: Quantity is not necessarily a measure of Quality"
Newsgroup.................: comp.databases.mysql
Stats Were Taken..........: Mon, 04 Apr...
me
|
04-04-2011 04:26 AM
me | 0 | 1 |
|  | I've this select.
SELECT `Carrier`.`player_id`, `Carrier`.`team_id`,
`Carrier`.`created`
FROM `carriers` AS `Carrier`
ORDER BY ...
Mariano C.
|
04-02-2011 11:10 AM
Mariano C. | 2 | 3 |
|  | Saved to VarChar field in MySQL 5.1.31 doesn't work.
e.g. ?????????
Any clues as to how I can do this?
--
RobP
R C Nesbit
|
03-31-2011 05:39 PM
Thomas 'PointedEars' Lahn | 11 | 12 |
|  | Hi,
I have a table with a DATE field that can be NULL and the default is NULL.
The table definition is shown below with all the fields not shown...
Joe Hesse
|
03-31-2011 06:52 AM
Álvaro G. Vicario | 5 | 6 |
|  | Hello,
I want to delete a large amount of records (~200K) from a large table
(~500K records) in my MySql DB.
I want to make this call as efficient...
Ran Margaliot
|
03-30-2011 01:53 PM
John Nagle | 6 | 7 |
|  | An example of my dilemma:
I have a table of patient data.
The patient has a patient ID which is the primary key.
The table also has a foreign key...
SpreadTooThin
|
03-30-2011 05:37 AM
Álvaro G. Vicario | 5 | 6 |
|  | last week I installed and successfully set up mysql on mac.. (10.6.6)
was able to connect fine from unix shell and from PHP and JSP.. but
today,...
kali
|
03-30-2011 04:02 AM
Álvaro G. Vicario | 10 | 11 |
|  | Information management solutions provider and event partner, Zenith,
will present its groundbreaking data quality dashboard at the 2011
Data Quality...
janpelletier@yahoo.ca
|
03-28-2011 07:19 AM
janpelletier@yahoo.ca | 0 | 1 |
|  | "Caveat: Quantity is not necessarily a measure of Quality"
Newsgroup.................: comp.databases.mysql
Stats Were Taken..........: Mon, 28 Mar...
me
|
03-28-2011 04:29 AM
me | 0 | 1 |
|  | I've only recently began to read about partitions, and I'm not
entirely sure that I understand how it works. Here's where...
jwcarlton
|
03-27-2011 08:13 PM
onedbguru | 1 | 2 |
|  | Hello, I have already sent this question to the mysql dev forum, but
no one there unfortunately was not able to answer, I hope for your
help)
tell me...
PavelVD
|
03-25-2011 07:32 AM
Dieter Kluenter | 1 | 2 |
|  | I've been trying to find this, but I'm not sure that I'm using the
right terminology. Sorry if this is an FAQ.
I'm trying to SELECT something using...
jwcarlton
|
03-25-2011 04:59 AM
Axel Schwenke | 6 | 7 |
|  | I'm getting an error that I don't know how to fix. I'm using odbc to connect to a mysql database. When I bring the table up in Access and try to...
chadlupkes
|
03-24-2011 04:37 PM
chadlupkes | 3 | 4 |
|  | On Thu, 24 Mar 2011 09:54:02 -0700, Michael Vilain wrote:
Which is, when you think about it, entirely reasonable. Essentially,
you're really dealing...
PavelVD
|
03-24-2011 02:43 PM
Peter H. Coffin | 17 | 18 |
|  | Dr.X:
They may consider placing it in a DMZ, so the server will be accessible
without exposing anything else in the network.
--
Erick
Dr.X
|
03-23-2011 10:55 PM
Jerry Stuckle | 16 | 17 |
|  | On 3/22/2011 12:56 PM, Michael Vilain wrote:
Hello Michael.
Thanks for the reply.
I have not gotten MyPHPAdmin installed yet. Still learning the...
Dr.X
|
03-23-2011 06:44 PM
Dr.X | 5 | 6 |
|  | My Insert statement looks like
INSERT INTO tableName Column1Name, Column2Name VALUES ('c1', 'c2');
Shouldn't the UPDATE statement look very...
SpreadTooThin
|
03-23-2011 05:59 AM
Captain Paralytic | 8 | 9 |
|  | What I need to do is to convert a field to its equivalent in ASCII mode,
so that I can perform searches with accented characters (ISO8850-1).
Please...
Luis P. Mendes
|
03-23-2011 03:49 AM
Luis P. Mendes | 4 | 5 |
|  | Hello,
I am trying to get a list from one table, and using another table to
subtract from that list. I have tried all sorts of versions, but...
Joe
|
03-23-2011 03:30 AM
Álvaro G. Vicario | 2 | 3 |