 | | | MySQL General | | I may have just solved my own problem
SELECT DISTINCT(SUBSTRING_INDEX(INET_NTOA(IP_Addr) '. ' 3)) as niceip FROM
IPTable HAVING niceip LIKE '192.168.15% '
http //dev.mysql.com/doc/refman/5.0/en/stI have a table of many IP addresses. I 'm doing some PHP/JS/AJAX to populate
a select box based upon what someone types in a search field. That works
great except that a user can spend a lot of time gI have a similar desire like my first question regarding a DATETIME field. I
have a DATETIME field in my db that I would like to DEFAULT to the exact
value of another DATETIME field in the same table.Hi Sheeri
> So I 've seen replication break a few times due to duplicate queries.
> A few times it was around a server crashing but I thought perhaps it
> was because of the crash. (ie master sendHi
This is driving me crazy. When we were using MySQL 4.0.x we could create
a shared library with libmysqlclient.a bound in.
With MySQL 4.1 onwards we get the error
/usr/ccs/bin/ld Invalid loadeDear All
Need to find ids that are NOT in other two tables. With the help of PHP scripting and three queries I am able to do the task. Can this be done with one mysql query?
Below are Hi Daniel.
Distribute it under the CC license?
http //creativecommons.org/about/licenses/index_html
Keith
In theory theory and practice are the same
in practice they are not.
On Fri 19 May 200On 5/19/06 Lyle Tagawa <Lyle.Tagawa@(protected) > wrote
> Given a nptl/linux box (or pthreads/freeBSD) for example can you tell
> what is the theoretical max running thread count (in the context of
> Hello Mark
> 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_Mac OS X 10.4.6 (Tiger) MySQL 5.0.21.
Hi folks. I 'm needing to start up my general query log to see what 's
ticking me off.
I 've looked into safe_mysqld but it 's confusing as ... something
thatHi
Recently I created a new replication set up with 5.0.18-standard-log on Solaris 8 (one master one slave).
Replication is running but periodically (after a bunch of INSERT/UPDATE statements) thDid you successfully alter the table? What does SHOW CREATE TABLE give you?
mysql > CREATE TABLE test ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
PRIMARY KEY ts_create TIMESTAMP DEFAULT CURRENT_TI 've 3 machines that I use with mysql. One is used for BI consulting and
other two for operational consulting. Which one is indicated to be an
master server ? Is there possible with 2 nics in machiHello everybody!!
I 've a problem synchronizing a master mysql to a slave
When my master make a rotate in binlog my slave can follow up it and catch.
What should I do ?
--
Mysql 4.1.16 running on Fedora Core 4 (Linu) X86_64 with InnoDB tables
I have a table called which has a (combined) primary key of assetid and
date plus several data fields (open high low close -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
> I have column and I want to make sure the db is always making sure the
value
> that gets input into this VARCHAR() column is always lowercase
>
> Is there a way to set the value of a column withiI think you might consider refactoring your code to use a hybrid of Nested
Sets and Adjacency List.
It 's fairly trivial to add a 'parent_id ' to the nested set so you really
don 't loose any of your eAt 15 55 -0500 5/18/06 Steve wrote
>Hi everyone...
>
>how do I enter html code into my database???
Like any other string.
--
Paul DuBois MySQL Documentation Team
Madison Wisconsin USA
MySQL ABOn 5/18/06 Dan Trainor <dan@(protected) > wrote
> Hi -
>
> I 'm trying to import some data into a MySQL database which was dumped
> from mysqldump. Just looking at the .sql file generated there 's onlYou have to change the delimiter you use otherwise MySQL treats the
as the end of the line and processes the commands. When I tried to
run your trigger (with the standard delimiter of ) I got
EPeter
>Right now I am doing this with PHP and a recursive function but is it
>possible to do this directly with one query?
SQL is not recursive so you need an sproc. There are some examples witDoes mysqlcheck sometimes repair problems that it does not report? I 've
seen a few instances where running mysqlcheck -r -f fixed application
problems even though it reported all tables "OK. "
--Eric
When I do this the query browser pops up with a select * from table query
which is executed on my behalf revealing my data. All I have to do is press
the edit button (assuming the result set is editBob
>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).
In a valid-time app like yoursOn 5/18/06 Dominik Klein <dk@(protected) > wrote
> Hi
>
> for recovery purposes I need to know what exactly is in the master.info
> file. Especially the log position. Is it Read_Master_Log_PosHi all
I am trying to install syslog-ng + phpsyslogng in Linux box. Syslog-ng is
working properly. It pipes all the log messages to a pipe file mysql.pipe in
sql statement format.
But now the problWell it 's documented here
http //dev.mysql.com/doc/internals/en/flush-tables.html
"Every time a thread releases a table it checks if the refresh
version of the table (updated at open) is the samehi all
I have got a problem.I have data entered in different machines in a
database now i have got all the data in different .sql files.Now i was
importing the same files in order to merge them in In the last episode (May 18) Jim said
> Is there any way of getting the max_allowed_packet setting via a SQL
> statement?
mysql > SHOW VARIABLES LIKE 'max_allowed_packet '
+ |
|
|
