You guys are incredibly naive, Oracle has promised to support MySQL for
the next 5 years. Who better to have stewardship of a database product
then the leading database supplier. I think you guys have visions of
grandeur to think you could spend this kind of effort or resources to
build a bett
h... All this is what might happen...that true...But yet I do not
see anyone willing to put up anything to support mysql... you don't like
it... put up a billion dollars an take control or shut the heck up!
Doug
Ryan Chan wrote:
On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman wrote:
s? I am trying this
from the machine locally so I would assume localhost works fine...
--
<http://sfp.central.sun.com/> * Douglas Nelson *
Senior Technical Consultant
*Need Sun JES Help?*
Software Field Practice
Phone +1 877-234-2879/x51438
Mobile 919-259-3719
Email sfp-h...@s
works with 5.x. I'd prefer to get the
XQuery functionality with the 4.1 is at all possible. Any resources anyone
can point me to?
Thank you!
--
Douglas A. Whitfield
Co-Founder Carolina Open Source Initiative
http://www.ibiblio.org/cosi
http://www.last.fm/group/Carolina+Open+Source+Initi
Sorry if this is a dumb question, but are SQL transactions in MySQL atomic?
I'm using InnoDB tables in MySQL5.
Clearly, transactions have the property that either all updates occur or
none do. By atomic, I mean are other queries guaranteed to either see all
changes from the transaction or none of
I installed MySQL on Fedora 6 and simple queries are very slow.
I have ten databases with very few hundred records and there are only a few
hundred records in the table I am querying. I only have this issue on
Fedora ONLY. The same query on on my Windows machine is as expected.
What can I d
s data).
Doug
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 23, 2007 2:02 PM
To: 'Douglas Pearson'; mysql@lists.mysql.com
Subject: RE: Dynamic tables--always a bad idea?
How are you going to do queries that join or merge thousands of tables? o
We're trying to figure out how to design a particularly critical table in
our database schema. The choices are to use a single large table or a
series of dynamically created small tables.
This table will receive the majority of traffic (queries and updates) in the
database so it's a key part of t
We solved it here,
There was a problem in the query, we removed the "t1" at the 'group by'
section. The problem was really a sintax error in the code not in the
server.
Thanks,
Douglas
2007/7/19, Michael Dykman <[EMAIL PROTECTED]>:
instead of leaving it in PHP, p
Hello everydoby,
I'm having a problem executing a query in the MySQL server version 4.1, the
same query works fine in my other server with MySQL version 4.0.
My PHP code is attached, and the query is one on the line 13.
Please somebody help me,
Thanks,
Douglas
dbFlashDadosSonabr
Thanks for the help Michael,
The data directory is really configured to /var/lib/mysql, and the
database name is area2.
I'm mounting the subdirectory of the database.
When I mount the nfs file system I don't get any error.
Thanks,
Douglas
2007/7/6, Michael Dykman <[EMAIL PROT
mysql 0 Mai 22 2006
/var/lib/mysql/area2/tabUsuario.MYD
-rw-rw 1 mysql mysql1024 Mai 22 2006
/var/lib/mysql/area2/tabUsuario.MYI
These was the results, I will look up for the informations of the user
mysql on the storage.
Thanks for the help,
Douglas
2007/7/6, Michael Dykman
There is no error in log file, the server just don't show me the
database on the directory /var/lib/mysql/area2. If I go in this
directory with the cd command and give a "ls" command, I see the
files, but the mysqld don't recognizes the database files.
Thanks,
Douglas
20
abase.
Anyone can help me?
Thanks,
Douglas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks Mogens. I was aware of REPLACE but it was the non-standard ON
DUPLICATE KEY UPDATE that I was looking for.
Thanks,
Doug
-Original Message-
From: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 2:28 AM
To: Douglas Pearson
Cc: [EMAIL PROTECTED]
Subject: Re
Apologies if this is a dumb question, but is it possible to write a single
query that either updates certain columns in a row, or adds an entirely new
row if there is none already?
I seem to be running into this a lot, and so far I've solved it by:
1) run UPDATE table SET x,y WHERE some row
2) if
ev.mysql.com/downloads/gui-tools/5.0.html and then from
the MySQL Administrator program, choose "Backup".
Good luck. I use a MacBook Pro for MySQL work also (mostly
developing things that will run on a linux server) and I have been
very pleased with it.
Douglas Sims
[EMAIL PRO
rans AS t2 ON t1.product_code = t2.product_code AND
(t1.date_sold < t2.date_sold OR (t1.date_sold=t2.date_sold AND
t1.id
WHERE t2.product_code IS NULL
ORDER BY t1.product_code;
Douglas Sims
[EMAIL PROTECTED]
On Sep 28, 2006, at 10:12 AM, Peter Brawley wrote:
Mike,
What I need to d
|
+-------+
1 row in set, 1 warning (0.00 sec)
Douglas Sims
[EMAIL PROTECTED]
On Sep 27, 2006, at 10:24 PM, [EMAIL PROTECTED] wrote:
I am looking for any suggestions to this problem. I have a table
with a
varchar field. This field can hold textual or numeric data, but it is
st
| -51.04|
| 39 | 2005-07-31 | 1191.00 |
| 40 | 2006-05-29 | 65.00 |
+-++---+
53 rows in set (0.52 sec)
Douglas Sims
[EMAIL PROTECTED]
On Sep 27, 2006, at 11:36 PM, mos wrote:
This should be easy but I can't find a way of doing it in 1 step
I think you have to specify a key length when you use an index on a
text field...
mysql> alter table t2 add index i2(t1(3));
That would create an index (called "i2") on the first 3 characters of
field "t1" of table "t2".
I think that's right?
Dougl
ystem variable to a nonzero value. See Section 5.2.3, “System
Variables”, for more information.
There is also a very thorough article discussing stored procedures in
MySQL which gives an example of tree traversal here:
http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html
Do
re the value is exactly 100.
That would be the row with id=7.
Here is a query which will give you that: SELECT * FROM tbl_name
WHERE total=100 ORDER BY id LIMIT 1,1
Douglas Sims
[EMAIL PROTECTED]
On Sep 24, 2006, at 3:27 PM, Ahmad Al-Twaijiry wrote:
Hi
I need the result to be 100 not to mo
T)
The easiest way to do this, of course, is as a subselect of another
query but you could also do it in the perl/python/php/whatever layer
which is sending this query to the database.
Can you send a transcript of what you tried, including the "SHOW
CREATE TABLE" statement?
D
(0.32 sec)
mysql> select column_name from information_schema.columns where
table_schema='test' and table_name='t';
+-+
| column_name |
+-+
| TransactionDate |
| amount |
+-+
2 rows in set (0.08 sec)
Douglas Si
It will probably work better if you put the triggering code in the
part of your application (like the PHP page, whatever) that changes
the data you want to be notified about, instead of in the database
itself.
Douglas Sims
[EMAIL PROTECTED]
On Sep 21, 2006, at 3:14 PM, Dave at Mysql
amount1 | tot1 |
+-+--+
| 178 | 198 |
| 32.43 | 230.43305176 |
| 3 | 233.43305176 |
+-+--+
3 rows in set (0.00 sec)
Good luck!
Douglas Sims
[EMAIL PROTECTED]
On Sep 19, 2006, at 4:02 PM, Quentin Bennett wrote:
No, I
You might also look at TRUNCATE table...
http://dev.mysql.com/doc/refman/5.0/en/truncate.html
I believe that DELETE will not reclaim the storage space while
TRUNCATE does, although I didn't see that in the documentation when I
looked just now... ?
Douglas Sims
[EMAIL PROTECTED]
O
ES | MUL | | |
| address | varchar(32) | YES | | | |
+-+-+--+-+-+---+
3 rows in set (0.00 sec)
Here is the mysql documentation on ALTER TABLE: http://dev.mysql.com/
doc/refman/5.0/en/alter-table.html
Douglas Sims
[EMAIL PROTECTED]
I wonder if the reason for the 20-second SELECT COUNT(*) which you
are seeing might not have more to do with memory allocation on the
server? Or perhaps Dan's suggestion that the InnoDB primary index
holds the entire row might be the clue. How big are your rows?
Note to self: stop
ction; if you created a second statement handle and did a
SELECT FOUND_ROWS() on the same connection, perhaps that would give
what you want.
Douglas Sims
[EMAIL PROTECTED]
On Sep 6, 2006, at 11:29 PM, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
Hi Dan,
Thanks for yur
, INTERVAL 7 DAY);
+++
| name | birthdate |
+++
| Keanu Reeves | 1964-09-02 |
| Fred MacMurray | 1908-08-30 |
+++
2 rows in set (0.00 sec)
Good luck!
Douglas Sims
[EMAIL PROTECTED]
On Aug 29, 20
Much better. Good job.
Douglas Sims
[EMAIL PROTECTED]
On Aug 29, 2006, at 1:26 AM, Johan Höök wrote:
Hi Ravi,
you can take a look at:
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
which might take care of your problem.
/Johan
Douglas Sims skrev:
Hi Ravi
You are
| 7 |
| Amy | 9 |
| Doug | 22 |
| Susan| 4 |
| Tom | 2 |
| Jim | 8 |
| Elaine | 5 |
+--+----+
8 rows in set (0.00 sec)
Good luck!
Douglas Sims
[EMAIL PROTECTED]
On Aug 29, 2006, at 1:01 AM, Ravi Kumar. wrote:
Hi Douglas
v.mysql.com/doc/refman/5.0/en/replace.html
Good luck!
Douglas Sims
[EMAIL PROTECTED]
On Aug 29, 2006, at 12:08 AM, Ravi Kumar. wrote:
Dear Members,
I wish to insert and update conditionally into a table using a
single SQL
statement. That is if a record already exists in a table, the
s
I was lucky enough to have gotten a copy of MySQL 10 (aka MySQL X)
from the source tree before it was pulled.
The query optimizer used predictive algorithms with temporal
displacement logic, which meant that it could and did frequently
return results in negative time, before the query was
XP '^[A-E]'
You can read more about MySQL regular expressions here: http://
mysql.com/doc/refman/5.0/en/regexp.html
Also, are you using spellcheck with Outlook Express? Because if so,
Microsoft keeps trying to rename "MySQL" to be "Myself." I think
they want
were doing what you describe I would use HTTPS and put
both the un/pw and data in the body of the request, rather than
trying to send one request to get a cookie and then use that cookie
to send the actual data.
Douglas Sims
[EMAIL PROTECTED]
*er, did I state that correctly?
On Aug 16, 2
D'oh. Very good. I wish I'd thought of that.
In response to Michael DePhillips' point about the UDF - I believe
that in MySQL 5.x UDFs can't query tables. In Oracle, SQL Server,
etc. they can and I'm sure they will in the future.
Douglas Sims
[EMAIL PROTECTED]
CTED] LIMIT 1;
SELECT * FROM t WHERE id>(SELECT MIN(id) FROM t WHERE id>@id) ORDER
BY id ASC LIMIT 1;
But as to putting that in one statement... it might be better just to
do it as three.
Douglas Sims
[EMAIL PROTECTED]
On Aug 14, 2006, at 9:32 AM, Michael DePhillips wrote:
Hi
ns.id=user_permissions.permission;
If you've never read Donald Knuth going on about Literate Programming
you might check this out: http://www-cs-faculty.stanford.edu/~uno/
lp.html
Just like with parenthesis styles, you can name database objects
whatever you want and it will still
Can you do a "show processlist" from the MySQL client? This might
help you to figure out if it is a specific query that's gumming up
the works.
Douglas Sims
[EMAIL PROTECTED]
On Jul 19, 2006, at 6:35 PM, Robinson, Eric wrote:
Our MySQL-based medical application has be
Those are the files which contain the data in each table in your
MySQL databases. I think the .myd files contain the data, the .myi
files contain indexes, and the .frm files contain schema information.
Douglas Sims
[EMAIL PROTECTED]
On Jun 30, 2006, at 11:47 PM, Octavian Rasnita wrote
lly's DB or use flat files written in Mandarin Chinese for all I
care) for less money than we will spend on software on one upgrade
cycle?
Does anyone else have similar experiences?
Douglas Sims
[EMAIL PROTECTED]
On Jun 7, 2006, at 11:15 PM, Douglas Sims wrote:
Ouch.
Thanks fo
reat support MS SQL had - I quickly agreed and said that MS SQL had
the best support we could ever ask for... it's called "Google."
Randy still paid for the lunch :-)
Douglas Sims
[EMAIL PROTECTED]
On Jun 7, 2006, at 10:20 PM, mos wrote:
At 08:15 PM 6/7/2006, you wrote:
or indexes from the original
table. If you need to do this, you can do it by using the mysqldump
program to dump the table (just the structure or the structure and
data) from the original database and then load it into the new one:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
G
cellent product. So even if you don't
need the commercial license, if your company depends upon MySQL,
buying a commercial license, paying for training, attending
conferences, or buying lots of t-shirts is nice.
Douglas Sims
[EMAIL PROTECTED]
On Jun 7, 2006, at 7:58 PM, Logan, Dav
|
| CHECKSUM| bigint(21) | YES | | | |
| CREATE_OPTIONS | varchar(255) | YES | | | |
| TABLE_COMMENT | varchar(80) | NO | | | |
+-+--+--+-+-+---+
21 rows in set (0.07 sec)
Go
---+
| 162 |
+-+
1 row in set (0.00 sec)
Here is a reference to the MySQL documentation on date and time
functions, which is really good: http://dev.mysql.com/doc/refman/5.0/
en/date-and-time-functions.html
Good
| NULL| NULL|
NULL |
| 5542 | 125| 1 | 443| NULL
| || NULL | NULL| NULL|
NULL |
+--++---++---
+---++--+-+-
as to do with meeting girls efficiently - which
is also interesting, but outside the scope of this list and not
immediately relevant to the system I'm working on.
Douglas Sims
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
st.
Maybe
I'm asking too much to find a summary of such differences. But
I'm only
interested in using mainstream sql functinality, nothing complicated.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Viruses!
www.newbreak.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Douglas Sims
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://l
ion around
http://mail.yahoo.com
Douglas Sims
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I can connect to mysql with
mysql -u dbname -p
When I start MySQL Administrator v 1.1.6 it says
Could not connect to host 'localhost'.
MySQL Error Nr. 2002
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
...then I Click on Details and enter, '/var/lib/mysql/mysql.so
?
Any tips are welcomed.
Thanks,
Douglas
Douglas S. Davis
Programmer/Analyst
Haverford College
Administrative Computing
370 Lancaster Ave.
Haverford, PA 19041
610-896-
; or 'set global variable=...'. See:
http://dev.mysql.com/doc/refman/4.1/en/system-variables.html
I strongly recommend you to upgrade.
Douglas B. Jones wrote:
> How do you up max_connections on 3.23.29 mysql? I
> have tried in the my.cnf file, command line and
> in
How do you up max_connections on 3.23.29 mysql? I
have tried in the my.cnf file, command line and
in mysql (set @max_connections=200). Thanks for
any help!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to compile mysql-5.0.15 on Solaris 5.9 with the
following options:
CC=cc;export CC
CFLAGS="-Xa -fast -native -xstrconst -mt -xarch=v9";export CFLAGS
CXX=CC;export CXX
CXXFLAGS="-noex -mt -xarch=v9" ASFLAGS="-xarch=v9";export CXXFLAGS
./configure --prefix=/usr/local/mysql --enable-asse
[EMAIL PROTECTED] wrote:
>>> speculating about that IMO.
>>
> What Oracle will do with Innobase is Oracle's matter, not much use in
>
> Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED
> how the
> environment around Innobase / Innodb will change - and with it any
> support
>
Chris Knipe wrote:
Hi,
We've just upgraded (via FreeBSD Ports) our one database from 4.1.11
to 4.1.12, and we are being hit by
http://bugs.mysql.com/bug.php?id=10674 - only on certain queries,
using rather large temp tables.
Now, from what I understand, there is a 4.1.12-1 available? Wher
Mark Hughes wrote:
A lot of the RPM's for 4.1.12 seems to have been removed from the
download page so I presume there's a known problem:
http://dev.mysql.com/downloads/mysql/4.1.html
I noticed this when I just went to download 4.1.12. What's going on? Is
4.1.12 unstable or is this strictly a bu
MySQL: 4.1.11
OS: Solaris
I have a database that stores Japanese in utf-8. I have NO problems if
the field is defined as VARCHAR, but if the field is defined as TEXT any
data after an extended character (Japanese, special symbols etc.) gets
truncated. Looking at the archives I ran the followin
Here is the script to compile 4.1.10a, it worked compiled fine
with the directory changed on 4.0.23a and before:
#!/usr/bin/ksh
PATH=/usr/local/bin:"$PATH"
export PATH
echo $PATH
D=mysql-4.1.10a
CC="cc"
export CC
CXX="cxx -O"
export CXX
cd $D
./configure \
--prefix=/usr/local/mysql-test\
tz <[EMAIL PROTECTED]>
Sent: Feb 2, 2005 10:44 AM
To: Bruce Douglas <[EMAIL PROTECTED]>
Cc: Dathan Pattishall <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Subject: Re: Social Networking querys
On Wed, Feb 02, 2005 at 10:19:45AM -0800, Bruce Douglas wrote:
> dathan...
>
> given
dathan...
given that you work at friendster, aren't you kind of restricted from
commenting on how one would go about creating/implementing this kind of system??
if you aren't and you have information to share, then we'd appreciate hearing
it!!!
regards,
bruce
-Original Message-
From
nick...
just from curiousity.. is the code that you've alluded to available for public
play. or is it yours/your company's?
thanks
bruce
-Original Message-
From: Nick Arnett <[EMAIL PROTECTED]>
Sent: Feb 2, 2005 9:08 AM
To: listsql listsql <[EMAIL PROTECTED]>
Cc: mysql
Subject: Re: S
Sent: Feb 2, 2005 9:33 AM
To: Bruce Douglas <[EMAIL PROTECTED]>
Cc: listsql listsql <[EMAIL PROTECTED]>, mysql
Subject: Re: Social Networking querys
On Wed, Feb 02, 2005 at 09:20:28AM -0800, Bruce Douglas wrote:
> hi...
>
> i'm not sure who the original poster was... but,
hi...
i'm not sure who the original poster was... but, there is also an open source
app (yogurt) that claims to be used to deal/implement a version of a foaf
system, much like okurt/google. i'm not sure how the underlying 'special sauce'
is implemented, but it might be worth checking out...
le
If I make a connection as follows:
$getcnnctd = @mysql_connect('this', 'that', 'bigsecret');
then select my db, then
$res = mysql_query("select * from thedb");
when finished using the db etc., am I assuming correctly that I should:
mysql_free_result($res); to free the memory up
and
mysql_close(
Bruce Dembecki wrote:
At the 2004 Users Conference in Orlando in April there were two sessions on
optimizing MySQL hosted by a MySQL staffer who's name eludes me for the
moment.
Peter Zaitsev I believe. He did some InnoDB performance tuning sessions.
He told the assembled masses that in benchmark
If a slave dies, is there any way to determine that state from an
external point of view (ie: via Perl/DBD) so we can write a script of
some kind to either connect to the slave and issue a "START SLAVE" or
send the last xx lines of the .err log file to our tech staff?
I tried writing a Perl scri
Except that changes made on the master are not automatically picked up
by the slaves.
My bad, I wasn't running "START SLAVE" to get them going. Seems odd that
this has to be done manually.
Also, overnight, my slaves reported this error:
041108 19:06:42 [Note] Slave I/O thread: connected to maste
Id Study keyword
1 AK1
2 AK2
3 BK1
4 BK2
5 CK1
6 Ck3
SELECT DISTINCT Study FROM yourtablename WHERE keyword='K1' AND NOT
keyword='K2'
That *should* give you a single entry for 'C' since its keywords do not
match both 'K1' *and* 'K2'
But your posting *was* a little
After a little more RTFM-surfing, I found the "GRANT REPLICATION SLAVE"
for the master, and a "LOAD DATA" worked just fine.
Except that changes made on the master are not automatically picked up
by the slaves.
Am I missing something?
-id
--
MySQL General Mailing List
For list archives: http://li
LIENT" on the
master, which didn't work.
After a little more RTFM-surfing, I found the "GRANT REPLICATION SLAVE"
for the master, and a "LOAD DATA" worked just fine.
-id
ian douglas wrote:
One master, two slaves, mysql 4.1.7 installed via compiled source code,
on Red
One master, two slaves, mysql 4.1.7 installed via compiled source code,
on RedHat 8.0
On the master system I did this:
grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname1'
identified by 'repl_passwd' ;
grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname2'
iden
,
CaseNumber CHAR(12) NOT NULL,
Payment_Amount FLOAT(8,2),
INDEX CaseNumber ( CaseNumber ),
INDEX ID ( ID ),
INDEX ( ID )
);
On Fri, 05 Nov 2004 10:22:42 -0800, ian douglas <[EMAIL PROTECTED]> wrote:
Put Purge into backticks.
`Purge` char
Put Purge into backticks.
`Purge` char(1),
It worked great but I would like to know why, thank!
It could be that 'purge' is a reserved word in MySQL. I wanted to have a
table with a shortened name of 'description' by trying to create a table
with a 'desc' field, and MySQL had problems wi
In my experience, RedHat in their 'wisdom' put mysql.sock in /tmp/ yet
ships their mysql-server.rpm with a my.cnf pointing at
/var/lib/mysql/mysql.sock
Make the necessary change to /etc/my.cnf to point to /tmp/mysql.sock, or
change /etc/rc.d/init.d/mysql to point to /var/lib/mysql/mysql.sock
-
I'm trying to get a slash in a variable into my database and am having
some trouble. If the variable = "1 1/2" it echoes to the screen correctly
but it seems to strip the 1/2 off the variable when updating the value to
the database.
Just FYI to everyone replying:
Ed replied to me personally admitti
It doesn't say access denied so I assume the socket is not even open.
Never assume :o)
From your windows box, you could try:
telnet host.domain.com 3306
... if it connects, it connected to *something*
How can I find out if MySQL is on the port 3306?
What Linux command shows all active ports
1. If a new database is created on db1, this is not replicated on db2
and db3. ... is there a better way to automate duplicating this
>>database on the slaves?
Yes put in your my.cnf on the master binlog-ignore-db=mysql,test this
means the master will replicate any event to any database other then
RAID system and mounted via NFS to multiple machines to
actually run the MySQL engine? The tables we use have a lot of
auto_increment fields, and I'd be worried about data being corrupted or
lost.
Thanks,
Ian Douglas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
Which is fine ... you neglected to say whether or not that fixed your
problem?
-id
--
MySQL General Mailing List
For list archives: http://lists.mys
[EMAIL PROTECTED] root]# ls -l /var/lib/mysql
total 20564
-rw-rw 1 mysql mysql25088 Nov 1 14:10 ib_arch_log_00
-rw-rw 1 mysql mysql 10485760 Nov 2 07:39 ibdata1
-rw-rw 1 mysql mysql 5242880 Nov 2 07:39 ib_logfile0
-rw-rw 1 mysql mysql 5242880 Nov 1 14:10 ib_log
But can I edit a column field? Can I go into a specific column in a
specific record and edit it just like I was in a text editor? That's the
action I want. None on the products specifically state they can do it(?)
phpMyAdmin will allow you to alter a column name within a table, yes.
can't speak for
There are lots of ways to do it. My personal favorite is to write it in
Perl with the DBI library and tell cron to run that Perl script ... your
Perl script could then write the data in any format you see fit, even
send it somewhere else using Net::FTP or whatever.
Just my $0.02...
-id
Scott Ha
mos wrote:
At 01:50 PM 9/4/2004, you wrote:
This is an issue I have seen many people ask over the last year or
two, but I can't say I've ever seen a comprehensive answer (searched
the archives heavily, too).
I realize there are no binaries available directly from MySQL with
OpenSSL support comp
V. M. Brasseur wrote:
E SA wrote:
gcc -DDEFAULT_CHARSET_HOME=\"/data/MySQL\"
-DDATADIR=\"/data/MySQL/var\"
-DSHAREDIR=\"/data/MySQL/share/mysql\" -DDONT_USE_RAID
-I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. /data/OpenSSL/include/openssl -O3 -DDBUG_OFF -MT
libmysql.lo -MD -MP -MF .deps
This is an issue I have seen many people ask over the last year or two, but
I can't say I've ever seen a comprehensive answer (searched the archives
heavily, too).
I realize there are no binaries available directly from MySQL with OpenSSL
support compiled in. I am curious as to why (I'm sure th
How come when I am using the terminal on my mac os x 10.3.x and give the command show
databases I only see one database (the 'test' database that is included in the
install') as compared to viewing databases with my browser and phpmyadmin I can see 6
databases (that same 'test' database, a 'mysq
Should mysql version 4.0.20 support the "Insert data from a textfile into table" which
is shown at the bottom of the page while in phpmyadmin with a database and table
selected? I am getting this error:
#1148 - The used command is not allowed with this MySQL version.
Thanks for any help,
Doug
have MySQL 4.0.20 on my mac os x 10.3.x client machine. My question is, how do I go
about getting my MySQL databases that I created to another computer. I have been told
my databases are in /usr/local/mysql/data. When I try to get into the sub-directory
/data it says I do not have permission
I hope this isn't an inappropriate list for this...
I have been trying to get ESRI (ww.esri.com) to consider supporting
MySQL as a backend Database. They informed me that MySQL doesn't have
all the features required to support ESRI's products. Since the
alternatives are Oracle and SQL Server,
ection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 40 min 30 sec
Threads: 1 Questions: 5 Slow queries: 0 Opens: 6 Flush tables: 1
Open tables: 1 Queries per second avg: 0.002
Network: the mac is 192.168.1.100 (behind a LinkSys from the cable
It sounds as if you need to use a regular expression.
For very simple string comparisons, use =, as in _wbs='Fish'_
For more complex string comparisions with simple wildcards, use LIKE as
in _wbs LIKE "%fish%"
_For most complex comparisions, use a regular expression, as in _wbs
REGEXP ".\d"_
In
I installed DBI and dbd:mysql on 10.3.2 a few months ago and had all
sort of problems but I finally got it to work.
I don't exactly remember what finally did it, though. I think it might
have been running the install with sudo, as in:
sudo perl -MCPAN ... etc.
but I'm not sure. If you haven't
Hi
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP) are becoming the de facto standards for
web-based applications, I think far eclipsing Java (JSP/Servlets) and
Microsoft ASP/VB.
Unlike Java (which is driven to a large degree by Sun's promotion) and
ASP (he
e_worked, user_id, period_id) values
(5, 'clh', '27');
Query OK, 1 row affected (0.00 sec)
mysql> SELECT project_id, SUM(time_worked) AS total FROM time_daily
WHERE user_id='clh' AND period_id='27' GROUP BY project_id HAVING total>0
-> ;
+--
1 - 100 of 197 matches
Mail list logo
