dbTalk Databases Forums  

Sponsored Links


mailing.database.mysql mailing.database.mysql


Discuss in the mailing.database.mysql forum.



Post New Thread
Threads in Forum : mailing.database.mysql Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
How can I select , for a given name, that record with the highest id for something like: id INTEGER(11) PRIMARY KEY NOT NULL AUTO_INCREMENT name...
Ike
02-18-2006 04:48 PM
Michael Austin Go to last post
2 172
Hello, Mysql3 on an fc3 box. I do not have the root password for mysqld yet i need to copy a database let's call it database1 to database2. This is...
Dave
02-18-2006 12:35 PM
Bill Karwin Go to last post
2 161
There's probably a simple answer to this one, but... I've got a string that I've read in from a web browser, and I want to return a list of...
sgr
02-17-2006 06:02 PM
sgr Go to last post
2 137
If I have two String objects which are formatted date-times, say for example: '20060127 01:00:03' and '20060217 13:41:17' Is there a means by which...
Ike
02-17-2006 10:04 AM
Joe Makowiec Go to last post
5 99
Hi, I'm running MySQL (5.0.18-nt) on WinXP with latest patches. I've some SQL code that generates an 'ERROR 11' in two different places depending on...
m
02-17-2006 03:14 AM
m Go to last post
3 151
When I try to update record, I kept getting this error: Row cannot be located for updating. Some values may have been changed since it was last...
zMisc
02-16-2006 04:51 PM
zMisc Go to last post
9 201
I have a couple questions about MySQL involving which version of MySQL to use. I'm looking for minimal memory use on a Windows XP machine. Which...
Jim Carlock
02-16-2006 01:41 PM
Bill Karwin Go to last post
1 106
Hi, I have following problem: I use a form in excel to send data into mysql server, everything is ok unless I have to deal with decimals or data...
Piotr
02-16-2006 08:58 AM
Piotr Go to last post
6 108
Hey, Today is Thursday 16-Feb-06. The same thursday last year is 17-Feb-05. Because I am comparing daily sales between years, I need to know...
rjfjohnson@hotmail.com
02-16-2006 08:43 AM
Gordon Burditt Go to last post
5 110
Hello, I'm still using the older version of mysql 3.32 and I have a table, which stores information about people, like their birthdate as a date and...
fritz-bayer@web.de
02-15-2006 04:48 PM
Bill Karwin Go to last post
2 149
Hi Gang, Regarding the MysqlDataTruncation issue, I am having trouble over-riding it...
newsgroups@raincode.net
02-15-2006 03:31 PM
mark@thematthews.org Go to last post
2 302
So I pressed tab-enter and posted an incomplete topic, sorry. I have imported information into a database using a file. It is tab delimited and for...
subaruwrx88011@gmail.com
02-15-2006 01:49 PM
Thomas Bartkus Go to last post
4 126
Here are my results using MySQL 4.1.12 and I honestly don't think this is right, but can't figure out what to do: mysql> select id,...
phillip.s.powell@gmail.com
02-15-2006 10:53 AM
phillip.s.powell@gmail.com Go to last post
2 119
Hello, I am new to MySQL. I am trying to load from a text file to a table, and am having problems with the fields in the text file being translated...
spwpreston@gmail.com
02-13-2006 05:05 PM
Michael Austin Go to last post
4 116
I use DTS (Data Transformation Services) to transfer data between two SQL servers. I want to import data into MySQL from SQL. Does MySQL have...
Shank
02-13-2006 04:51 PM
Bill Karwin Go to last post
1 138
Hi, I'm using logparser 2.2 to extract data from IIS logs to a MySql database. The first part works fine - in fact I can connect to my Mysql server...
binderright@googlemail.com
02-13-2006 12:25 PM
Bill Karwin Go to last post
1 154
"UKuser" <spidercc21 (AT) yahoo (DOT) co.uk> wrote Doesn't PHP have a problem parsing nested quoted strings? That is, your array subscript...
Bill Karwin
02-11-2006 06:48 PM
Bill Karwin Go to last post
3 108
I have just installed MySql version 5.0-18 on Red Hat Fedora Core 4. It is running but I cant connect to it using MySql Query Browser running on my...
smatta@acm.org
02-10-2006 04:58 PM
smatta@acm.org Go to last post
5 128
I downloaded mysql, I did rpm -e to take out the 3.22 from my box ( mandrake 9.x) I put MySQL 5, because someone told me it supports at last...
Dimitris Mexis
02-10-2006 04:50 PM
m6s Go to last post
7 180
Hi guys I'm pretty new to mysql and was just wondering if you can update multiple fields at the same time i.e: UPDATE tablename SET field1 = value1...
Tony Wainwright
02-10-2006 11:12 AM
Gordon Burditt Go to last post
2 115
I have no idea where to look for this. Database about wines. One table is `product` (one particular wine from one particular estate) with a link to...
ventre--pattes
02-10-2006 12:12 AM
ventre--pattes Go to last post
5 137
I am relatively new to PHP and MySQL. This is the first time I've tried to use multiple queries in a single script. I have the following PHP script...
Bob Sanderson
02-09-2006 08:35 PM
Bob Sanderson Go to last post
8 137
SELECT s.id, s.first_name, s.last_name, IF(s.school_year_id = 0, s.school_year_other, y.school_year_alt_display) AS school_year_name FROM student...
phillip.s.powell@gmail.com
02-09-2006 05:20 PM
phillip.s.powell@gmail.com Go to last post
2 109
Insert row beteewn to old rows. I have a database and I need a certain order of the rows, and would like to insert a row between tod old rows. Can...
madsgormlarsen@gmail.com
02-09-2006 02:45 PM
Bill Karwin Go to last post
2 133
Hello, I am creating an a to z list - basically a count of all results that start with the letter "A", "B", "C" .... and so on. I am pretty poor at...
deja@chronofish.com
02-09-2006 01:21 PM
Jonathan Go to last post
2 118
I'm writing a web app that needs a login page. I'm doing the dev on a windows box although the final version will go on a Linux box. I can't find...
marc.wyburn@googlemail.com
02-09-2006 04:26 AM
marc.wyburn@googlemail.com Go to last post
2 134
I have several korn shell scripts I use with a MySQL database on the same server (Solaris). I am moving to a Linux environment where the MySQL...
mm
02-08-2006 09:24 PM
Bill Karwin Go to last post
1 132
I have some tables that is connected in a table like this: TracklistID CDid SongID it could look like this 1 1 1
EnjoyNews
02-08-2006 12:04 PM
Bill Karwin Go to last post
1 109
Hi, is it possible to create remote virtual tables in mysql? By that I mean if it is possible to define a table, which actually resides on a...
fritz-bayer@web.de
02-08-2006 01:23 AM
fritz-bayer@web.de Go to last post
3 114
I hope someone can help with this. If so then I'd really appreciate it. I have this sql statement: SELECT * FROM affiliates_referrals,...
Evil Bert
02-07-2006 01:29 PM
Bill Karwin Go to last post
2 117
Large table performance problem with MYSQL performance with ASP.NET I am doing some benchmarking of an application using MYSQL under Windows and I...
murray@jbmsystems.com
02-07-2006 01:16 PM
Bill Karwin Go to last post
1 106
Hi there. I was just wondering if mysql version 5.0.18 is a good stable release. We are currently using verion 4.1 and we are happy but as a...
gumpie
02-07-2006 12:59 PM
Bill Karwin Go to last post
1 165
I am trying to set up an ODBC DSN to our company MySQL database so that I can use a MS Access front end. I am using the MySQL ODBC 3.51 driver....
Bob Sanderson
02-07-2006 07:44 AM
Bob Sanderson Go to last post
4 117
hi everyone, I am trying to connect to a new mysql installation. I have given root permission to connect to all databases from anywhere; GRANT ALL...
pc
02-06-2006 09:43 PM
pc Go to last post
3 140
Hi, I installed mysql 5.0 on redhat 9.0 from source (tar). The whole procedure occured properly, i could do ./mysqld_safe. But when i want to start...
Ben
02-06-2006 08:59 PM
maui wuai Go to last post
2 112
Ok, you have three tables. You're supposed to be able to not only sort (ORDER BY) according to a_name, no problem, but you must also have...
phillip.s.powell@gmail.com
02-06-2006 08:49 PM
phillip.s.powell@gmail.com Go to last post
9 171
Hi, When I did on my last step to install mySQL 5, I pressed execute, up to start service, it said error 0 What should I do? I downloaded mySQL for...
Jacky Luk
02-06-2006 07:00 PM
Bill Karwin Go to last post
1 131
Is the problem with the query below in the SELECT?? Should I be using PHP to do some of things I am trying to get the SELECT to do? What is...
Pasquale
02-06-2006 06:45 PM
Pasquale Go to last post
4 169
Please note, I already posted this on the MySQL official forum, but received no response. I thought I'd try again in another location. My apologies...
Kevin D.
02-06-2006 05:00 PM
Kevin D. Go to last post
8 276
Each time I tried to save a record to MySQL (using ADO), I get this error "MySQL has gone away!" The service keeps stoping? Any...
zMisc
02-06-2006 11:21 AM
Bill Karwin Go to last post
1 120
I'm hoping someone can clarify the side-effects of setting the innodb_locks_unsafe_for_binlog parameter for me. I'm running a fairly standard web...
saran
02-05-2006 03:08 AM
Heikki Tuuri Go to last post
1 135
Hi Guys, Does anybody know where I can get a very basic view/add/edit script for a single table? I need to view all the rows at the same time and...
UKuser
02-04-2006 04:36 PM
UKuser Go to last post
3 124
I got a table with the following fields: BirthDay (Date) Reminder (Short integer) I need to select all records where BirthDay - Reminder <= Today...
zMisc
02-04-2006 03:20 PM
Bill Karwin Go to last post
2 139
Hi, I am absolutely new to this area. I am getting the following difficulty : Access denied for user 'ODBC'@'localhost' (using password: NO) when I...
SKB
02-04-2006 03:03 PM
Bill Karwin Go to last post
2 555
Hi, I am working with MySQL 4.1 and I got a table with a point field. I need to do an "offset" in all the points, that is, adding some deltaX to the...
Otavio Macedo
02-03-2006 02:34 PM
Bill Karwin Go to last post
3 111
I'm new to MySQL and am having a frustrating time figuring out some of the tools. I'm getting ERROR 1044 when I try to execute the...
Don
02-01-2006 11:15 PM
Bill Karwin Go to last post
2 134
Hi, i'm using visual foxpro 9 with a mysql 5 database, for direct access to my database i use navicat. In visual foxpro i've set my date format...
Rotsj
02-01-2006 04:21 PM
Aggro Go to last post
1 127
i did "select * into outfile 'data.sql' from CDRS" to backup my data. what is the reverse to get the data back in? it looks liek the fields are...
Shiraz
02-01-2006 01:49 PM
Bill Karwin Go to last post
1 103
I am converting my Access and MS SQL databases to MySQL and have a few problems: The following works in Access and MS SQL but not MySQL: SELECT *...
zMisc
02-01-2006 12:22 PM
Bill Karwin Go to last post
2 103
Are the LIKE and IS NOT NULL options available in MySQL - these 2 options are availble in Access and MS SQL. LIKE is for searching using wildcards -...
zMisc
02-01-2006 10:43 AM
Aggro Go to last post
1 98
Post New Thread

Display Options
Showing threads 601 to 650 of 3502
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.