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...
02-18-2006 04:48 PM
Michael Austin Go to last post
2 176
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...
02-18-2006 12:35 PM
Bill Karwin Go to last post
2 166
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...
02-17-2006 06:02 PM
sgr Go to last post
2 142
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...
02-17-2006 10:04 AM
Joe Makowiec Go to last post
5 103
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...
02-17-2006 03:14 AM
m Go to last post
3 165
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...
02-16-2006 04:51 PM
zMisc Go to last post
9 205
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 112
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...
02-16-2006 08:58 AM
Piotr Go to last post
6 114
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...
02-16-2006 08:43 AM
Gordon Burditt Go to last post
5 115
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...
02-15-2006 04:48 PM
Bill Karwin Go to last post
2 154
Hi Gang, Regarding the MysqlDataTruncation issue, I am having trouble over-riding it...
02-15-2006 03:31 PM
mark@thematthews.org Go to last post
2 312
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...
02-15-2006 01:49 PM
Thomas Bartkus Go to last post
4 139
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,...
02-15-2006 10:53 AM
phillip.s.powell@gmail.com Go to last post
2 127
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...
02-13-2006 05:05 PM
Michael Austin Go to last post
4 123
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...
02-13-2006 04:51 PM
Bill Karwin Go to last post
1 155
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...
02-13-2006 12:25 PM
Bill Karwin Go to last post
1 160
"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 114
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...
02-10-2006 04:58 PM
smatta@acm.org Go to last post
5 133
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 186
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 122
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...
02-10-2006 12:12 AM
ventre--pattes Go to last post
5 141
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 148
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...
02-09-2006 05:20 PM
phillip.s.powell@gmail.com Go to last post
2 114
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...
02-09-2006 02:45 PM
Bill Karwin Go to last post
2 142
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...
02-09-2006 01:21 PM
Jonathan Go to last post
2 129
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...
02-09-2006 04:26 AM
marc.wyburn@googlemail.com Go to last post
2 145
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...
02-08-2006 09:24 PM
Bill Karwin Go to last post
1 144
I have some tables that is connected in a table like this: TracklistID CDid SongID it could look like this 1 1 1
02-08-2006 12:04 PM
Bill Karwin Go to last post
1 115
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...
02-08-2006 01:23 AM
fritz-bayer@web.de Go to last post
3 116
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 125
Large table performance problem with MYSQL performance with ASP.NET I am doing some benchmarking of an application using MYSQL under Windows and I...
02-07-2006 01:16 PM
Bill Karwin Go to last post
1 113
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...
02-07-2006 12:59 PM
Bill Karwin Go to last post
1 170
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 122
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...
02-06-2006 09:43 PM
pc Go to last post
3 145
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...
02-06-2006 08:59 PM
maui wuai Go to last post
2 119
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...
02-06-2006 08:49 PM
phillip.s.powell@gmail.com Go to last post
9 175
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 134
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...
02-06-2006 06:45 PM
Pasquale Go to last post
4 178
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 292
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...
02-06-2006 11:21 AM
Bill Karwin Go to last post
1 124
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...
02-05-2006 03:08 AM
Heikki Tuuri Go to last post
1 144
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...
02-04-2006 04:36 PM
UKuser Go to last post
3 131
I got a table with the following fields: BirthDay (Date) Reminder (Short integer) I need to select all records where BirthDay - Reminder <= Today...
02-04-2006 03:20 PM
Bill Karwin Go to last post
2 149
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...
02-04-2006 03:03 PM
Bill Karwin Go to last post
2 558
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 115
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...
02-01-2006 11:15 PM
Bill Karwin Go to last post
2 138
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...
02-01-2006 04:21 PM
Aggro Go to last post
1 134
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...
02-01-2006 01:49 PM
Bill Karwin Go to last post
1 106
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 *...
02-01-2006 12:22 PM
Bill Karwin Go to last post
2 108
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 -...
02-01-2006 10:43 AM
Aggro Go to last post
1 106
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 - 2015, Jelsoft Enterprises Ltd.