| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Not quite sure what is going on here..
I have a test database running on 5.2.6-1 and production is on 5.2.0-8
A select that works on production...
The Natural Philosopher
|
03-04-2010 02:49 PM
The Natural Philosopher  | 20 | 165 |
 | | Hi,
I have a db in which I have a users table containing a list of all
the users and a groups table containing a list of all the different
security...
Graham Drabble
|
03-04-2010 02:32 PM
Erick T. Barkhuis | 1 | 79 |
| | | Hello,
I'm not sure if the query i'm trying to do is possible. I've done half
the work but i'm stuck on the last part. Let me exlain.
I have 3...
SM
|
03-04-2010 11:48 AM
SM | 5 | 82 |
| | | Hello,
I work with MySQL 5.1.44 on Mac OS X Snow Leopard Platform. I can do all
the commands and scripts by command line, but I don't find...
Forum
|
03-03-2010 07:24 PM
Banana | 1 | 182 |
| | | Disclaimer: my MySQL skills are pretty rusty. On top of that, I'm
working with a poorly planned schema I had nothing to do with. Go easy
on me...
Adam
|
03-03-2010 06:37 PM
Gordon Burditt | 4 | 163 |
| | | I'm using the code shown below in a VB6 program to update a record in
a MySQL database. When it gets to the line where it's assigning a
value to the...
Martin
|
03-03-2010 10:26 AM
Martin | 2 | 77 |
| | | Hello,
I have little experience in PHP5+MySQL. I created a website with
database of 23 tables. Some of these tables contain data that are
important...
Jivanmukta
|
03-03-2010 04:41 AM
strawberry | 7 | 167 |
| | | The Yellowfin BI team have produced a new paper on "Location
Intelligence", the mashup of BI with GIS
Extract
More than 70% of your organizational...
JTP PR
|
03-03-2010 04:02 AM
JTP PR | 0 | 59 |
| | | Hello,
Does any one know a way to catch an error n° from a query to be stored
in a table.
I have a procedure wich calls others procedures.
At the...
jero
|
03-03-2010 02:40 AM
jero | 2 | 69 |
| | | Mau C wrote:
So it's based on MySQL. It's still SPAM. And not at all on topic.
--
==================
Remove the "x" from my email address
Jerry...
Jerry Stuckle
|
03-02-2010 09:42 AM
Mau C | 2 | 52 |
| | | Dear All,
I am trying to implement Twitter style followee feed subscriptions for
my users.
For example, If I want to select the most recent 25...
Moodang
|
03-02-2010 06:36 AM
Doug Miller | 1 | 49 |
| | | We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on the...
Mia
|
03-01-2010 07:37 AM
Mia | 0 | 176 |
| | | Hopefully I can explain this in a way people will understand.
I have been playing with INET_NTOA() and INET_ATON() just to fullfill my
own...
kgray
|
03-01-2010 06:01 AM
Tony Mountifield | 2 | 171 |
| | | Hi,
I'm using Access as a front-end of Mysql-server via odbc connector.
I've already made tables on Mysql and now i doubt if relations between
them...
remigio
|
03-01-2010 01:02 AM
remigio | 22 | 328 |
| | | Hi,
I'm using the latest version of MySQL on WinXP. As root, I created a
database and a user, and I confirmed I was able to login and create a
temp...
laredotornado
|
02-28-2010 12:34 PM
Luuk | 2 | 61 |
| | | Do you know that you can find solar cells for less than 1 USD per Watt
on www.ebay.com ?
Regards.
..
|
02-28-2010 04:17 AM
.. | 0 | 80 |
| | | Hello.
I have succeeded to create mysql database.
I did the following code :
Try
ConnStr...
Mr. X.
|
02-26-2010 07:32 PM
Jerry Stuckle | 1 | 193 |
| | | Hello.
I am first using mySql on Windows-7.
Should I set the path on the environment ?
(so I can run by cmd.exe the mysqladmin, etc. of...
Mr. X.
|
02-26-2010 07:27 PM
Jerry Stuckle | 3 | 64 |
| | | Hello.
my database instance is myInstance.
I have created the instance OK.
When do on menu : database + query database I see a tree of :
1....
Mr. X.
|
02-26-2010 05:00 PM
Jerry Stuckle | 1 | 142 |
| | | Hello.
I am first using Mysql.
I have installed the mysql server 5.1 and MySql WorkBench 5.2 OSS.
I want to create a new database instance via the...
Mr. X.
|
02-26-2010 04:29 PM
J.O. Aho | 1 | 68 |
| | | I have a php script that inserts some purchase order items into a
mysql database. None of the fields are defined as primary or unique
and shouldn't...
Chad B
|
02-26-2010 04:07 PM
Chad B | 2 | 188 |
| | | I am trying to use it with linux Mint. I run mysqld as root and I see a
process running. Now what. I've tried the MySQL Administrator GUI and
I...
A Watcher
|
02-25-2010 12:04 PM
A Watcher | 17 | 227 |
| | | I have a query where I have a complex date expression as one of the
columns.
SELECT
date_column + INTERVAL( complex_jimmy_jam ) DAY...
steve lefevre
|
02-25-2010 11:15 AM
steve lefevre | 2 | 59 |
| | | In some of my larger procs, I have a handler to rollback any
transaction and set an out parameter:
DECLARE EXIT HANDLER FOR...
Mark Smith
|
02-25-2010 06:05 AM
Mark Smith | 23 | 281 |
| | | Assume I have a list of words like that of a dictionary. What is the best
method of storing them ?
If I define a field of length 64, I think for...
sl@my-rialto
|
02-23-2010 09:03 PM
sl@my-rialto | 2 | 85 |
| | | Hi all,
I am copying tables from one db to another with something like:
$mysqldumpcmd -u $reuse_username $pass -h $reuse_host...
avilella
|
02-23-2010 07:26 AM
avilella | 2 | 50 |
| | | I'd like to have a timestamp field that retains the original insert
time. Ie, if the field is updated, the timestamp will not update.
I thought that...
jeff
|
02-22-2010 04:02 PM
jeff | 3 | 84 |
| | | Hi,
I am reading 'PHP and MySQL Web Development' (3rd Edition) and
have been looking at the Web Bookmarks example in chapter 26.
Basically this...
Paul
|
02-22-2010 02:00 PM
Paul | 12 | 241 |
| | | Just curious.
Does google use MySQL for its index database ?
Thanks.
sl@my-rialto
|
02-22-2010 12:43 PM
D Finnigan | 5 | 83 |
| | | Hi all:
I use MySQL under Windows XP. It says here:
http://dev.mysql.com/downloads/mysql/5.1.html
that "The Windows “msi-essential-*” installers...
José Carlos Santos
|
02-21-2010 07:09 AM
Erick T. Barkhuis | 6 | 183 |
| | | I don't know if i'm doing ok posting here, maybe this goes in a GIS
group, sorry if this is not the correct place.
I'm working with mysql GIS...
JPerelli
|
02-20-2010 12:15 PM
JPerelli | 9 | 305 |
| | | Hi,
I'm using MySQL 5.0.77. It's late and I can't figure out what I'm
doing wrong. I'm trying to rename a column like so ...
mysql> ALTER TABLE...
laredotornado
|
02-20-2010 02:32 AM
Lennart | 1 | 50 |
| | | I have a table that contains a field for CD tracks. Some Cd Tracks
start with special characters like Á, ! etc... I would like to sort
these in a...
SM
|
02-19-2010 03:32 PM
Jürgen Exner | 6 | 61 |
| | | Hi, I have a bit of a problem,
running a FULLTEXT query on a particular slave doesn't return any record,
doing the same exact query via shell on that...
majale
|
02-19-2010 09:29 AM
majale | 6 | 75 |
| | | Hello
Lets I have a table "events" containing:
event_name
date
and i put into the table this:
insert into events values('party 1',...
wonderpix
|
02-18-2010 11:20 AM
Erick T. Barkhuis | 7 | 102 |
| | | hello,
assume directory:
Main/Images/
directory has members:
image1.jpg
..
..
..
jason
|
02-16-2010 12:46 PM
Jerry Stuckle | 5 | 69 |
| | | This works:
SELECT
m.CompanyName Name, (SELECT COUNT(*) FROM Cars c WHERE
c.CompanyID = m.ID) CarCount
FROM Manufacturer m;
But when I try to...
Mark Smith
|
02-16-2010 07:02 AM
Erick T. Barkhuis | 2 | 64 |
| | | The table ('episodes') has a primary index episodeNumber and a field
for endDate (and other fields).
I want to list the episodes by episodeNumber,...
bill
|
02-15-2010 06:28 AM
bill | 4 | 316 |
| | | "Caveat: Quantity is not necessarily a measure of Quality"
Newsgroup.................: comp.databases.mysql
Stats Were Taken..........: Mon, 15 Feb...
me
|
02-15-2010 03:10 AM
me | 0 | 60 |
| | | Gurus,
Running MySQL v 5. The server it is running was recently ungracefully
powered off. The server came back ok but I wanted to ensure the...
Spin
|
02-14-2010 02:02 AM
Balwinder S Dheeman | 5 | 187 |
| | | Hello There,
In mysql (or sql in general), what is the best technique to add
records to two tables, and retain correct primary/foreign...
elias
|
02-13-2010 08:27 PM
Doug Miller | 2 | 69 |
| | | I have this function (which I did not write, but added the 'die' to help
diagnose the problem):
function procAdd($tableName, $fields,...
Derek Turner
|
02-12-2010 04:19 AM
Derek Turner | 12 | 278 |
| | | Getting a strange username error from this:
#This connect is working fine
my $dbh = DBI->connect($dsn, $username, $password, \%connection_opts)
my...
monkeys paw
|
02-11-2010 07:56 PM
Peter H. Coffin | 1 | 232 |
| | | Hello, I'm having a problem getting a query to work, which I think
should work. It's in the form
SELECT DISTINCT a, b, c FROM t1 WHERE NOT IN (...
steve lefevre
|
02-11-2010 01:53 PM
steve lefevre | 3 | 72 |
| | | I can't see any info on the mysql websites about the best version to
use for win-ME/98
Could someone advise me on the best release for those...
sandy
|
02-11-2010 04:49 AM
The Natural Philosopher | 13 | 152 |
| | | If I want to run two servers each with their own copy of mysql server
and a dedicated host computer and hard drives.
I'd like to be able to keep...
SpreadTooThin
|
02-11-2010 04:47 AM
The Natural Philosopher | 3 | 213 |
| | | In one of my projects I needed to reformat a database table. Rather
than ALTER the table I dumped the data from the table to a csv file.
Then,...
bobmct
|
02-10-2010 03:35 PM
Beauregard T. Shagnasty | 1 | 70 |
| | | I have a database where there is a table of events and a table of members
in a many-to-many relationship. the event able has a child table in...
Derek Turner
|
02-10-2010 01:20 PM
Erick T. Barkhuis | 7 | 207 |
| | | I'm not sure how to do a query. I've tried a couple of things with no
success. I believe i need to use the count(*) function and the 'group
by'...
SM
|
02-09-2010 09:06 AM
Captain Paralytic | 5 | 160 |
| | | Hi everyone...
I am running this query which grabs activity per day for 10 days
SELECT DATE_FORMAT( created, "%c/%d/%Y" ) AS `day` , COUNT( id )...
John R
|
02-09-2010 03:44 AM
Derek Turner | 5 | 202 |
