Sponsored Links

mailing.database.mysql mailing.database.mysql

Page 9 of 120

109

Last »

Threads in Forum : mailing.database.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Using MS Access to get data in/out of a MySQL database I have no experience using MS Access to interface with MySQL. I have a tiny MySQL database that might need to have Access connect with it over the... David Dawson	07-26-2006 07:08 PM David Dawson	2	143
Cannot add stored procedure with parameterized query I'm fairly new to this so hopefully it is a dumb mistake... I need to create a simple stored procedure along the lines of: delimiter // CREATE... AT	07-26-2006 03:42 PM AT	0	140
Help with Performance Tuning I posted this in the myodbc group. Not sure what the "proper" way to cross post is, but I'm hoping someone can lend a hand w/out me having to re-type... AT	07-26-2006 01:21 PM AT	0	140
Query with MAX() and LEFT JOIN Hello Everyone, I have been searching around for an answer to this question with no luck. I hope that some of you may have a couple of good ideas I... AT	07-26-2006 10:25 AM strawberry	3	120
Unique version record in a MySQL database. Unique table version record Hello, I am using a table record to store informations about database dump,I use this table : CREATE TABLE... AT	07-26-2006 04:52 AM AT	0	106
Unique table version record Unique table version record Hello, I am using a table record to store informations about database dump,I use this table : CREATE TABLE... AT	07-26-2006 04:52 AM AT	0	115
How to query date between? I have table name "actionlog",and one field in there is "date_time" date_time (Type:datetime) example value : 11/1/2006 11:05:07 if I'd like to... zdk	07-26-2006 12:38 AM zdk	2	133
Replace variables in resulting query Hi, I have the results of a query that as follows. I want to replace $prod with the value of the variable - how can I get php to do that? Select... Jim	07-25-2006 03:06 PM AT	1	119
Point of Sale Application Help hey all... im looking to set up a p.o.s system in my shop, it's a grocery store. After receiving quotations from three sources, they all spoke... AT	07-25-2006 07:04 AM AT	0	96
how to store chinese chars and also italian, french and english in mysql ? Hi, sorry for the newbie question but I'm not able to store chinese characters into a column in a table.... how should the db setted and the table... AT	07-25-2006 03:02 AM AT	0	210
I want field data without field name, how? hi all I am retrieving data from mysql under linux. something like mysql -e "select id from table1", I get output id 1 2 but I dont want the field... Chenxi	07-24-2006 10:16 PM Michael Austin	2	122
insert question Hi all Complete newbie here, so apologies if this is the wrong forum. I've been asked to use mysql and asp to make a simple bidding system... David Eades	07-24-2006 07:32 PM Michael Austin	9	255
update values on inserting duplicate index hi I am very new to mysql. I have a question about using the "on duplicate update" clause with insert command. my table "data" has two columns,... FangQ	07-23-2006 05:38 PM FangQ	4	122
IN vs individual queries, performance comparison Hello, If I needed to fetch 3 entries from a database, is there a significant performance difference between the following? SELECT * FROM JOBS... AT	07-23-2006 01:51 PM Michael Austin	1	92
mysql 2gb table limit? MySQL5 on win2003 - I'm new to mysql, and have a table that has reached 2gb in size and I can't put any more in. I am using innodb and have set... Keith	07-22-2006 09:56 PM Bill Karwin	1	142
Where's the MySQL tray icon? Hi All, I'm running MySQL 5.0.15-nt over WinXP-Pro/SP2. I just got "My Definitive Guide to MySQL 5", which I find very helpful. It suggests that... Richard	07-22-2006 02:49 PM Richard	0	150
Returning Clock Hours in Time Range I have a table such as below: BreakID StartTime EndTime 1 08:00:00 10:00:00 2 08:00:00 10:30:00 3 08:00:00 11:00:00 4 08:30:00 11:00:00 What I... No bother	07-21-2006 10:07 AM No bother	2	123
rebuild quick problem (& temporary file location) Core question: where does MySQL create temporary files in a quick rebuild? ( I thought I knew the answer, but now can't find them.) I'm trying to... AT	07-21-2006 08:02 AM AT	1	126
Minor query optimization - calculated column reuse? This isn't very important to me, but my brain is arguing that there is an elegant way of performing the below "cho+protein+fat" calculation... AT	07-20-2006 11:40 PM AT	0	123
MySQL 5.0.24 release date? Hello, I suffer of MySQL 5.0.22 bugs http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=2449 and was waiting for MySQL 5.0.23 to fix this... Abdullah	07-20-2006 06:00 AM Abdullah	4	137
Using MySQL as a backend for a commercial application (Licensing) I've read the MySQL licensing material and what I've found online, but I'm still unclear about when I have to pay MySQL for a license. Scenario:... sp3d2orbit	07-19-2006 07:51 PM No bother	3	126
Workbench Hi, Is there a way to automatically hide all FK labels? Jared	07-19-2006 07:45 PM Jared	0	140
Find value not in between values. Hi all. I have a SQL question I am having trouble with. We have a table, with a column that contains a code. These codes start at '00001',... AT	07-19-2006 05:45 PM Jared	1	233
Host{myhostname.com} is not allowed to connect to my MySQL Hi All, I installed MySQL4.113 and MySQL Administrator 1.1.9 in SuSe linux. Both are working fine. However, I just install MySQL Administrator... beta	07-19-2006 04:02 PM Ian Pawson	1	138
Select * when using AES_DECRYPT If all my columns are encrypted, is it true that I can not use a simple 'select * from' anymore. Instead I need to do: select AES_DECRYPT( column1 ,... AT	07-19-2006 05:42 AM Jeff North	1	163
MySQL insert records using MS Access Hi, I have a MySQL database linked to an MS Access front-end. I have an app which works fine with the local copy of the Access DB, but when run... David	07-18-2006 12:17 PM Bill Karwin	2	140
MYSQL Limit on length of insert statements? My tired old eyes may be failing me, but the following insert statements look correct to me, but I can't seem to get a clean insert from a fairly... AT	07-18-2006 10:12 AM ming	2	106
Table column value update using stored procedure Dear all, I have a challenge in hand and am not too sure how to accomplish this using stored procedure. I have a table containing about 3 fields,... Godzilla	07-18-2006 08:45 AM Godzilla	2	138
PreparedStatements with variable number of parameters Hello, Is there a good way to make PreparedStatements with a variable number of parameters? My queries look something like this: SET @rowid :=... AT	07-17-2006 10:50 PM Bill Karwin	3	100
strict_trans_tables and null defaults I am using 5.0.21 community-nt and have the following in the configuration... AT	07-17-2006 04:05 PM AT	0	136
problem w/ duplicates Let's say I have a table of users, and each user has a list of categories. I could store each user's categories as TEXT with delimeters like... Mark	07-17-2006 01:54 PM Mark	8	123
Pass command-line argument to MySqlDump - How? Hi All, I'm running MySQL version: 5.0.15-nt on WinXP-Pro/SP2. I created a one-line batch file DumpPAM.bat in a directory on the PATH: mysqldump... Richard	07-17-2006 11:45 AM Richard	3	119
Replicating mysql DB to local machines We have an application written for a PDA that we are switching from MS Access to Mysql. There is a central server that has all the data in a mysql... dcha	07-17-2006 07:33 AM dcha	0	115
mysqldump failure Hi All, I issued the command: mysql> mysqldump pmtallocmodel_development > K:/_Projects/Ruby/Backup/pmtdev_2006.07.15.txt; I got the... Richard	07-16-2006 12:33 PM Richard	5	143
configuration of new database I zipped up my website from one server and would like to move it to another hosting company. Where in the tree are the configuration files for... Larry Snyder	07-14-2006 09:21 PM AT	1	121
Hard time with installing MySQLdb for Python on Linux Hi, I am having hard time with installing MySQLdb on Linux. My Python version is 2.3. I have downloaded "MySQL-python-1.2.1_p2.tar.gz" from... gmax2006	07-14-2006 06:01 PM gmax2006	0	122
Detect real character set Is there any way to detect the real character set use in columns? I've just seen a mysql 4.0 database where the default character set was latin1 but... Robert Boone	07-14-2006 01:56 PM Robert Boone	0	141
Results suggest database corrupted; how to deal with it? Hi All, I'm running MySQL 5.0.15-nt running over WinXP-Pro/SP2. The following group of commands and responses suggests to me that my installation... Richard	07-13-2006 06:50 PM Richard	2	126
How to size a MySQL server Hi everyone, I've got a question about how to size the server hardware for a MySQL system that I've got to buy and build. We're going to be putting... AT	07-13-2006 11:22 AM AT	2	243
will create temprory tables from select acquire lock hello grp ! while running one application sometime i got these errors Status : Failure - Deadlock found when trying to get lock; try... AT	07-13-2006 10:51 AM AT	0	124
Insert copied records using MS Access Hi, I've been using MS Access as a front end to our remote MySQL db for a long time. I've just added a facility for clients to select a record to... David	07-13-2006 09:47 AM David	0	145
Difference between utf8_general_ci and ut8_unicode_ci What is the difference between utf8_general_ci and ut8_unicode_ci when specifiying the collation for a mysql database? Thanks. --AK mardini	07-13-2006 05:32 AM mardini	0	110
Difference between utf8_general_ci and ut8_unicode_ci What is the different between utf8_general_ci and ut8_unicode_ci when specifiying the collation for a mysql database? Thanks. --AK mardini	07-13-2006 05:31 AM mardini	0	136
An introduction and a question... I'd like to introduce myself to the group. I am currently researching the use of MySQL as a database backend for AutoCAD Map 3D. I will hopefully be... AT	07-12-2006 03:19 PM AT	2	148
Results in multiple pages. Takes too much time Hi, I have a table of a million records and wrote a CGI-PERL script to display the results based on the user input. The results might be anywhere... AT	07-12-2006 01:23 PM Jeff	1	136
please help if I want to find a user_id from table 1 which does not exist in the table 2(possible multiple entries for any user_id). the user_id in table 2 is a... AT	07-12-2006 12:24 PM AT	2	131
Regarding Update/select Query Hello grp! i'm using INNODB tables which are using frequently . if i fire a SELECT query which fetch major part of table it usually take 10-20... AT	07-12-2006 11:17 AM Shawn Hamzee	5	116
MySQL SSL on Windows I've been tasked by my boss with configuring a MySQL install that we host for one our partners to support SSL using a commercial certificate. MySQL... Jason Wilson	07-12-2006 11:02 AM Shawn Hamzee	1	139
There is a good photo website hello,everyone,I am the newcomer.I hope you can go to this website:www.flickr.com/photos/partpic/.I am sure it is NOT spam.Then,you can feel that it... Part Pic	07-12-2006 04:24 AM Part Pic	0	137
Finding Duplicates Help I was hoping someone will be able to help me, i've got a bit of experience with mysql, but nothing quite like this. I have a table with 3 columns... duende	07-11-2006 11:58 AM Bill Karwin	2	142

Page 9 of 120

109

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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