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     
Please help. I have a website running on a linux/apache/mysql/php server. I receive about 8,000-10,000 visitors a day with about 200,000 to 300,000...
marcfischman@gmail.com
09-07-2006 06:47 PM
Gordon Burditt Go to last post
1 150
Hi all, i used to use mysql front with my old mysql 3.x version. now i have upgraded to mysql 5.0 and i have just discovered mysql front is not...
xkp
09-07-2006 03:55 AM
xkp Go to last post
2 274
hi two days before arount 20,000 rows are manuly deleted, is there any way to recover it back. We have backup, that is 10 days old, Is there any way...
senthiltsj@gmail.com
09-06-2006 07:40 AM
Jerry Gitomer Go to last post
2 238
Hey everyone. I have this query select * from `TableName` where `SomeIDField` > 0 I can open a mysql command prompt and execute this command with...
elitecodex
09-05-2006 06:06 AM
elitecodex Go to last post
5 168
I have query like below: SELECT part_no,part_nm,qty FROM tb_stok_out ORDER BY part_no as result: part_no part_nm qty aaa asdfd 3 abab sdfsdf 4 abab...
furqonk@gmail.com
09-04-2006 03:45 PM
Bill Karwin Go to last post
1 157
Hi I'm making a nightlife listings system. I have a table that stores listings, the type of listing can be either an event at a night-club event, at...
TWIOF
09-04-2006 11:19 AM
TWIOF Go to last post
1 159
When adding a new record in my forum, if the new thread is the parent thread, the Parent_Ancestor takes on the record ID (field called Forum). For...
RioRanchoMan
09-03-2006 09:29 PM
RioRanchoMan Go to last post
2 181
Dear all, I am very new in MySQL, I am working on image database project for my research and I have problem how to convert blob field into float ...
yoes
09-02-2006 04:30 PM
Aggro Go to last post
1 176
I have a field that contains an underscore. How can I do a query for the underscore since I just found that underscore really doesn't...
Barkster
09-02-2006 04:22 PM
Aggro Go to last post
1 169
I have MySQL 5.0 on my W2K network. It has always worked fine. For some unknown reason, this morning one of my applications that uses the database,...
Xpoes
09-01-2006 06:27 PM
mikedlnk2000@gmail.com Go to last post
1 183
HI, i have a set of tables reffering to various aspects of a nigh-life listings system. I have tables named gigs and venues. Each gig has a...
TWIOF
09-01-2006 01:17 PM
Aggro Go to last post
1 139
When I execute the command "show create view" while logged in as root I get this error: "select command denied to user 'root'@'%' for column (a...
No bother
09-01-2006 12:06 PM
No bother Go to last post
1 158
I would like to ask , if I can restrict a user from a single table. I want him to be able to create,alter,delete all the tables but one, which I want...
D. Mexis
09-01-2006 08:45 AM
Michael Austin Go to last post
1 171
Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will not work. When I try to acccess it I get the following...
grabro
09-01-2006 08:37 AM
Michael Austin Go to last post
1 294
Let's say I have a query that will return a collection of rows with a datetime field: SELECT User,Activity,Timestamp FROM `table` WHERE Activity =...
Kevin
08-31-2006 09:49 AM
Kevin Go to last post
2 139
Hi, i've installed OCS Inventory NG for inventory and it has installed Mysql ver: mysql Ver 14.12 Distrib 5.0.18, for Win32 now i have to make a...
Andrea
08-30-2006 08:07 PM
No bother Go to last post
1 163
My understand is that MYSQL only supports indexes on the beginning of a string of data. for example, if you have a list of email addresses,...
dt
08-30-2006 12:35 AM
Bill Karwin Go to last post
1 152
Beginners question: I'm a little confused about the working of the mysql-cache. I don't understand the mechanism. What is it exactly you cash ? The...
Peppi
08-28-2006 06:03 AM
Peppi Go to last post
2 250
I want to have a field where I store a list of what categories that particular row falls under, I don't know which format to do or how I would query...
thesimplerules@gmail.com
08-27-2006 08:33 AM
Jerry Gitomer Go to last post
1 180
Hi everybody As we know that replication process uses 3 threads- 1. Master thread (Binlog Dump) 2. I/O thread 3. Sql Thread Now I have some...
Pawan.Ghildiyal@gmail.com
08-25-2006 04:01 AM
davie Go to last post
1 129
can anyone explain to me what the pros and cons are of creating indexes on mysql tables. do they increase query speed? and if so at what cost? im...
mcyi2mr3@googlemail.com
08-24-2006 07:59 PM
lark Go to last post
3 276
Hi, Thank you for taking the time to read this. This is a rather general database performance question I think. But since I'm running WAMP I...
amygdala
08-24-2006 05:43 AM
davie Go to last post
2 119
Given a primary key field `RecNo` - Are there any performance reasons to favor one of these two otherwise equivalant expressions? SELECT...
Thomas Bartkus
08-22-2006 07:38 PM
strawberry Go to last post
1 155
Hello people, There is a problem is that mysql_connect() somehow caches last sessions IP and is not using the one which you put into host...
hugo
08-22-2006 07:54 AM
hugo Go to last post
1 129
I have a new system Im building that stores entries of what people are searching for on my sites. I want to be able to keep records of how many...
l3vi
08-22-2006 12:39 AM
l3vi Go to last post
15 379
hi, i want to display the five most recent rows in my table (there is a timestamp), but sorted in ascending order. the problem is that when i...
Mark
08-21-2006 03:49 AM
Mark Go to last post
6 233
hi. i have two tables. table one ("users") contains two columns, "user_id", and "user_name" table two ("spam") contains three columns...
Mark
08-21-2006 03:45 AM
Mark Go to last post
4 184
hi, I've following table: +----+-------------+----------+-------+-------+ I've products from diffrent delivers and I'd like to write the...
mfr
08-20-2006 05:14 PM
Bill Karwin Go to last post
3 167
I have a table with rowid and name as columns and I want to insert multiple names in the same record. Can anyone help me?? Thanks,
uma_sarayu@rediffmail.com
08-18-2006 12:12 PM
davie Go to last post
2 142
OK, I'm officially frustrated. I had MySQL 4.0.18 running as a service on my WinXP laptop, along with MySQLAdministrator, and a new tool, DB...
Dano
08-18-2006 12:04 PM
davie Go to last post
1 192
I am using WinXP, GNU Emacs 23, MySQL 5. When I start a mysql process with `sql-mysql' in emacs, no output is displayed in the buffer until I quit or...
sparkw
08-18-2006 10:54 AM
sparkw Go to last post
2 165
Is there a GUI utility which can create a new table in my mysql database from a 50 million-record text file? I want mysql to get the data into the...
xz
08-18-2006 12:41 AM
Bill Karwin Go to last post
4 138
i've got mysql 5.0 and I have 50 million records in a text file on an external USB 2.0 hard drive. I can import the file into a mySQL database on my...
xz
08-17-2006 04:45 PM
Steven Musumeche Go to last post
2 139
I am try to create a procedure that does inserts and returns a command: DELIMITER $$ DROP PROCEDURE IF EXISTS `testDB`.`insmod` $$ CREATE PROCEDURE...
deja.10.thrillho@spamgourmet.com
08-16-2006 05:31 PM
deja.10.thrillho@spamgourmet.com Go to last post
1 106
I am migrating bugzilla from mysql 3 to mysql 5. I cannot upgrade bugzilla itself yet, I must migrate it first. One (probably several) of the queries...
Mike
08-16-2006 02:51 PM
Bill Karwin Go to last post
2 136
The following query: SELECT rownum from(SELECT @rownum:=@rownum+1 rownum, t.*FROM (SELECT @rownum:=0) r, (SELECT Application FROM...
RobbGMelenyk@gmail.com
08-16-2006 10:09 AM
RobbGMelenyk@gmail.com Go to last post
1 142
In my SQL class, we are using the book, "SQL: A Beginner's Guide: Second Edition", by Robert Sheldon. However, we are also mostly using MySQL,...
Earthlink Newsgroups
08-16-2006 05:41 AM
strawberry Go to last post
1 247
"ENUM('value1','value2',...) => 1 or 2 bytes, depending on the number of enumeration values (65,535 values maximum)" This seems to mean: "a" = 1...
StupidScript
08-15-2006 12:51 PM
StupidScript Go to last post
7 161
Hi,all I am using Mysql 5.0 But I get an error message for calling procedure with mysql_query(). My program is shown below: Thank &...
Gary li
08-15-2006 10:28 AM
Gary li Go to last post
2 133
ok I want to do a dump daily of my database, this works fine, however the problem I have is that while the dump is executing itself, I cant access my...
jmichel
08-14-2006 03:11 PM
Pelle Giss Go to last post
5 178
I have: col1 col2 item1 3 item1 5 item2 7 item2 3 item1 4 item3 4 I'm looking for the result:
sbswift@gmail.com
08-14-2006 09:33 AM
strawberry Go to last post
4 241
Hi, I have a table with a list of companies, with fields like this (simplyfied): ID (int, auto_increment) CompanyName (text) ContactPerson...
AT
08-14-2006 04:49 AM
macmorten@gmail.com Go to last post
3 133
Folks - some years ago a thread was started (I believe) by a gentleman named Creigh Shank regarding his use of a RAMdisk mySQL db. I am trying to...
Claude
08-13-2006 07:54 PM
Claude Go to last post
2 213
I have this query which works to insert and update the row. Problem is I need it to check and see if a value in the row is the same as the...
admin@binindex.net
08-12-2006 08:35 PM
Bill Karwin Go to last post
1 253
Hi I'm in need of creating reporting database. What I have to do it is to replicate only half of tables to next database so reports could query only...
Radek
08-11-2006 09:07 AM
Steven Musumeche Go to last post
5 244
Hi all , I have sql statement below...
AT
08-11-2006 04:06 AM
strawberry Go to last post
6 158
After creating a new user and executing "mysqladmin flush-privileges" I have lost all my privileges, I cant connect as root or any other user. Any...
razedk
08-10-2006 05:25 PM
razedk Go to last post
1 127
Hello My web hosting company has lost my data due to the mysql software failing, it only affected those people using innoDB engine. I asked them why...
mantrid
08-10-2006 12:43 PM
Bill Karwin Go to last post
5 134
I want to do the equivalent of SELECT id from TABLE WHERE text='text' only fast solution I found is: SELECT id,text from TABLE WHERE MATCH(text)...
AT
08-10-2006 10:39 AM
jmichel Go to last post
4 162
Ok, I was making some changes in privileges and must have deleted the localhost account... it seems I'm pretty much locked out. Is there...
Bill H
08-08-2006 01:24 PM
Bill H Go to last post
3 238
Post New Thread

Display Options
Showing threads 201 to 250 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.