Re: Index and multiple fields

Hi, Mark! Of course, it depends on queries you are running. I beleive you can find all anwers here: http://dev.mysql.com/doc/refman/5.0/en/indexes.html http://dev.mysql.com/doc/refman/5.0/en/multiple-column-indexes.html http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html Markus Fischer

Re: getting table metadata

Try DESC table_name. Yves Glodt пишет: On Friday 17 March 2006 15:52, Martijn Tonies wrote: Hello Yves, Hello Martijn, is it possible to get information about tables by doing queries on some system tables? I am using mysql version 4.1.11 on debian sarge. In my case I need to know which

Re: mysql.sock gone

Look at mysql's error log ($MYSQL_DATA_DIR/$HOSTNAME.err). Do you see anything strange there? Anton Krall wrote: No crons that would delete the tmp directory.. In fact, all the other files stay there... Just mysql.sock goes away... |-Original Message- |From: Logan, David (SST -

Re: Permissions block database creation

User ''@'localhost' just hasn't enough privileges to create databases. http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html Doug Pinkerton wrote: I'm a total newbie working through the tutorial in DuBois's _MySQL_. I've got MySQL running on my PowerBook. In Terminal, I can use the

Re: missing mysqld.sock

Hi, Jon. mysqld.sock is a unix socket. mysqld creates it while starting and removes it when you stop the server. Jon Miller wrote: Is there a way to recreate the mysqld.sock file, it has gone missing from :/var/run/mysqld . Now MySQL will not run. Thanks Jon L. Miller, ASE, CNS, CLS,

Re: ~~Info needed~~

Hm... It seems to me In MySQL there's no such thing as database owner. Or am I missing something? Mohammed Abdul Azeem пишет: Hi, How to check for the database owner for a particular database ? The way show procedure status command lists the definer column, Is there a command that shows the

Re: offset or skip_count

Hi, Rich. What is skip_count? I couldn't find any reference to it in mysql documentation. I'm not sure I understood your question, but I beleive you're asking for LIMIT modifier. SELECT * FROM $table LIMIT $offset, $record_count; or SELECT * FROM $table LIMIT $record_count OFFSET

Re: selecting records newer than say 20 min

Hi, Gregory Hmm.. I think you just should add something like 'create_time DATE_SUB(NOW(), INTERVAL 20 MINUTE)' to a where clause of your query. Or something similar.. You can find more at http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html. Also consider creating of an

Re: Select IP from Text Type

Hi, Ron. I think REGEXP can help you.. http://dev.mysql.com/doc/refman/5.0/en/regexp.html Im trying to select an IP from a TEXT (details) type field, which works if I do this: select id from `table` where `details` like '%192.168.0.1%' : But If I want any record with an IP in that TEXT

Quoted DB name in USE statement.

Hi, List! First of all, what does mean 'log' suffix in version name of MySQL server? I have some problems with MySQL server 4.0.25-log (Don't say that I should update it. I don't have such privileges, so I have to deal with it). Server doesn't understand quoted DB names in USE statement.