http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
I recommend LEFT( ).
If you are looking to do it in PHP then this is the wrong email list.
Good luck.
b.
CodeHeads wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello all,
Have a question:
I would like to limit the
Marten Lehmann wrote:
I had a lot of trouble today because the InnoDB integration in MySQL
is lousy. I read the manual and worked with innodb_per_file_table. So
when I shutdown mysql I should be able to delete ib_logfile0,
ib_logfile1 and ibdata1, because all table-data should be stored in
InnoDB always needs the shared tablespace because it puts its
internal data dictionary and undo logs there. The .ibd files are
not sufficient for InnoDB to operate.
well, thats what I found before. But it doesn't explain why InnoDB
does need a logfile even when all transactions are
UPDATE table SET field_a=field_b;
b.
Ravi Malghan wrote:
Hi: is there a way to copy all field values from one
field to another from the mysql prompt?
Thanks
Ravi
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection
I am having a problem where I cannot seem to increase the max_join_size
of 4.1.18 above a hard limit that is way too low for my use. Has anyone
run into this and know of a solution that does not involve upgrading to
5.x.x? (That is presently not an option for another month or so.) I also
want
All,
In the following query, some of the values are averaged over several
rows, but some are not:
SELECT hostname, volname, qtreename, round(avg(used/allocated*100),0),
round(avg(used)), allocated, available
FROM quota_entries
WHERE date_sub(now(), interval 1 day)
Shawn,
That's a very reasonable answer. Thanks for pointing me to the
examples. This one addresses the second question:
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.
html . There is no example answering both questions in one query.
Regards,
Bill
2002
+++ execute.c Fri Feb 22 10:53:48 2002
@@ -72,7 +72,26 @@
query=tmp_buffer;
}
}
- }
+ }
+ /* Terrible hack by Bill Adams */
+ else if(
+ !my_casecmp(query, select, 6)
+ my_casecmp(query, where, 5)
+ my_casecmp(query, limit , 7
Spoiler: Venu's Suggestion about Dynamic Cursor is the answer
On Thu, 2002-02-14 at 20:34, Venu wrote:
MyODBC, as compiled today, uses mysql_store_result to get records. This
is fine for reasonably sized tables. However, if the table has millions
of records, writing the results to a
Monty, Venu, I hope you read this... :)
I really, really want to use MySQL as the database backend for my
datawarehouse. Mind you I have played around with merge tables quite a
bit and know that MySQL is more than up to the task. There are numerous
(not necessarily cost related) reasons as to
Etienne Marcotte wrote:
What is the exact difference between
this
index(col1,col2).
Create a single index on col1 and col2.
that
index(col1),index(col2).
Creat two indexes, one on col1, one on col2.
and this
index(col1),index(col2),index(col1,col2).
Do all three. Note that
Cindy wrote:
I tried checking for error codes in the documentation, but didn't find
anything particularly useful.
I'm getting this:
mysql load data infile '/export/home/Scratch/WordIndex.txt' into table wordindex
(aid, wid, wordform, start, length);
ERROR 1030: Got error 28 from table
rick herbel wrote:
Question - Why is key len,ref null ?? Is it not using my key? Why does it
say type range
here and below it says type ref the table has 134000 records in it so it
should be using key.
Have you run myisamchk -a on the table? (Or ANALYZE TABLE from the sql prompt?)
b.
PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Bill Adams
TriQuint Semiconductor
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
, Bill Adams wrote:
Anthony R. J. Ball wrote:
I was just reading DOCS for MERGE tables... and they
look like exactly what I want.
I have a large lookup table that I use to track down
where I want to find my data, which gets loaded into
different tables at different times
Erik Price wrote:
All,
Well, I solved the mystery of the missing Unix socket. It needs to be
defined at the time the daemon is started with:
--socket=/path/to/socket. Well, at least in my installation it does.
But now I'm having the OPPOSITE problem -- shutting down the server
(the
PS: If I run the mysqladmin shutdown command, then check top in
another console, both the daemon and the mysqladmin command continue to
run indefinitely -- and I have waited an hour to see if it's just slow.
That doesn't seem to be the case.
This seems like an OS bug to me. All of the
MySQL 4.0
Is there a way to prevent mysql(d) from buffering
the output ala 'mysqldump -q'?
The specific case I am thinking of is a simple
SELECT ... FROM ... WHERE (with no ORDER BY, no
GROUP BY, etc.). In this case there is no reason
[that I can think of] why mysqld cannot start
returning
://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
--
Bill Adams
TriQuint Semiconductor
fi
done
done
Or I could be completely off base. It wouldn't
be the first time. :-)
Jon Gardiner.
-Original Message-
From: Bill Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 2:47 PM
To: Mysql List
Subject: myisamchk -a + indexes + hidden
the query is running w/o any results being returned yet, the process
list shows sending data.
b.
-Original Message-
From: Bill Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 11:38 AM
To: Mysql List
Subject: Non-Buffered mysqld
MySQL 4.0
Is there a way
Bill Adams wrote:
Rick Emery wrote:
If you use PHP, the answer is:mysql_unbuffered_query()
Well, I get the delay if I query with perl DBI or enter the query directly in
the mysql client. perl DBI + Informix does not buffer so I know that it is
not that combo. (I guess it could
Man I just cannot stop replying to myself...
Bill Adams wrote:
Bill Adams wrote:
Rick Emery wrote:
If you use PHP, the answer is:mysql_unbuffered_query()
Well, I get the delay if I query with perl DBI or enter the query directly in
the mysql client. perl DBI + Informix
Jeremy Zawodny wrote:
On Wed, Nov 14, 2001 at 12:07:04PM -0800, Bill Adams wrote:
The most important exception is the mysql_use_result attribute: This
forces the driver to use mysql_use_result rather than
mysql_store_result. The former is faster and less memory consuming,
but tends
Won Lee wrote:
I have an slew of Access DBs that I need to port some of the info into a
MySQL DB.
I guess my main problem is my I have no idea in what format to export my
data from the Access DB.
In general I export it as a tab delimited file with no text qualifiers.
Unfortunately, much of
to a different db you can move either the .MYI, .MYD, and .frm
to the right place OR you can use mysqldump.
b.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams
Sent: Wednesday, November 14, 2001 5:31 PM
To: Won Lee
Cc: mysqlList
Subject
)
Shutdown MySQL
Set key buffer size to 0
start mysql
Time to start getting results: 10 seconds.
Total Time: 29 seconds (18251 rows, 629 rows/sec)
myisamchk -a
Time to start getting results: 145 seconds.
Total Time: 164 seconds (18251 rows, 111 rows/sec)
--
Bill Adams
TriQuint Semiconductor
Riccardo Cohen wrote:
Hi,
Sorry to disturb, but I cannot find any answer in online doc and web archive.
Description:
I insert 34000 rows in a simple table with all text fields, and myisamchk
tells the table is corrupted, while a select into outfile does not give any error
compared
Jeremy Wilson wrote:
At 01:07 PM 11/13/01 -0600, Gerald Clark wrote:
Start the server with the desired TZ set.
That's all fine and good, but difficult switch back and forth every 10
minutes while that query runs for local data, then for the remote data.
The way I deal with it (and I don't
Sinisa Milivojevic wrote:
Nick de Voil writes:
I am running MySQL 3.23 on Windows 2000.
I have a SQL statement which looks fine to me, although it does reference
the same table twice.
Here it is:
SELECT DISTINCT u.inserted_usr_id, g.inserted_ugp_id FROM raw_users u,
raw_data
Auri Net SAC wrote:
Hi,
I have a query result with 50 register and i want to show them in 5 pages,
every page show 10 register.
LIMIT (see the manual) will help you.
b.
mysql
-
Before posting, please check:
Karl J. Stubsjoen wrote:
Hello,
I need to create a search engine out of a few MySQL tables I should
say: I need to search MySQL records like a search engin might. However, my
first go ended up as a complete failure because it is highly un-optimized to
search for (as an example)
Fulko Hew wrote:
I am using mySQL 3.22.4a-beta
yes, I know its old :-(
I have just stumbled across a problem with how it
treats 'uniqueness' in table contents.
I have a table with a column defined as:
create table test (name varchar(80) not null);
alter table test ADD UNIQUE
Craig Issod wrote:
Using 3.23.32 on FreeBsd 3.2
Have gotten a sample fulltext search going, but cannot figure out how
to shorten the word length to 2 o3 3, from the default 4.
Yes, I've read the docs, and tried the following:
Setting variable using mysqld on command line...it won't take
[EMAIL PROTECTED] wrote:
Howdy,
I'm running version 3.23.41 on RH7.2. For the life of me I can't figure out why
I can't stop mysqld. Linuxconf was where I first noticed this where mysqld would
not respond to the stop request. I then tried to reboot the box and watched the
shutdown process
Craig Issod wrote:
Craig Issod wrote:
Using 3.23.32 on FreeBsd 3.2
Have gotten a sample fulltext search going, but cannot figure out how
to shorten the word length to 2 o3 3, from the default 4.
Yes, I've read the docs, and tried the following:
Setting variable using
Simon Windsor wrote:
Hi
I appear to have lost several records, but on doing mysqldump db the
records are there.
I have tried optimize|repair and the data hasn't re-appeared.
Any ideas ?
Not with this level of information.
(Try including some sql, what you are trying to match, etc.. And
[EMAIL PROTECTED] wrote:
I'll agree with you but - when I shutdown my linux box or restart it, it tries
to stop the mysql server and it can't. The command /etc/init.d/mysqld stop
should work and it isn't. The question is why can't I stop the mysql server with
this command. As a matter of
[EMAIL PROTECTED] wrote:
The only reference to mysqladmin is for the reload at the end. I think this
whole thing started after doing the mysql_install_db and then creating the root
password - but it may be a coincidence.
Any and all help is welcome as to why /etc/init.d/mysqld stop fails.
Brendin wrote:
I would like to have a table that has a primary key defined on a
combination of two columns in the table. In other words a unique key
based upon the values in two columns.
I don't think I am able to do this in mysql. I think you can only have
a primary key on one column
[EMAIL PROTECTED] wrote:
I changed the script and now all is well. However I have two concerns:
1) Paranoid about the password being in this script. Is there a way around this.
chown root:root /etc/rc.d/init.d/mysqld
chmod go-rx /etc/rc.d/init.d/mysqld
2) Since I had to change the script
Simon Windsor wrote:
Hi
The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36,
the standard RedHat version.
The machine is running two databases, one is a full archive while the other
ones holds current data. The same five records are unavailable using SQL in
the
(Sorry for the double email Simon, forgot to
switch the email to text...)
Simon Windsor wrote:
Hi
The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36,
the standard RedHat version.
The machine is running two databases, one is a full archive while the other
ones
[EMAIL PROTECTED] wrote:
I'm switching over to a bigger better faster server. My old server is running
version 3.23.22-6 mysql on RH and I need to move all the db's to my new box
using 3.23.41 installed on RH7.2. So do I just simply move all of the db
directories from /var/lib/mysql from one
Wells, Kenneth L wrote:
Please help
I'm at the end of my rope...
I just ran a script to create databases in my SQl server, it runs fine
When it completes it says remember to set a password for the mysql root
user!
I entered this?
/usr/local/mysql/bin/mysqladmin -u root -p
The MySQL manual
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#MySQL_indexes
states All MySQL indexes (PRIMARY, UNIQUE, and
INDEX) are stored in B-trees. Strings are
automatically prefix- and end-space compressed..
Other RDBMSes out there state in the their
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Bill Adams
TriQuint Semiconductor
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Rui Barreiros wrote:
Hi,
We have several mysql server in production evironment, and most of them
when they have millions of rows, they all get MyIsam tables corrupted.
One of the servers has ext2 filesystem with scsi harddrives, after the
myisamchk -r it repairs the table, but after a few
Aaron Williams wrote:
The tables run upwards of around 13-15 gigs each. The nature of the
data forces me to search the entire contents (looking for unique
values) around 3000 times a day. The server is running Solaris 2.8,
Do you have an index on the columns you are querying for unique
Stuart Scamman wrote:
How do I show processlist from a specific computer, not everything ?
Thanks.
mysqladmin processlist |grep 'the.host.you.care.about'
--
Bill Adams
TriQuint Semiconductor
-
Before posting, please
Dan Tappin wrote:
I have some experience with MySQL on MacOS X but that was with a pretty GUI
installer.
I am now trying to get MySQL installed on Redhat 7.0. I download the client
and server versions and followed the install procedures.
The problem I am having is with mysqladmin. The
Dan Tappin wrote:
I tried that but it came back with a 'mysqld is running already' error.
Actually your command is wrong. If you never set the password before it should
be (without the -p):
mysqladmin -u root password your?new.password
note that 'password' IS the command.
Side Question:
, as it were, you need to get into the mysql db:
'mysql -u root -pyour?new.password mysql'. Note that there is NO space between
the '-p' and the password.
b.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams
Sent: Friday, November 09, 2001 2:26 PM
mweb wrote:
mweb,
To make sure I understand you correctly, you want to create
and
test your PHP/MySQL database on your Linux/Apache box, then upload it
to
your ISP server that is running PHP/Access? I'm sorry but that's not
going
to work. You can't transparently switch a PHP
.
mysql
mweb
On Fri, Nov 09, 2001 15:22:11 at 03:22:11PM -0800, Bill Adams wrote:
mweb wrote:
mweb,
To make sure I understand you correctly, you want to create
and
test your PHP/MySQL database on your Linux/Apache box, then upload it
to
your ISP server
Christian Stromberger wrote:
Disclaimer: SQL/database newbie here.
Let's say I have a table of authors with columns for last name and first
name. Is there any general guideline re using a separate integer for the
primary key as opposed to a combination of the last and first names as the
My mind is not working with me this morning...
According to the manual about join syntax:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOIN
One should be able to do a LEFT JOIN without a
join_condition, eg. an ON or a USING:
table_reference LEFT [OUTER] JOIN
Harpreet wrote:
I had a view on sqlserver which i am trying to convert to work with mysql.
It uses a union which i believe does not work with mysql. What is another
alternative for union.
Sql with union:
select a.asset_id,a.material_id,b.material_id as parent_material_id from
suggestions?
--Bill
-Original Message-
From: Bill Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 12:21 PM
To: Mysql List
Subject: Left join w/o on or using join_condition
My mind is not working with me this morning...
According to the manual about join syntax
Federico Schwindt wrote:
hi,
i'm not sure if this belongs here, but i cannot seem to find the
answer anywhere else.
first, what's the difference between:
PRIMARY KEY (key1, key2)
PRIMARY KEY (key1), KEY (key2)
The first line creates a single, unique key on the columns key1 and
/ (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
--
Bill Adams
TriQuint Semiconductor
--
-- Original Message -
From: Bill Adams [EMAIL PROTECTED]
To: David Wolf [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 29, 2001 9:21 AM
Subject: Re: Optimizing query (2nd attempt)
David Wolf wrote:
Not quite fixed.. When I run the query
without limiting by time, it still
alexus wrote:
Hello
I have a very busy site (www site) w/ a lot of hits
my site is very heavily integrated w/ mysql
and when i do top it shows me like over 80% of cpu
even though i have dual p3 850mhz w/ 1.5 gig of ram
any ideas what to do about it so it'll drop down?
Have you
Demirchyan Oganes-AOD098 wrote:
Hello everyone,
I wanted to ask you 2 questions.
1. I have a table that has 2 columns, user_id, user_name.
User_id has been setup to a default value 1000 and to AUTO_INCREMENT.
When I insert a record, Insert Into User_Table (user_id,user_name) Values
Bill Adams wrote:
Demirchyan Oganes-AOD098 wrote:
Hello everyone,
I wanted to ask you 2 questions.
1. I have a table that has 2 columns, user_id,
user_name.
User_id has been setup to a default value 1000
and to AUTO_INCREMENT.
When I insert a record, Insert Into User_Table
Kyle Hayes wrote:
On Friday 26 October 2001 10:00, Dana Holt wrote:
Can I automatically generate a random, unique, integer value in a certain
range when inserting data into a column using SQL?
If so, how?
Random is easy. Just find a good RNG (random number generator) somewhere
Elm Gysel wrote:
/* perform query */
query.execute(nr, Date.str(), Op, Hi, Lo, Cl, Vo);
The problem is in the above line I think. If I comment it out the memory
usage doesn't explode.
I get around 1.5MB more mem usage each time I insert 2000 records.
I have no clue what might
Rob Vonsee wrote:
Dear developer,
In the past several years, we have developed a database application in
MicroSoft's Access '97.
With our user base growing, we're encountering more and more limitations in
the Microsoft development environment, especially in the stability and
number of
jim barchuk wrote:
Hi Ryan!
Today after my server got a real traffic hit for the first time since I
installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how
it happened: watching the top load levels, I saw it slow creep up about to
3, then rockets quickly to 30s,
[EMAIL PROTECTED] wrote:
Hi. I've been reading for several hours on this one. I've tried everything
I've read. I'm either doing something really stupid or I've missed the
point completely.
I have a db on a linux server. I used phpAdmin to create a dump file
(pe.sql) and retrieved it on my
Sommai Fongnamthip wrote:
Hi,
If I install mysql-4.0 to upgrade in mysql-3.23.xx with old setting value
(use myisam type), Could I need to change or re-load my old db?
AFAIK, If you are keeping the table type, you can just copy the .MYI, .MYD, and .frm
files to the new location. Or
Wix,Christian XCW wrote:
Hi!
How print the result from a query on my printer? I'm using the command line
on linux.
Lets say that I want to print everything from the table Mercedes in the
database Cars.
Pipes.
How do I adjust the lenght of the lines?
man nenscript
Basically:
echo
Harpreet wrote:
I am using concat in my sql and it runs fine on mysql client. But when use
din php it gives me an error:
Supplied argument is not a valid MySQL result resource in
b/var/www/html/scripts/cfg_code_delete.php/b on line
$ssql=select concat(category, -, code) as fill_column,
Michael Blood wrote:
I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
I have been getting an table handler returns error 127 error
If I fix the table with myisamchk -r or -o it will work for a while and then
I will get the same error again.
Try dumping and restroing the
Oscar Castaneda V. wrote:
Hi,
i ran into a pretty boxy problem this morning, as I tried to login as mysql manager
with
#mysql -u root -p
# (i forgot the password)
its either this, or the other administrator, whom i cannot contact right now,
changed the password without my knowledge of
Tom Hicks wrote:
I am thinking of running MySQL on my box for some work with PHP. I am
concerned about the mods to the directory structure. I can't seem to
find a list for mods it will make on RedHat7.1
Could you please help me out with that?
Not sure what you mean by 'mod', but you can
Ing. Gustavo Edelstein wrote:
Thanks for your answer, but I need to know the names of the users currently
logged in the database.
Regards,
SHOW will do that as will 'mysqladmin processlist'.
http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html
b.
Jason Whitlow wrote:
Sorry for for the dumb question buuut.
I have been connecting to a database on my localhost using perl's DBI.pm
This is how I currently do it.
use DBI;
$data = databasename;
$driver = DBI:mysql;
my $dbh = DBI-connect($driver:database=$data, username, password)
PROTECTED]]
Sent: Wednesday, October 24, 2001 9:42 AM
To: 'Bill Adams'
Subject: RE: pls help for index problem
Thanks yr promptly reply !!
It seems no any change(improvement) by running explain again after erase
quotes. I also ran the command 'myisamchk -a gw.MYI' before sending
M. Alageswaran wrote:
Thanks man, I tried that but still no hope..
when I did a ps -ef | grep mysqld there is nothing in my output!
-ef is for HP-UX (I think). For Linux you want 'ps ax |grep mysqld' note
there is no dash in front of the ax.
b.
kmlau wrote:
I encountered a problem about indexing. I want to add index on timerecord
field in table gw (shown as below) to speed up query relating with time.
However, I use explain command (explain select * from gw where timerecord =
'010902') to analyze the performace. As a result,
[EMAIL PROTECTED] wrote:
Hi all,
Is it possible to have an external file as an attachment in MySQL?
An example would be a .gif, .doc, .ppt, .ram etc.
If there is no way directly have MySQL table to store an attachment, is there
any work around?
Any guidance will be appreciated.
To store
Martyn Wendon wrote:
Hi,
I'm new to MySQL and indeed SQL in general (coming from an MS Access and
Flat Text File background).
I have data in text form at the moment of the following fields:
ID (Auto increment)
ARTIST (Text up to 255 characters long)
DESCRIPTION (Text up to 255
TOMASSONI Dominique wrote:
I stored a sql string in a file and when I launch it, it doesn't perform
because the string is truncated before the end.
Does mysql limit the length of an sql string ?
Not that I have ever run into. But ODBC does.
What command are you running? E.g. on linux
Rafal Jank wrote:
Hi!
Is there a possibility to rotate mysql error log without stoping the server?
I was waiting for someone else to respond. But some possibilities are 1: use
the apache program 'rotatelog'. Not sure how you would do this.
In Linux you can rename the file while the server
Steve Meyers wrote:
At a previous job, we tested a 32-bit hash function by running it
against hundreds of thousands of unique URL's stored in our
database. We found one collision. A 64-bit hash is billions of
times better (4 billion, to be exact).
Good to know. I wonder how
Duncan Hill wrote:
On 22 Oct 2001 [EMAIL PROTECTED] wrote:
Antigen for Exchange found Unknown infected with
[EMAIL PROTECTED] (Norman) virus. The file is currently
Removed. The message, SV: Here you have, ;o), was sent from Pål
Wester and was discovered in Public Folders\Mailing
[EMAIL PROTECTED] wrote:
Description:
The following is the error message:
#scripts/mysql_install_db
Could not load program ./bin/my_print_defaults:
Dependent module libz.a(shr.o) could not be loaded.
Could not load module libz.a(shr.o).
Error was: No such file or directory
Carl Troein wrote:
Bill Adams writes:
This is odd. The only machine in cricalix.net (which I own/run) is a
linux box. Who has a badly configured server out there?
Even more odd is that the 'from' address I saw was [EMAIL PROTECTED]
I thought my company server was spamming the list
Spoiler: You may be right about the bad libs...
Kyle Hayes wrote:
On Thursday 18 October 2001 12:31, Bill Adams wrote:
Hmm, 2.2 doesn't do SMP really well. However, its drawbacks are limited to
underuse of the CPUs rather than any kind of corruption or other issue. You
would get much
JohnHomer wrote:
can mysql allow table joins when using UPDATE query? like
The manual answers these questions.
update tranfer left join transferdetails
on transfer.docno = transferdetails.docno
set transferdetails.docno = concat('SJ',transferdetails.DocNo)
where
transferdetails.docno not
Mark Coldheart wrote:
I've a little bit problem about running mysqld
server. I've run /etc/rc.d/init.d/mysqld start it
will appear mysqld dead but subsys locked. But if i
stop the service, it will fail. It is also happened
when i kill the service.
Mm, redhat question.
Make sure mysql
cedric wrote:
/usr/bin/mysql start returns the error message:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock.
It was there, but now it's not.
That is the wrong command, use either safe_mysqld or mysqld_safe. Or possibly
/etc/rc.d/init.d/mysql start
Also,
Bill Adams wrote:
Spoiler: You may be right about the bad libs...
[snip]
*** OMG ***
But haha I cannot believe this, I was just looking at the libraries linked by
mysqld with ldd and it is using the informix libpthread.so. Hmm, crap. *me
slaps head*
Small Update:
o If there is no call
Riccardi Moreno wrote:
I want to import data from text file that contains decimal number
(occasionaly with 9 decimal) but mysql import only 2 decimal.
My columns is set to DECIMAL(6,9)
Someone correct me if I am wrong: The '9' is how many decimal places after
the period you want and eats up
Ravi Raman wrote:
I'm not sure why there is such an outspoken negative reaction to a
commercial software company announcing a related product on a mysql
list...
As another poster pointed out, this is a HELP list. If someone posted to the
list looking for a product where Lasso meets that
Philip Johannessen wrote:
Im currently in a debate with someone who prefers PostgreSQL. He says that
MySQL is unstable etc. Can you please give me examples of some well known
sites built on MySQL so I can tell him that MySQL rocks?
PostgreSQL: Unless something has changed in the more recent
Matthew Bloch wrote:
I'm running several MySQL installation (all version 3.23.37 under Linux)
under what I presume are some fairly harsh conditions, and wondered what
circumstances cause tables to be corrupted and need fixing with myisamchk.
This is happening once every few days and it's
Replying to myself just HAS to be in bad taste. But I guess I burt out my taste
buds a while ago. ;)
Bill Adams wrote:
Ravi Raman wrote:
I'm not sure why there is such an outspoken negative reaction to a
commercial software company announcing a related product on a mysql
list
Carsten H. Pedersen wrote:
What about FAQ-o-Matic?
http://faqomatic.sourceforge.net/
We would just need it hosted somewhere.
Not to put a too fine point on it, but how 'bout
referring them to: http://www.bitbybit.dk/mysqlfaq?
I thought this address was well published by now, but
1 - 100 of 101 matches
Mail list logo