Sivasakthi wrote:
Ananda Kumar wrote:
which file are u talking about.
regards
anandkl
Ordinary temp file.. say example in C:\output.txt
Actually i have given that file as input to some procedure, based on
that modification time we have calculate some details.
It sounds like you are usi
Neil Tompkins wrote:
Hi,
I've the following table design (attached txt file, for some reason
the content was being blocked) and I'd like any advice if this is the
correct method/design.
TableName:ProductMaster
ProductMasterID
FriendlyProductName
TableName:ProductContent
ProductContentID
P
Lamp Lists wrote:
hi,
I would like to get your opinions regarding which query you think is better
solution and, of course - why.
I have (very simplified example) 3 tables: orders, members and addresses
I need to show order info for specific order_id,
solution 1:
select ordered_by, order_date,
Svilen Spasov (Ancient Media) wrote:
Hello,
I have a website with a MySQL database and I have a table with ~2
millions row (usernames, filenames; ~120MB db data file and ~230MB db
index file) with I would like to search using the fulltext indeces.
Unfortunately the server get loaded pretty m
Tanner Postert wrote:
so i am doing a query on an enum field:
when i do this query:
select *, id as vid, user_id as uid from video where (file_complete =
'true') order by undt desc limit 0,10;
the results are 0.16 or 0.17 seconds.
instead of saying file_complete = 'true. if i say file_complete
h response time you are trying to keep to .01 or lower. If
it's end to end, you probably
want to look at your
network. Network latency can be the biggest culprit.
- Original Message -
From: "Jan Gomes" <[EMAIL PROTECTED]>
To: "mysql"
Cc: "johnlist&q
Jan Gomes wrote:
Hy Guys,
I needed denormalized my table to obtain high performance, but i want best
appropriate the space.
I joint two column (of the JOIN) intro one column with two separadores (# and ;)
Example:
ID | column_1 | column_denormalized
1 | Test | 1#20202;5#1000101;
I
Karl Larsen wrote:
I and a friend have written SQL to big Oracle DB but not much to
MySQL on our own computers. I find that there is a QUERY in the list for
MySQL but it does nothing much. Also I was glancing through the mamouth
MySQL reference manual and saw there are a bunch of tools that
kevin vicky wrote:
Hi,
I am trying to use locate() function to get position of a substring in a
text field which on average has 2000 characters and the search substring is
30 -50 characters long. The table has around 2 million records and looking
for a efficient way to do the search. I tried ful
Horst Azeglio wrote:
I'm trying to do a MySQL Query but it doesn't work. MySQL version: 4.0.26
When I put only one argument in MATCH, it shows no error but doesn't return
anything
[quote]
SELECT * FROM item WHERE MATCH (nom) against ('Huile');[/quote]
or
[quote]SELECT * FROM item WHERE MATCH (n
Gaspar Bakos wrote:
Hi,
I have a table that stores geometry information in one column in
"point" type. After freshly uploading the table,
myisamcheck --sort-index reports an error:
- Sorting index for MyISAM-table 'TEST_I14_GEOM'
myisamchk: Unknown error 126
myisamchk: error: Can't read key bl
Ow Mun Heng wrote:
I have 2 table.
Zones(Z1..Z20) and Radius(R0..R4)
where
R0 is equivalent to Z1
R1 " Z5
R2 " Z9
R3 " Z13
R4 " Z17
How can I make the query to join them in such ways?
eg:
select
A,B,C,D
from
Zone
inner join radius
on R1 = Z5
on R2 = Z9
on R3 = Z13
on R4 = Z17
or do I have
Bruno--
I am not an expert, but...
I would think most contact systems probably have separate tables for
organizations and individuals. And usually additional tables to allow
multiple addresses and telephones to be linked to the organizations and
individuals.
Yours seems rather novel in havi
mos wrote:
At 10:10 AM 5/20/2006, Keith Roberts wrote:
http://www.phpmyadmin.net/home_page/index.php
I think phpmyadmin will allow you to make changes to
multiple columns at once.
Sorry, I should have mentioned I was looking for a MySQL Administrator
running on Windows. Going through PHP see
Mark Sargent wrote:
Hi All,
I am looking at OSCommerce for design comparisons and wonder what others
think about the below table design,
CREATE TABLE `customers` (
`customers_id` int(11) NOT NULL auto_increment,
`customers_gender` char(1) NOT NULL,
`customers_firstname` varchar(32) NOT NUL
Steve wrote:
thank you for the clue of double quoting the html when inserting into the
database but I still get the error. the problem seems to be that I have
quotes INSIDE the html code as well (links and pix) so, i still get this
error.
"
Database Selected: candlecatalog
Query: insert in
Bedford Bob wrote:
I'd like to retrieve the total amount of time the articles have been in the
site from 2005-01-01 to 2005-01-31 and divide them by 365 (or 366 if leap
year).
if an article has been online from 2004-10-01 to null (meaning the article
hasn't been sold yet) then I may count 365 da
[EMAIL PROTECTED] wrote:
Ok. Got it.
And, since the able is already created and with tons of products inside,
how can I change the FULTEXT index?
I'm using phpMyAdmin.
Just create a new index.
http://dev.mysql.com/doc/refman/4.1/en/create-index.html
--J
[EMAIL PROTECTED] wrote:
Hi to all!
[EMAIL PROTECTED] wrote:
Hi to all!
I have "products" table:
CREATE TABLE `products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name` varchar(255) NOT NULL default '',
`prod_description` text,
`prod_colors` text,
`prod_inclu
way
Tony
"tony yau" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi John,
I didn't know you can do that! (such a novice indeed!)
Thank you for your reply, I will put it to the test first thing when i get
back to the office tomo.
Cheers
"John Hicks&quo
tony yau wrote:
Hello,
I can get a select result like the following: (SELECT ID,Changes FROM
mytable WHERE somecondition;)
IDChanges
-
1 10.0
1 10.3
1 12.2
2 31.0
3 1.02
3 4.9
how can I get the above result sets into
Bing Du wrote:
The following are Cold Fusion code. It's interesting that previously
defined queries can be used as 'tables' to pull data from.
===
SELECT db_entry_num, title
FROM account_info
SELECT projectID
-Patrick wrote:
John Hicks wrote:
-Patrick wrote:
Folks, I could really use your assistance.
Take a look here: http://pastebin.com/687889
How can I manipulate totalRows_numberComments so that I get the number
of blg_comment_com.idart_com PER blg_article_art.id_art? Right now, it
produces
-Patrick wrote:
Folks, I could really use your assistance.
Take a look here: http://pastebin.com/687889
How can I manipulate totalRows_numberComments so that I get the number
of blg_comment_com.idart_com PER blg_article_art.id_art? Right now, it
produces every blg_comment_com.idart_com in existe
René Fournier wrote:
Simple problem: Many client apps need to send data to a server.
By default each client will open a persistent TCP socket connection to a
common IP address:port (10.10.10.10:1234) and write to it (which the
server will save/log, etc.).
My question is, what should be ready
words? Thanks in advance.
From: John Hicks [mailto:[EMAIL PROTECTED]
What version of MySQL are you running? The ability to specify the minimum
length for fulltext search was not always supported.
Taco Fleur wrote:
Hi, that would be version 5.0.18 - thanks
Then your version is not the pr
Nanu Kalmanovitz wrote:
Hi!
System is Novell SBS 6.5 sp1 with Apache 2.0.48, MySQL ver. 4.0.15a,
PHP 4.2.3.
We try to define a select query that takes the values of the variables
'varKoshi' and 'varKvish' based on the following 4 tables:
'varKoshi' >>vv<<< 'varKvish'
Taco Fleur wrote:
Hi all,
I know I asked this question before and I do apologise for having to ask
again, but I have not been able to get this to work for us.
I modified the config file (there were many in the folder, not sure whether
I modified the right one) restarted the whole machine since t
Paul Halliday wrote:
I am trying to formulate a query that will increment if a condition is true.
For example, if I do a select (just let me know if there was data on
this day, if so increment count by 1 and check the next day) where
timestamp between jan and feb.
Could you be a bit more speci
Randy Paries wrote:
Hello,
Not sure what is going on
i have mysql Ver 12.22 Distrib 4.0.17,
I have a database that i can not delete.
i do this
#mysqladmin drop billmax -u admin --password
Enter password:
Dropping the database is potentially a very bad thing to do.
Any data stored in the databa
Jay Paulson wrote:
I have no idea if this is possible or not but is there a way to run Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
Thanks!
XAMPP is a distribution of Apa
I was hoping someone could improve on my suggestion.
But, not seeing any further replies, I guess my
solution must be optimal (troll, troll :)
--John
On Saturday 03 July 2004 03:34 am, John Hicks wrote:
> On Friday 02 July 2004 11:40 pm, Your Name wrote:
> > ... I now realize the impo
On Monday 05 July 2004 12:54 pm, Ying Lu wrote:
> Hello all,
>
> I have a datatype question.
>
> When there is column named ID, users are able to
> give it either char(11) or int(11).
>
> Please advise, which type is better such as more
> secure, save space, etc? Or it dose not matter at
> all?
It
On Monday 05 July 2004 12:28 pm, bruce wrote:
> my test tbls
>
> cattbl dogtbl birdtbl
> namename name
> id ---> catid ---> dogid
> id id
>
> so
> dogtbl.catid = cattbl.id
> birdtbl.dogid = dogtbl.id
>
> my question is how i can use "
On Sunday 04 July 2004 11:36 pm, bruce wrote:
> hi...
>
> i'm trying to figure out how to deal with joins
> (left/right)..
>
> i have the following test tbls...
>
> create table universityTBL(
> name varchar(50) not null default '',
> ID int(10) not null auto_increment,
> pr
On Sunday 04 July 2004 07:16 pm, bruce wrote:
> quentin/emmett...
>
> my question
>
> it appears that mysql essentially take the two
> values returned from the select, and inserts them
> into the (name,collegeid) that i specified...
>
> if this is the case, then i'm cool
Yes, this is the
On Sunday 04 July 2004 02:52 am, Gary Mack wrote:
> Hi there,
>
> I recently learned about LIMIT so that I can page
> through records on a web page I am creating.
> However, when coupled with ORDER BY, the sorting
> does not work anymore. Can someone look at my below
> query and point out what I
On Friday 02 July 2004 11:40 pm, Your Name wrote:
> ... I now realize the importance of normalizing my
> data,
>... what [is] the easy way... of getting
> it done now that I already have a database set up.
>
> Suppose I have a table "books", consisting of "id",
> "title", and "publisher"; the "pu
On Wednesday 16 June 2004 11:37 am, [EMAIL PROTECTED] wrote:
> Hi folks,
>
> I'm trying to install mysql on linux and it's giving
> me trouble. I'm new to linux and new to databases so
> my downfall isn't too surprising. I've been going by
> the readme file in the package but I can't seem to
> get
s
"where myfield like 'cson%' ")
Regards,
John
---
John Hicks
Gulfbridge, Inc.
"Putting the Web to work for your business."
http://gulfbridge.com
561-586-8116
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thursday 25 March 2004 03:11 pm, Erich Beyrent wrote:
> Is there any way I can show all
> the sql commands for creating and populating a table
> from within mysql?
Here's the first half of your task:
SHOW CREATE TABLE MyTableName;
--John
On Thursday 25 March 2004 03:11 pm, Erich Beyrent wro
On Friday 25 July 2003 02:02 am, Fred van Engen wrote:
> > $sql = "SELECT Realtor, HouseAddress, Bathrooms,
> > Bedrooms, YearBuilt, Garage, Location, Basement, Info
> > FROM properties WHERE Bathrooms =='".$a."'", "Bedrooms
> > =='".$b."'", "Garage =='".$c."'",
> > "Basement =='".$d."'";
>
I would just add a few words to Nils' excellent reply:
In the most general sense, a foreign key is just a primary
key value that occurs outside of its native table (i.e. in
a "foreign" table, get it?) in order to point to the record
in its native table with that value as its primary key.
You c
Looks like you really want to be doing full-text searching:
http://www.mysql.com/doc/en/Fulltext_Search.html
As you are doing it now, your users will only get a hit if
they enter the target keywords in the same sequence they
are stored in.
--John
On Wednesday 23 July 2003 04:24 am, Ercan Yurt
> | How are they typing in the information? From a web
> | page? From the command line? From a custom program?
> They type the information from a web page.
What web programming language are you using to receive the
post request from the web page and form the sql query to
insert the data into the
ary values is putting
> them into floats if I can live with rounding problems or
> put them into in ints and multiply them by 100 (or 1000)
> before putting them there (thus taking care of the
> decimal point myself).
>
> Cheers
> /rudy
>
> ps: I wish DECIMALS would be s
Is there an accepted best practice on whether to store
decimal currency amounts (e.g. dollars and cents) in MySQL
decimal column types?
Certainly, the most straightforward way is to use decimal
columns. But it appears that such values are stored as
ASCII strings, which would be inefficient fo
> So, my question is how can multiple values for a single
> field get represented in a single row and receive the
> benefits of an index? How can this data be represented?
Nice puzzle.
At first I thought it couldn't be done, given all your
constraints.
But there is one way.
You will have to bui
I needed to add a new, autoincrementing, primary key column
to a table and have been struggling to figure out how to
assign an initial, unique value to each row.
I finally accomplished my task, but feel sure there's an
easier way.
Here is my solution:
1. Add the column:
alter table mytable ad
> second, i have followed some discussions here about
> foreign keys but i still have not managed to create
> foreign keys
>
> so i want userTypeID in tblUsers to be a foregn key
> referencing the userTypeID col in userTypes
. . .
> what is wrong?
Nothing is wrong. Sounds like a perfect fine use
> WHERE TAB2_ID 2
> is the problem.
> Do you want = or <> or what?
Except that if you check the original post you'll see:
SELECT * FROM TAB1 WHERE TAB1_ID IN
(SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID > 2)
The ">" was at a line break and got swallowed up in the
replies with the >>s at the beginni
51 matches
Mail list logo
