Re: Optimizing SQL statement

group-by" and the query takes only 0.25 sec Is there anyway to optimize this query to get faster responses ? Thanks, --- Puiu Hrenciuc Set an index on ip and type and "probably" also on record_time Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for m

Re: Wont insert into database

the feilds are blank echo the mysql_query please and see for youself if all variables were put in right. print_r($_GLOBALS); to see if all vars were given correctly. I also think PHP has probably a problem with `$name`. try using '$name' instead or `".$name."` Barry -- S

Re: WITH TIES

Taco Fleur wrote: Hi all, is there a WITH TIES function to use with the LIMIT keyword? What does that WITH TIES function should do? Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http

Re: WITH TIES

your problem but regarding sub-queries. http://dev.mysql.com/doc/refman/5.0/en/subqueries.html Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: OOC: Reply / Return Address of this List

Jason Teagle wrote: 1. Please always reply to the List. Who runs this list? Could it please be configured to send replies back to the list rather than the individual? It's really annoying to keep ending up with a personal address - it would make things so much easier, and is, to my knowledge,

Re: Import .frm .myd .myi to Mysql

hicham wrote: Hello I'm new bie user of mysql, I need to create a database and import some frm .myd .myi files to that database , also if you can point me to some easy to start tutorial for how to create user account in mysql , create a database , etc Thanks for replying Hicham www.mys

Re: Multi Threaded on RedHat ES 4

Ed Pauley II wrote: I recently changed from SuSE ES 8 to RedHat ES 4 running MySQL 4.0.26 (I will be upgrading to at least 4.1 after busy season). I compiled my own version this time and when I start the server I see only one mysqld process. I am used to seeing hundreds as my max connect is set

Re: Starting mysql through sudo

tuxlinsecure wrote: Hi, What binaries & directory premissions are required to enable in sudo to start mysql Instance through sudo. Thanks, - How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates. You should ask on a sudo / Unix

Re: WHERE doesn't work

Tom Lobato wrote: Hi! UPDATE command is not working for only the record that I want, but for all in the table. I sees WHERE is not interpretated by Mysql server. At least the result is identic to it. For example, If my php execute UPDATE clientes SET tipo='r', nome_fantasia='

Re: mysql 5 vs. mysql 4: str_to_date

Vincente Aggrippino wrote: The following query runs fine on my test server at home, running MySQL 5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it gets a syntax error. Can anyone help me figure out why? ... insert into product (name, url, cost, purchase_dt) values('Whatcham

Re: Urgent Fetch and updation in single step/query

WEBBEE . BIZ wrote: Hi all, Can we run a query like UPDATE table_name set abc='1'; and still fetch the value from a column from table . I mean Can we run select And update query in one statement. If yes how. Pl. tell me for versions 4.x and 5.x Pl. do help me. Hmm should work with PROCEDURE in

Re: Individual Row Addition ((!!!help!!)

Brian E Boothe wrote: well i have this $sql2="SELECT ordernumber,Elecrem, CtrlProjrem, OthrProjrem SUM(Elecrem+CtrlProjrem+OthrProjrem) AS btstotal9 FROM orders GROUP BY ordernumber ORDER BY ordernumber"; only add's up the first row it hits and adds it to the remaining rows ,,

Re: Top N selections + rest row

C.R.Vegelin wrote: Hi All, Anybody with smart ideas to get Top-N rows plus the rest row ? Suppose I have ranked sales values descending for 2005, like: Select Country, Sum(Sales) AS Sales From myTable Where Year=2005 Group By Country Order By Sales DESC LIMIT 25; Then I get Top-25 sales rows,

Re: Stumped again by joins

ours like '%olympic%' or w.walks like '%olympic%' or l.lectures like '%olympic%') order by ... I am not quite sure but using biography.guide_id instead of b.guide_id would probably solve the problem. I know that using aliases in WHERE clauses don't work reall

Re: Accumilating Blog Comments

-Patrick schrieb: Hi Folks, Here is the table for the articles: CREATE TABLE `blg_article_art` ( `id_art` int(11) NOT NULL auto_increment, `idtop_art` int(11) NOT NULL default '0', `title_art` varchar(100) NOT NULL default '', `description_art` blob NOT NULL, `text_art` longtext NOT NU

Re: Undeleting an entire Database?

clint lenard schrieb: Hey guys, Well, I was unable to find anything on Google and I don't expect to find a miracle... but I figured "why not". On Sunday morning I was trying to delete a Table through PHPMyAdmin and well... I dropped the entire DB without backing it up before. Stupid mistake, I

Re: Undeleting an entire Database?

clint lenard schrieb: Hey guys, Well, I was unable to find anything on Google and I don't expect to find a miracle... but I figured "why not". On Sunday morning I was trying to delete a Table through PHPMyAdmin and well... I dropped the entire DB without backing it up before. Stupid mistake, I

Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?

The Nice Spider schrieb: Hi, This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? Probably if you post the error message you get. -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL G

Re: How can I get my disk space back?

David Israelsson schrieb: I have a really simple (two tables, one relation) but big (~70 GB) innodb database containing rather dynamic data. After deleting lots of records from the tables, the innodb data files still take the same amount of disk space as before. What is the correct way of freei

Re: UPDATE question

Cummings, Shawn (GNAPs) schrieb: If I have 4 Fields (FIELD1, FIELD2, FIELD3 & FIELD4) I can do this easily; UPDATE TABLE_NAME SET FIELD4 = FIELD1; But -- how do I do it so that FIELD4 = FIELD1 & FIELD2 ??? I can't seem to find any examples online. Maybe it's just too early in the morni

Re: DATEDIFF and TIMEDIFF

Peter Lauri schrieb: Best groupmember, I run version 3.23.58 and need to use something similar to DATEDIFF and TIMEDIFF to calculate difference between two a timestamp and current_timestamp(). Is there any other function that is working for version 3.23.58 that do the same job? Best regards, P

Re: Table so slow to read

. All is the same, I copy the database from one server to other But the servers are not the same, right? This could be one problem. The other problem might be missing indezies on your other server. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL Gene

Re: Add a new value in an ENUM by manipulate .frm

ySQL that i could tell you how MySQL works behind ALTER TABLE. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Insert Select problem

av_id IN (1) Not unique table/alias: 'objektflyer_verknuepfung' I use a very old Mysql. 3.2 or similiar. Anyone knows that error and can give a helping hand? Thanks, Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing Lis

Re: Insert Select problem

Johan Höök schrieb: Hi Barry, see: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html you cannot insert into a table you're doing select on (same goes for update). But i am doing it on a test server version 5.x and it works like a charm :) -- Smileys rule (cX.x)C --o(^_^o) Dance f

Re: Determine version of *.frm, *.MYD and *.MYI

Nils Lastein schrieb: After a disk crash I managed to save the *.frm, *.MYD and *.MYI-files from the disk. When putting these files into another mysql server I get: mysql> select * from validate; ERROR 1033 (HY000): Table './mydb/validate' was created with a different version of MySQL and canno

Re: single database ... many aplications

That way the other servers can access this Database and get the Users from it. Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Matching problem

in any way? Or does something like that function exists? Well in PHP you a function called in_array() which would work kind of similiar what i want to do. Any help is very appriciated ^_^ Many thanks for any replies Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_

Re: Matching problem

Barry schrieb: Hello everyone! I have a slight problem matching rows. My problem is the Value in a textfield is: "8768239857" I created that with concat. Is there a way to match one specific number out of that field? like WHERE SUPERFUNCTION(concated_field) = 87682 Is something

Re: Matching problem

Wolfram Kraus schrieb: Barry wrote: Hello everyone! I have a slight problem matching rows. My problem is the Value in a textfield is: "8768239857" I created that with concat. Is there a way to match one specific number out of that field? like WHERE SUPERFUNCTION(concated_fiel

Re: Matching problem

彭一凡 schrieb: > try this: > WHERE concated_field LIKE '87682%' > or > WHERE concated_field LIKE '87682_' > would give me 876825 what i am not looking for. And i were also looking for 87682. So this doesn't work. But thanks anyway :) -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o

Re: How to solve this problem?

ySql support this statement? And how I can solve it? As far as i know you can only use JOINs with ON. So this would likely not work. If you tell what you want to be outputted we might help find a solution. barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^

Re: Matching problem

Marcus Bointon schrieb: On 9 May 2006, at 14:27, Wolfram Kraus wrote: WHERE concated_field LIKE '%87682%' No, because that would also match numbers that contain that sequence like '18768232876825'. 2. This doesn't sound like a good DB-Design, why don't you use two seperated fields for bo

Re: Quick Linux/MySQL performance questions.

YD (lotsof indexes). Read the Optimization sections of the mysql docs. More RAM will speed it up also. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: What is the best coding ethics related to mysql

tutorial of mysql. Also is there any certification of mysql, php etc. What kind of cert you are talking about? SSL certs or what? Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Need help with procedure

on the 20th January noone clicked that link. I think this have to be done with a procedure. So that my query would give a 0 (zero) for the 20th January as clicks. How would i do something like that? Thanks for your time :) Mysql version is: 3.23.54 Barry -- Smileys rule (cX.x)C --o(^_^o) Dance

Need help with prcedures

on the 20th January noone clicked that link. I think this have to be done with a procedure. So that my query would give a 0 (zero) for the 20th January as clicks. How would i do something like that? Thanks for your time :) Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o

Re: about log

Peng Yi-fan schrieb: > Hi, > > I would like to change the path of a database's log. Which command I should > choose? > > Thanks. > > Peng Change the config files ? -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives

Re: duration query: how to ?

o you have? An other way would be to convert the Dates into UNIX STAMPS that way you could subtract them and you have then the seconds between each date. I don't think i have to tell you how to go on then. Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o

Re: DateTime limits

ists, can I suggest MySQL accepts these values, at least for comparisons, a little cleaner? For what it's worth, and to help us C# coders... Ben When does this happen? What query had you run? A more insight might help fix the problem ;) Barry -- Smileys rule (cX.x)C --o(^_^o)

Re: DateTime limits

Ben Clewett schrieb: Hi Barry, This will happen when comparing against a TIMESTAMP field. CREATE TABLE a ( t TIMESTAMP ); SELECT * FROM a WHERE t > '0001-01-01 00:00:00'; Well my msql doesn't give me any errors using that query. neither a warning. This "might&quo

Re: DateTime limits

Ben Clewett schrieb: Hi Barry, This is what I get: mysql> CREATE TABLE a ( t TIMESTAMP ); Query OK, 0 rows affected (0.25 sec) mysql> SELECT * FROM a WHERE t > '0001-01-01 00:00:00'; Empty set, 1 warning (0.00 sec) m

Re: Select query problem

Nenad Bosanac schrieb: Hi I have one problem that i can`t resolve. still need advice or is it solved? -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: MYSQL->on delete no action

Nenad Bosanac schrieb: Hi all I made mistake i n my last post so now i make it true. I have problem in MYSQL query tool. Well i put on foreign key on delete no action but next time when i edit that table it said that is on delete is restrict. Why is that ? I use MYSQL Query tool and

Re: Access denied

Kaushal Shriyan schrieb: Hi ALL I am faced with a issue of creating database , The issue is I am able to enter to the MySQL Server with the password, but when i try to create database I get Access Denied Below are the details [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to

Re: I cannot login MySQL Network

exact error you get? => [EMAIL PROTECTED] is this the email you see on the error? If yes, then it could be because of your character encoding. Use UTF-8 encoding in your browser. Otherwise here is a telephone number: +1-208-514-4780 (14:00 - 01:00 UTC, Mon-Fri) Greetings Barry -- Smil

Re: Limiting results from joins

does get the work done. How could I speed this up, or solve it in another statement? Regards Use INNER JOIN :) Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my-huge.cnf quite outdated

ver needs special handling. there is no "the one and only you have to do it this way" way Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL naming convention?

naming convention guidelines and best practices? Nope. Since any name of a column has just to be syntactically correct. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: my-huge.cnf quite outdated (fwd)

Gaspar Bakos schrieb: -- Forwarded message -- Date: Mon, 12 Jun 2006 11:39:11 -0400 (EDT) From: Gaspar Bakos To: Barry <[EMAIL PROTECTED]> Subject: Re: my-huge.cnf quite outdated Hello, Barry, RE: Guess we would answer to everyone on the list who wishes to optimize h

Re: How to set host table?

use this statement for setting Host table? > > If I can, what SQL statement can I use? > > Otherwise, can I only insert the host table depended on db table? > Hello Takanobu-san! This will surely help you: http://dev.mysql.com/doc/refman/4.1/ja/connection-access.

Re: How can i decrypt password

Kaushal Shriyan schrieb: Hi I have a situation here how can i decrypt the mysql database userrs password Kaushal Not possible. -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Re: How can i decrypt password

Vitaliy Okulov schrieb: Здравствуйте, Paul. Вы писали 13 июня 2006 г., 17:13:52: At 14:09 +0200 6/13/06, Kim Christensen wrote: On 6/13/06, Barry <[EMAIL PROTECTED]> wrote: Kaushal Shriyan schrieb: Hi I have a situation here how can i decrypt the mysql database userrs pa

Re: order field of a table

uld be updating the table first UPDATE workers SET impartance = importance + 1 WHERE importance > 1 This would raise every importance by one where the importance is bigger than 1. Now you could insert john with the importance of "1". Is it that what you have been looking for? Barry -

Re: The number of left join in one SQL statement.

ends on the process. There are processes where multiple SQL queries come in handy. > 4.Is there any other effective SQL statement I can get better > processing efficiency? The beast way would be to start reading the optimization of MySQL: http://dev.mysql.com/doc/refman/5.0/en/opt

Re: Strange "Illegal mix of collations" error

ror: Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin2_czech_cs,IMPLICIT) for operation '=' I don't know where latin2_general_ci collation comes from. Well one table or the column has this collation. Check your structures. => `VnitrniCislo` char(15) character set

Re: Weird error when creating a field

this before? Thanks, James # perror 13 Error code 13: Permission denied Sure the own and group os mysql?? Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

Re: Docs team looking for tech writer

full-time work? How much money do you get for that? Who don't ppl ever tell? I don't get it. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Problem searching in grouped rows

e but that looked really false. Thanks for any replies :) Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: a tricky join

AS latest_date_on_order, SUM(amount) FROM table GROUP BY date is it that what you looked for? Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MATCH and return some text

-functions.html good luck Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question about mailing list protocals

into the archive to find my last question (which no one answered by the way :) ) Well yes. The list will kick you out after some time when you stop sending mails to it. I don't know how long it takes but the list do it. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o

Re: user can see more than it's allowed to see?

Database | +--+ | test | | test1| +--+ 2 rows in set (0.00 sec) Bing database test itself has Grants that it shows itself to everyone. You have to set this in the table database. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- M

Re: About mysqldump

Jørn Dahl-Stamnes schrieb: Is it possible to get mysqldump to include rights that has been GRANTED to a database or to tables in the database that is being dumped? Dump the Grant tables? -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing

Re: Disaster with dash on mysql cli interface

f you are luck it is an old one and easy restoreable. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem searching in grouped rows

Barry schrieb: Hello everyone! I have a problem with matching in grouped rows. I have: - one DB with customers - one DB with advertisement articles - one DB that holds what customer got which article the linked DB looks like: CREATE TABLE adverticlelink ( c_id int(11) NOT NULL, aa_id int

Re: Problem searching in grouped rows

_id FROM adverticelink AS a1 LEFT JOIN adverticelink AS a2 ON (a1.c_id=a2.c_id AND a2.aa_id=6) WHERE a1.aa_id=4 AND a2.aa_id IS NULL That should work in 3.23. Yeah i know where you want to go to. This looks really good, never thought about rejoining the table. Thanks for that reply,

Re: your chance

Jad madi schrieb: Same here On Mon, 2006-06-26 at 06:46 -0300, João Cândido de Souza Neto wrote: I read that message and had no feelings. <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] Please, read and let me know what do you feel I feel sad. There was no message ;_;

Re: Newbie - CREATE VIEW Question

-- site1, XYZ, (M,P) site2, RSQ, (Q,Y) where all the related column data in the second table is placed in another column. How can I do this? Is there a function that can group these values into one variable or array? Thank you CONCAT_WS(', ',siteID,name,data) Barry -- Smileys ru

Re: array type

Nolan Rumble schrieb: mm.. I'm not sure what you're trying to achieve here? Why do you want an array in there? I'm pretty sure it's not possible (correct gang?), but I'm wondering why you'd want that. What you *can* do is just store a serialized array in a textfield. What i'm trying to do is

Re: Newbie - CREATE VIEW Question

tables. I'm not here for doing your or his work! Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: Sorry but you want me to write the whole SQL query? He has to use his brain. Grouping and joining the tables. I'm not here for doing your or his work! Barry, I agree that it's often better to point someone in the right direction rather than just writing the quer

Re: Newbie - CREATE VIEW Question

elped him at all, too. Yes, I know my post didn't answer the question either :) I mailed because I thought you might've misunderstood the original question and thought it was just about how to concatenate two strings, rather than the more difficult joining part. Well more dif

Re: NDB API Guide

/doc/#ndbapi Regards, Stefan Good work :) Keep it up ! You guys are really doing great ;D With high regards Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscr

Re: See lock table

closes it with the task manager then the table remains locked. Regards InnoDB and edit the MyCnf with your preferred values. Greetings Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http

Re: space usage

with NOT NULL using 0 and '' as defaults? Depends on what you need! But Both is okay. "NULL" woudl just give you more free space since "NULL" don't add any bytes to the column. Greetings Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (

Re: How to log the execution time of each query

for logging every query. You can add a script to your service/software that does this. but as far as i know, there is no logging option for this. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql

Re: FULL TEXT and Asian languages

Peter Lauri schrieb: Best group member, I have a problem. I was going to use FULL TEXT search for my Thai client. It is working smooth with English text and wordings, the indexing and search works fine. The problem with Thai text is that words are not separated with a white space as in English

Re: Permissions Weirdness

Chris White schrieb: Normally I try to be as descriptive as possible with subject lines but.. not quite sure what else to call it. So basically, I was given ALL access by our sysadmin to a particular database. Now, somehow I was able to create a database and use it! It's my understanding th

Re: replication from InnoDB to MyISAM

that can't connect etc. thanks, Jeff For me it reads like "i want to replicate bananas but want to shape them like melons. The customers are confused that the melons taste like bananas" Am i correct with this? Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o

mysql naming convention

und conventions that people personally liked but no standards. Thanks for any help :) Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

Query Trouble!

I'm new to MySQL and am using version 4-1-12a on my development machine locally this query works just fine: SELECT * FROM actor WHERE id IN ( SELECT id FROM episode_cast WHERE episode_number =001) but when I try to run it from the web server which is running version 4.0.24

Re: Query Trouble!

- Original Message - From: [EMAIL PROTECTED] To: Barry Cc: mysql@lists.mysql.com Sent: Monday, October 03, 2005 9:49 PM Subject: Re: Query Trouble! "Barry" <[EMAIL PROTECTED]> wrote on 10/03/2005 04:38:48 PM: > I'm new to MySQL and am usi

Confusion over multiple table joins

`facilities`.`path`' 'FROM `'.$type.'`' 'inner JOIN `'.$link.'` ON `'.$type.'`.`id` = `'.$link.'`.`id`' 'inner JOIN `facilities` ON `'.$link.'`.`f_id` = `facilities`.`f_id`' 'where `name` like '. $name.&

Complicated select query

Subproject out of dv2 of each Project in db1? And er is it possible to have loops in mysql? Like SELECT * FROM db WHERE id = 5 STEP id +5 UNTIL id = 50 +--+---+ |id|val| +--+---+ |5 |10 | |10|xy | |15|jks| ... ... |50|763| +--+---+ and so on. Thanks for any Help! Greets Barry -- Smileys

Re: Complicated select query

|having Dinner |2005-04-12| |05|02 |having something|2005-07-17| |06|03 |My small Project|2005-02-10| |07|03 |My big Project! |2005-06-11| +--+-++--+ I hope this enlights it a bit Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o

Re: Complicated select query

|06|03 |My small Project|2005-02-10| |07|03 |My big Project! |2005-06-11| Small mistake. The project with ID 06 should have a date above ID 07. Sorry for that! -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For li

Re: Is mysql support ipv6?

zhengjc wrote: > I am very sorry for ask the question. > > I want to know mysql support ipv6 or not > if support, which is the version from > > best regards! > > Here, this might help: http://www.ngn.euro6ix.org/IPv6/mysql/ Regards Barry -- Smileys rule (cX

Re: mysqlcc temp table created for queries

what does 'test.1' refer to. "Test.1" is table "1" of the Database test. database test Table {1} Table {anyname} Table {insertnamehere} Like: SELECT * FROM 1 i can't tell you what exactly is causing that error but i think somewheer in that code there is a bu

Re: mac() from a subset

Sandy wrote: Hi select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4 from table How can I extract a max value from the 4 columns of the result ? ex: greatest(nf1,nf2,nf3,nf4) Thanks SELECT MAX (max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4) AS max

Re: Multiple-Master Replication recovery

plication" Do you want to have the server with the new disk behave again as the replicant? Normally you can switch it on demand but yeah i would prefer to shut it down and start it after you have set it up. Regards Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o

Re: Delete Duplicates

Rich wrote: Hi there. Any quick way of killing duplicate records? Cheers Subqueries probably. -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

Re: TIMESTAMP field not automatically updating last_updated field

Hank wrote: Are the other fields in the update statement actually changing the data? I don't know for sure, but if the data on disk is the same as the update statement, mysql won't actually update the record, and therefore might not update the last_updated field also. Just a thought. It's true

Re: MySQL Error

ce/instructions please? 1. Give us more info about the MySQL version, Type of Board and any other Info you can get helping find that Error causing Problem. 2. Adress us as Humans not as a software 3. Let somone else, who might have knowledge of coding, have a look at it. Greets Barry -- Smile

Re: Password expire?

NiCK Song wrote: Hi, experts How can I make mysql database users password with expire date? Does mysql can do it? -- NiCK Set a DATE field with the time of expire. Then do something like SELECT * FROM users WHERE datefield_of_insert > CURDATE(); HTH Barry -- Smileys rule (cX.

Re: Slow query log

Mechain Marc wrote: Hi, Thank you for your answer. But is there a chance to be able to do it one day? I think it could be a nice feature. Marc. That should be asked to one of the devs. Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL

Re: Thank you MySQL Cluster

SQL Cluster. :) http://lists.mysql.com/ There you can unsubscribe from any list you don't want to be in anymore. Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

Re: Many Attributes Required Design Query

Mark Sargent wrote: Hi All, I have the job of creating a DB for an online clothing company. I have some experience with relational design and sql and php. I'm stumped as they have products that contain numerous attributes, and are wishing to get away, if possible, with entering separate recor

Re: very long query for such a simple result

Ed Reed wrote: That's not really what I meant. I know what the function SUM() does. But Sum() takes an expression and '1' doesn't seem like much of an expression to me. So what is that 1 equates to and where in the MySQL documentation can I find this explained. Thanks again. It doesn't car

Re: need to select correct package

(x86) downloads http://dev.mysql.com/downloads/mysql/5.0.html Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   >