Hi.
See:
http://www.mysql.com/products/mysqlcc/
leegold [EMAIL PROTECTED] wrote:
newbie question about mysql admin clients. What are some good ones? And
importantly can they access and allow me to edit the db record fields
themselves? eg. I see a mis-spelled word in a field - I could
Hi.
You may use lines starting by '\t' to ignore first column (if your outfile has default
format).
For example:
select * from t4;
+--+--+--+--+
| a| b| c| d|
+--+--+--+--+
|1 |2 |3 |4 |
|2 |6 |7 |4 |
|
newbie question about mysql admin clients. What are some good ones? And
importantly can they access and allow me to edit the db record fields
themselves? eg. I see a mis-spelled word in a field - I could go in
there and edit the field.
Have a look at Database Workbench: www.upscene.com
Hi Dan,
you can create temporary table 'tmpTable' with columns A, B, C, D,
load data into 'tmpTable ' and then use
INSERT INTO requiredTable (B,C,D)
SELECT tmpTable.B, tmpTable.C, tmpTable.D FROM tmpTable
HTH,
Dusan
- Original Message -
From: Dan Stark [EMAIL PROTECTED]
To: [EMAIL
In article [EMAIL PROTECTED],
Stephen Rasku [EMAIL PROTECTED] writes:
I am using the C API with MySQL 4.0.17 on QNX 6.2.1b.
I want to update the rows that are returned as I get them. Is this
possible. Here's a simplified version of what I am trying to do:
query = select seqNo, priority
On 1 Nov 2004, at 22:57, leegold wrote:
newbie question about mysql admin clients. What are some good ones? And
importantly can they access and allow me to edit the db record fields
themselves? eg. I see a mis-spelled word in a field - I could go in
there and edit the field.
I use one called
$ mysql -u mysqlusername -e 'insert your sql here'
On Mon, 1 Nov 2004, Scott Haneda wrote:
My query works:
(version 4)
SELECT u.id, r.user_id,
u.first_name, u.middle_name, u.last_name,
u.company, u.department, u.address, u.address2,
u.city, u.state, u.country, u.zip,
Hello,
Just hooked up to this list as last resort
Searched internet for some weeks now but still not found any
sollution/example.
If you search about BLOB, you always get results of storing gifs, jpg's and
so on.
I have (RO)access to an database and some tables have fields with TINYBLOB
Hi All,
I have built a search application in php/libcurl and I store its results in MySQL.
The problem is that I am not used to dealing with the sizes of tables my search
application produces, roughly around 400,000 rows in a table the last time I got ran
it correctly.
Right to my problem.
I
Hi.
See:
http://dev.mysql.com/doc/mysql/en/Charset-config-file.html
Brown, Brooks [EMAIL PROTECTED] wrote:
All of the unicode collations listed in the reference manual except the =
binary collations are not sensitive to diacritical marks. That is, if I =
do the following:
create
Hi - I've been trying different prefixes on my index I'm getting
funny results: in short:
an index on a column-prefix is bigger than an index on the whole column
using show table status I get total index size as:
12147712 - without index
13239296 - with full index
13455360 - with index on
Hi
Recently we performed an 'alter table' on a dev box to change from
myisam to innodb, and it resulted in considerable speed improvement. in
the lab setting.
Unfortunately when we repeated on the live server, whilst we got a 200%
performance boost (estimate) again, we failed to notice that
Is there any plan to release a 32-bit binary 4.1.7 MySQL max for Solaris 9 and
Solaris 8? I see all the other binaries for Solaris for everything - any reason
to exclude the 32 bit?
Thx,
R
I am trying to utilize MySQL's batch execution functionality by using build scripts to
create tables in my database (ref:
http://dev.mysql.com/doc/mysql/en/Batch_Commands.html )
Is it possible to execute additional source files from within a source file from the
MySQL command line?
Ex:
Hello All,
The new version of DBACentral for MySQL has been released. Since now
you can use a special DBACentral Run-Time Edition, work with views (in
MySQL 5.0.1), stored procedures and functions (in MySQL 5.0.0), print
the relationships diagram and use a bunch of new features.
Download page:
In article [EMAIL PROTECTED],
James Green [EMAIL PROTECTED] writes:
Unfortunately when we repeated on the live server, whilst we got a
200% performance boost (estimate) again, we failed to notice that
innodb is in DISABLED state, and yet alter table returned ok.
It's one of the ugliest
You can determine table type with
SHOW CREATE TABLE table_name
or
SHOW TABLE STATUS LIKE 'table_name';
From the manual http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html, If
a storage engine is specified that is not available, MySQL uses MyISAM
instead. That applies to ALTER as well as to
-Original Message-
From: Josh Howe [mailto:[EMAIL PROTECTED]
Sent: November 1, 2004 12:31 PM
To: [EMAIL PROTECTED]
Subject: mysqldump
Hi,
Can anybody help me with a linux newbie question. I want to
use mysqldump to backup all of the tables in a database that
HI,
I have copied the mysql-medium.cnf to /etc/my.cnf and have noticed that
the max-allowed-packet is 1M. no matter what I set it to 8M, 10M, 16M
I still get the error.
did you try this in your my.cnf in the [mysqld] section ?
set-variable= max_allowed_packet=8M
--
Philippe Poelvoorde
COS
On 02 Nov 2004 11:11:46 +0100, Harald Fuchs [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],
I guess this is an oversimplification. Often you can use a single SQL set
operation instead of a loop. Your example would probably be the same as
UPDATE packet
SET timestamp = now()
follow these steps
1) first shutdown the database
mysqladmin shutdown
2) Start the mysqldeamon
bin/safe_mysqld --max_allowd_packet=16M --user=mysql
3) to check what max allowd_packet it is using
mysqladmin variables
in the out-put check the value of variable max_allowed_packet
Thanks Spenser, but I'd already tried something similar. What I get when
I try this is:
mysqldump: Can't get CREATE TABLE for table `z_*` (Table 'sinu_com.z_*'
doesn't exist)
-Original Message-
From: Spenser [mailto:[EMAIL PROTECTED]
Sent: Monday, November 01, 2004 6:30 PM
To: Josh
In article [EMAIL PROTECTED],
Stephen Rasku [EMAIL PROTECTED] writes:
I guess this is an oversimplification. Often you can use a single SQL set
operation instead of a loop. Your example would probably be the same as
UPDATE packet
SET timestamp = now()
WHERE timestamp now() - INTERVAL 15
Hi everyone,
I've been browsing the online archives for a while and haven't found as
much data as I'd like to feel really comfortable about replication. I've
been a pretty busy developer in terms of using MySQL, but never so much
in the way of administration. Also, I've only ever had to deal
Did you try this one? I simplified it for you. You just need to put this in
a file and chmod +x the file. Then you can execute it from a crontab or with
the shell.
~~~ Copy/paste after this ~~~
#!/bin/bash
# Modify following variables
# script will dump the tables that contain the following in
On 02 Nov 2004 18:27:52 +0100, Harald Fuchs [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],
Maybe you should explain what you're trying to achieve, not what you
think how to do it.
Sure. I am using MySQL to store packets for transmission. I want to
send the oldest, highest
Hi list, I have 2 MySQL servers ver. 3.23.58, one is the master and the
other one the slave, the slave was working until I modified the following
lines in the master my.cnf file:
log-bin = /mnt/binlogs/masterBinLogs/sauron-bin
the directory and files have the following attributes:
drwxr-xr-x
Thanks, I haven't tried this yet. Iwant to generate one big file, not
one file per table. I guess I can replace the code in the for loop to
just build the mysqldump command. Thanks for the help!
-Original Message-
From: Steve Poirier [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: ian douglas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 02, 2004 9:30 AM
To: [EMAIL PROTECTED]
Subject: Replication basics
Hi everyone,
I've been browsing the online archives for a
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
Hello,
I am building a new linux box , just to be an mysql server
I have a couple of questions.
1) would it be better to go brandnew with a single processor or like a quad
p4 that's a year or two old.
2) I am going to running raid 5, so I assume that I should run scsi drives?
3) my database
Have you tried my MySQL C API Site ?
I have posted some C API examples here.
http://www.geocities.com/jahan.geo
Aftab Jahan Subear
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhaka 1204
Bangladesh
Tel: +880-2-7519050
/*
Get customized T-Shirts with logo for your IT company
1) would it be better to go brandnew with a single processor or like a quad
p4 that's a year or two old.
Depends on how your application runs. BTW, I don't think they made
quad p4's. You can't run p4 chips in SMP -- they must be Xeon's.
2) I am going to running raid 5, so I assume that I
I am trying to connect from my windows box at home using mysql.exe to a
MySQL server at work on a Gentoo box.
My command line is:
mysql -h host.domain.com -u root -p
(of course the host.domain.com is replaced with my server's FQDM)
The output is:
ERROR 2003: Can't connect to MySQL server
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
-- Original message --
From: none none [EMAIL PROTECTED]
Perhaps you did'nt grant access to for your home workstation IP
address to have permission to log into the mysql server? Check out the
grant command:
http://dev.mysql.com/doc/mysql/en/GRANT.html
If that
I have a database that contains a cable of 'customers'. 'Customers'
does not change on a regular basis but is queried frequently so I have
setup a 'customers_cache' table, which is exactly the same as
'customers', except 'customers_cache' is a memory based table. Before
doing a query on
I am using INSERT DELAYED ... to insert log records into a MyISAM table. Recently
these inserts have stopped showing up in the table, and extended-status shows them
coming in by increasing 'Delayed_writes', however 'Delayed_errors' is increasing by
the same amount. Obviously there are errors
Thanks. I passed this on and he found what was lost. I guess since the data
directory was owned by mysql, he could not find the databases when doing a
MacOS file search. I impressed upon him to use a separate datadir as we do
with our servers, thus bypassing this whole thing.
Thanks again!
X-posted to MySQL and PHP DB
Hi gang
Task at hand: deleting or selecting (same difference) several numbers of
records using only 1 query.
My first version simply looped through all the ticked off IDs and ran a
single query for each delete routine. I've still not suceeded in getting
the delete
I'm running mysql 4.1.7 on linux. I recently made the upgrade from 4.0.1
to 4.1.7 to get the additional character sets support. I have data
getting inserted that has various unicode characters embedded such as
the Registered Trademark symbol, and various foreign language characters.
my tables
-- Original message --
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
Task at hand: deleting or selecting (same difference) several numbers of
records using only 1 query.
My first version simply looped through all the ticked off IDs and ran a
single query for
The subject title is a sedgeway into my question that may slightly of
topic but I've asked many sources and don't have an answer yet so I ask
it here.
I have a text fields of html marked up content which I render via php.
Looking at the rendered html page in a text editor I see that ampersands
On Tue, 2 Nov 2004 21:57:36 -0500, [EMAIL PROTECTED] said:
From my understanding of how text indexing is done, and other
punctuation
don't get indexed. What happens is the actual word content is broken
appart
and indexed on a word by word basis on your NA SD it would be broken up
into two
MySQL Query Browser 1.1.0 Gamma and MySQL Administrator 1.0.14 have just
been released for Windows and Linux.
This is the first gamma release of Query Browser, a graphical query shell
and SQL script editor. Feature highlights:
- perform queries and edit resultsets;
- export resultsets to CSV,
Simple: don't convert it to HTML before inserting it. I used to do that as
well, but it causes problems when using searches for several reasons,
mostly because you have to convert the search query to HTML, which takes
time, and then send the more complex data structure to the server, which
I just dumped my access tables into mysql via mysql dump script.
But now when i del my ables in access then do an import it does not
save the primary key info nor the tables relationships. Is there
something I need to do to save this info before i remove the old
tables and insert the links.
DELETE FROM the_table WHERE `ID` IN(1,2,3,4,5,6) will work just fine. The
trick is to be sure that
those records indeed are to be deleted. I prefer to mark the record as
deleted for a time before permanent deletion. That way its recoverable
should something really bad happen.
bastien
From: -{
Hello,
I searched MySQL.com but couldnt find the official
Works With MySQL logo. Can somebody point me to the
right direction.
If they can send it to me as an attachment, will be
helpful.
Regards,
Karam
__
Do you Yahoo!?
Check out the new
I'm trying to use the C++ API (a.k.a. MySQL++). The on-line manual and
some of the books that I have say to include the file sqlplus.hh for
connecting to MySQL. However, when I downloaded the latest version of
MySQL++ (1.7.19-1 for RedHat 9) from mysql.com, it didn't seem to
include sqlplus.hh
hi
i have a problem mysql doesnt seem to support the intersect can
somebody help how i can write the followoing code in mysql
select csymbol from tblavgPrice where avg 1 and avg 10
intersect
select csymbol from tblAssets where assets 100 and assets 500
thanks
--
MySQL General Mailing
http://images.google.com/images?hl=enlr=q=%22Works+With+MySQL%22btnG=Search
Aman Raheja
Karam Chand wrote:
Hello,
I searched MySQL.com but couldnt find the official
Works With MySQL logo. Can somebody point me to the
right direction.
If they can send it to me as an attachment, will be
helpful.
I had checked google before posting. As you can see
none of the images are original and the clarity is not
good. They dont look good in my app.
Can I get an original one from MySQL AB?
Regards,
Karam
--- Aman Raheja [EMAIL PROTECTED] wrote:
53 matches
Mail list logo