>CREATE TABLE relay_ip (
> rei_aid int(11) NOT NULL auto_increment,
> rei_uname varchar(30) NOT NULL default '',
> rei_domain varchar(128) NOT NULL default '',
> rei_ip varchar(64) NOT NULL default '',
> rei_ts datetime NOT NULL default '00
help?
>
>I even tried to run the compiled version of
>"simple1.cc" (present in mysql++-1.7.9/examples). But
>it said :
>*
>ld.so.1: simple1: fatal: libmysqlclient.so.10: open
>failed: No such file or directory
>Killed
>**********
&g
>
column1 REGEXP "[0-9]"
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
--
thing else... ;-)
Anil Garg wrote:
>hi
>What version combinations of mysql and php should be used?
>regards
>anil
>
>
>
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL
:" pwd >"/tmp/mail.txt";
print "" >"/tmp/mail.txt";
print "Be aware that your password will be saved in an encrypted
format, so noone can read it!" >"/tmp/mail.txt";
close( "/tmp/mail.txt");
cmd = "cat /tmp/
e done this for some time and nothing has gone wrong, no data corrupted
>either. Running source compiled 4.0.2-alpha:
>Uptime: 70 days 6 hours 42 min 24 sec
>Threads: 11 Questions: 215514424 Slow queries: 613 Opens: 87 Flush
>tables: 1 Open tables: 59 Queries per se
>>>
>>> log=/var/log/mysqld.log
>>> ---
>>>
>>> MASTER-->
>>> [mysqld]
>>> socket=/var/lib/mysql/mysql.sock
>>> server-id=1
>>>
>>> log=/var/log/mysqld.log
>>> log-bin
>>>
&
the outer while. Use a different variable for the inner handle. In the
inner while you already fetched all rows for sth returning to the next
outer loop will fail.
> $sth->execute || &error("Fout bij het communiceren met de database:
>$DBI::errstr");
>$sth->bi
ave a site with some
>databases to administer
>
Sounds evil indeed, how about giving grant rights and revoking insert
rights for mysql.users mysql.db and mysql.table?
Greetings
Ralf
>
>
--
Ralf Narozny
Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten-
management oder das komplette
---+---+--+--+
>
> 1 row in set (0.00 sec)
>
As far as I can see the message is quite obvious: On your replication
machine the table radcheck has no column of the name 'status'
--
Ralf Narozny
Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten-
m
deas?
>
>
Sure, simply leave the brackets away.
Greetings
Ralf
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
-
d no makefile found. Stop.
>>[root@neelsl mysql-3.23.51-pc-linux-gnu-i686]# make install
>>make: *** No rule to make target `install'. Stop.
>>
>>What is the problem, I am following the instructions provided in the
>>
>&
an:
>
>select something from table where index1 = 'value';
>or
>select something from table where index2 = 'value';
>
>
Does it have a compund index, created like this:
CREATE INDEX myindex ON table (index1,index2);
???
Greetings
Ralf
--
Ralf Narozny
SPLENDI
0 records. I don't want to loose any of my current data in this
>column.
>
>
>
Greetings
Ralf
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROT
FAIK there is no way to automaically set the value via DEFAULT, since
DEFAULT has to be constant and since there are no triggers by now, try:
INSERT INTO table VALUES (a,b,a*b);
Greetings
Ralf
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon:
might be sufficient (it is,
if after compiling there is a directory where my.cnf resides)
Greetings
Ralf
sql query
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49
ise an error or just delivers 0 rows or wrong rows? Without
that information I wouldn'T even try to take a look at that query ;-)
Greetings
Ralf
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109
ADD COLUMN Full_name int AFTER ID;
UPDATE test SET Full_name = Name;
ALTER TABLE test DROP COLUMN Name;
Greetings
Ralf
sql query
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660
t1.ProductID,
' WHERE UserID = ',
t1.UserID,
';'
)
INTO OUTFILE
'/tmp/update.sql'
FROM
Table1 t1
LEFT JOIN Table2 t2 ON (t1.Old_UserID = t2.UserID)
WHERE
t2.UserID IS NOT NULL
;
\. /tmp/update.sql
This might help...but b
gt;
>>To unsubscribe, e-mail
>>
>>
><[EMAIL PROTECTED]>
>
>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
>>
>
>
>-
>Before
the word within the
> field.
WHERE field LIKE '%keyword%'
maybe
WHERE upper(field) LIKE upper('%keyword%')
Greetings
Ralf
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto
eck:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try
r ammount of data (1800 records) it takes 26 seconds to
>return data and it consumes 100% of processor. This situation happens when I
>have all tableA.id registered on tableB.ida or tableC.ida.
>
>Any ideas?
>
>
>
Of course you have indexes on all of the id, idA, idB columns?
Gre
$q);
$q .= ")"
print $q."\n";
##
sh -c test.pl < -
Dogs
Cats
Fish
^D
This would print something like:
INSERT INTO tab VALUES ('Dogs','Cats','Fish')
Greetings
Ralf
>
>
sql, query
--
Ralf Narozny
database developers use lengths to restrict the size of the entries. For
example storing the zipcodes from more than one country might need at
max 15 characters, so why allowing 255, preventing MySQL to raise an
error, if the ZIP is 100 chars long.
Greetings
Ralf
--
Ralf Narozny
SPLENDID Inte
BTW the processing time was about <1 second for the new syntax and up to
30 seconds for the old method.
(Tables had about 300.000 - 1.000.000 rows)
Greetings
Ralf
sql sql sql sql sql sql sql sql sql sql sql sql sql
query query query query query query query query query query query
P.S.:
line 33."
>
>
Is it possible that the connect() did not succeed? that would explain
why $dbh->prepare() would not work.
>I don't know why this is happening, although I have read as much as I
>could fine on the net regarding this subject.
>I'd be grateful for any hel
erver as the MySQL is running?
And maybe change the line:
$dbh = DBI->connect($connectionInfo,$userid,$passwd);
to:
$dbh = DBI->connect($connectionInfo,$userid,$passwd) or print "Connect failed";
Maybe you get the info then.
>
>
>Ralf Narozny wrote:
>
>
>>
s makes some sort of sense.
>
>
Greetings
Ralf
>
>
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.
/share
--includedir=/usr/include --with-extra-charsets=complex
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-libwrap
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
&
ee.cgi line 33."
>
>
Is it possible that the connect() did not succeed? that would explain
why $dbh->prepare() would not work.
>I don't know why this is happening, although I have read as much as I
>could fine on the net regarding this subject.
>I'd be gra
lib
>--libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man
>--prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --without-debug
>--datadir=/usr/share --includedir=/usr/include --with-extra-charsets=complex
>--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-lib
http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
makes some sort of sense.
>
>
Greetings
Ralf
>
>
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
ry at /var/lib/mysql/poll !
>So, can you help me ?
>
>
Maybe stupid question, but you issued 'CREATE DATABASE poll;'?
Greetings
Ralf
sql , query
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0,
pening.
>When both are in sync then take them down and point allupdating
>clients to the new database machine.
>
>Any comments ? Converting the tables "in situ" is painfully slow - a
>couple of days I suspect.
>
>
Greetings
Ralf
>
>
--
Ralf Narozny
SPLENDID Intern
py line 8.
>
> What is DBI.pm?
DataBase Interface . Perl Module (iirc)
which indicates that you need Perl DBI Module for mysqlhotcopy.
Greetings
Ralf
sql , query
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fa
>>application with this account, I should have the same access through
>>>
>>>
>JDBC.
>
>
>>>2) Does this mean I have to use an account which has a global access
>>>privilege(s) in order to access the db through JDBC??
>>>
>>>
.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
--
Ralf Narozny
the result will have, I
>think there must be a better way to do it, isn't it?
>
>
No way! Should the database guess on it? ;-)
SELECT count(*) FROM ... WHERE ...;
Just like your query looks like is the only way.
>
>
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Ska
>+--+
>|[EMAIL PROTECTED] |
>|[EMAIL PROTECTED] |
>|[EMAIL PROTECTED] |
>+--+
>
>
How about:
UPDATE SET id = concat(left(id, locate(id, '@')), 'domain2.com')
WHERE domain = "domain1.com";
--
Ralf Narozny
SPL
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-m
---
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble
t;Is
>>
>>
>>>it
>>>
>>>
>>>>possible to get that result in just one query?
>>>>The result should be something like this:
>>>>
>>>>event_id time
>>>>1012000-10-24
>>>>1012000-10-25
>>&g
/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
&
t;> server-id = 3
>>
>> master-host = spiderman.terravista.srv
>> master-user = replica
>> master-password = x
>>
>> ***
>>
>> Any suggestion?
>>
>> Thanks in advance.
>>
>> Sa
machine, is there any options
>so that the same entry is made in the remote machine mysql db
>If there is any option pls. let me know
>Thanx in advance
>
>
>
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fa
>>
>>>
>know
>
>
>>>how to get the time column in the same query.
>>>Here is my current query:
>>>
>>>SELECT
>>>event_id,
>>>count(DISTINCT time) AS Ranges
>>>FROM
>>>events
>>>
he result at defined word borders (for
bash that is maybe true for ksh clones too)
for EMAIL in `cat remove.txt` ; do echo "DELETE FROM churchmail WHERE
email = '$EMAIL';" ; done | mysql midtn
that was it...pretty easy isn't it? That's why I really love Linux :-)
Gre
Using Linux/Unix I'd say:
echo "SELECT concat('DELETE FROM mailtab WHERE
mailaddress=',mailaddress,';') FROM mailtab WHERE " | mysql | mysql
[EMAIL PROTECTED] wrote:
>I have about 40,000 email addresses in a MySQL database.
>
>I also have a list of 1500 email addresses that need to be remove
I don't run the risk again of having
>googlebot or other web robots interrupt my other server operations in my
>computer.
>
>Thank you
>
>Edwin
>
>
sql query
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 4
Hello!
The subject says it all: What rights does a user need to have (minimal
rights of course) to be able to execute PURGE MASTER LOGS command?
Thanks in advance
Ralf
For the poor little filter: sql query
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109
ists.mysql.com/php/unsubscribe.php
>>
>>
>>
>
>
>-----
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http
e alternates..
>
>Regards,
>-Arul
>
>
>
--
Ralf Narozny
Splendid Internet GmbH
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
--
could have a join
> between the main table and the inner table.
>
> Is this advisable..
>
> Any other better options?
>
>
>
--
Ralf Narozny
Splendid Internet GmbH
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 43
command-line tool ...
>>
>> I think I can overwrite this parameter within a .my.cnf.
>> what do I have to write in the ~user/.my.cnf to use completion ?
>>
>> I tried in the [mysql] section:
>> auto-rehash
>> rehash
>
Solution:
simply delete the l
without a table in between, you got a nice OS for that.
I'm using bash doing like this:
echo "SELECT concat('DELETE FROM order WHERE order_no=', order_no, '
LIMIT 1;') FROM order GROUP BY order_no HAVING copunt(*) > 1" | mysql -N
-u | mysql -N
uld delete both of them.
>
>
delete from where limit 1;
would only delete one of the rows at least in 3.23.40+ it does :)
--
Ralf Narozny
Splendid Internet GmbH
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED]
LEFT JOIN builder_category bc ON ( b.id = bc.builderid)
LEFT JOIN category c ON ( c.id = bc.builderid )
;
That should give out all names from builder which have any business given.
Greetings
Ralf
--
Ralf Narozny
Splendid Internet GmbH
Skandinaviendamm 212, 24109 Kie
Jay Blanchard wrote:
>[snip]
>I am trying to get only records out of a table mathing a query. This should
>be piped into a textfile. My problem is that I have to transmit this records
>to a new machine. So the output should be a kind of sql commands which I
>could run with phpadmin or similar t
61 matches
Mail list logo
