This works:
mysql> select trim('foo' FROM 'foobaar');
++
| trim('foo' FROM 'foobaar') |
++
| baar |
++
1 row in set (0.00 sec)
This do
Jeremy D. Zawodny wrote:
> On Wed, Jan 17, 2001 at 11:16:27PM -0800, Mike Wexler wrote:
>
>
>> This is a big improvement. What would be really cool would be to
>
>> read lock a table, copy it to the slave, and then tell the slave to
>
>> start paying attention to the binary log for *that* t
On Wed, Jan 17, 2001 at 11:16:27PM -0800, Mike Wexler wrote:
>
> This is a big improvement. What would be really cool would be to
> read lock a table, copy it to the slave, and then tell the slave to
> start paying attention to the binary log for *that* table. Then it
> would repeat this for all
>Description:
I downloaded the binary for mysql-3.23.30-gamma-hp-hpux10.20-hppa1.1.
And followed the following procedure :-
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s mysql-VERSION-OS mysql
shel
A quick note. I was at the time mainly trying to switch from a one
server machine to another without downtime. It strikes me as something
that should be doable with replication. I'd really like to see the
replication process simplified to the point where you would issue some
commands from the
Jeremy D. Zawodny wrote:
> On Wed, Jan 17, 2001 at 09:46:40PM -0800, Mike Wexler wrote:
>
>
>
>
>> It appears to be clearer, but its hard to tell unless you are
>
>> actually trying to set it up. The first time I read it, I was
>
>> setting up replication and the same time.
>
>
>
> So
On Thu, Jan 18, 2001 at 01:21:05PM -0700, Basuki Setiawan wrote:
> So do I
In their usual amazing fashion, the MySQL team responded very quickly
and put the changes online only hours after I sent them a diff.
Check these:
http://www.mysql.com/doc/R/e/Replication_Implementation.html
http://
On Wed, Jan 17, 2001 at 09:46:40PM -0800, Mike Wexler wrote:
> It appears to be clearer, but its hard to tell unless you are
> actually trying to set it up. The first time I read it, I was
> setting up replication and the same time.
So was I. And I failed the first 2 or 3 times until I made some
Hi there,
I heard MySQL 3.23.30 was released and support transaction with BDB tables,
I want to know if I use BDB tables, will MySQL not use BIG TABLE LOCK in BDB tables?
we plan to build a very busy web server, and very care about this issue.
Regards,
David
So do I
warm regard,
Buzz
> > I've suffered thru the replication setup a few times recently. I am
> > (tonight) attempting to update the MySQL manual to be more clear on
> > some of the lessons I learned along the way. (I finally found a bit of
> > the spare time I'd been hoping for...)
> >
>
It appears to be clearer, but its hard to tell unless you are actually
trying to set it up. The first time I read it, I was setting up
replication and the same time.
My one concern, is it sounds like in order to set up replication you
need to bring down the master for long enough to archive al
sir,
can i build mysql database in win 98 and install on server runnin on winNT
please advice AFAP
rohit
On Wed, Dec 27, 2000 at 10:48:29AM -0800, Mike Wexler wrote:
> I tried to set up replication using this HOWTO yesterday and I'm
> clearly missing something. I have some (hopefully) constructive
> comments to make about the manual and maybe I can even get some
> answers as to why replication isn't
I've spent most of this day reading and rereading the documents on setting up
MySQL. I'm currently working on NIDS and have setup MySQL on the same box as
the sensor for logging of packets to verify that I had the NIDS setup
correctly for db logging. I then installed MySQL (binary rpm version) o
Hello,
I'm a new user of MySQL and am having problems updating mysql table rows
that are "text" fields and contain html. It appears that when I update it
encounters the "<" or ">" tag and is chopping data off. This is not a
problem if it does not contain HTML. Am I missing something basic. I have
Hello!
You just need to download the following file to run MySQL on your computer:
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.30-gamma-win.zip
Best regards,
Fábio Ottolini
- Original Message -
From: "Chetram Ramnarain" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursd
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
Hello,
I am trying to download a copy of MySQL for my Win 98/NT computer. There are
so many different kinds of downloads, which one do I choose. Which
documentation do I need? HELP! Anyone. I am trying to learn this software,
as it was recommended to me.
Any help I will appreciate.
Thanks
-
Or here:
http://marc.theaimsgroup.com/?l=mysql&r=1&w=2
The difference I saw on the two mailing list searches is that theaimsgroup
orders by date and mysllist orders by the most replys...
// Tobias
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: "Richard Ellerbrock" <[E
Actually it doesn't give the exact URL and it is a little hard to find from
the home page. Try
http://www.mysql.com/documentation/searchlists.html
or from main page: Documentation --> Mailing Lists and then you have a
choice of Non-English & Searchable.
- Original Message -
From: "Rich
>I noticed a little quirk when searching the manual...it seems that sometimes
>when doing consecutive searches, the root directory disappears in the "href"
>tags for the results:
>
>for example resulting link will look like this:
> http://p/e/Perl_support_problems.html
>
>instead of somethi
SHOW KEYS FROM table;
-Original Message-
From: Bill Long [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 January 2001 12:24
To: [EMAIL PROTECTED]
Subject: How to get a list of indexes on a table
*This message was transferred with a trial version of CommuniGate(tm) Pro*
is there an easy wa
http://www.mysql.com/doc/S/H/SHOW.html
always check the docs
show index from
- Original Message -
From: "Bill Long" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 3:23 PM
Subject: How to get a list of indexes on a table
> *This message was transferred wi
Hi,
Asaf Maruf wrote:
>
> How can i specify two columns together as primary key for a table.
>
> Using create table test
> (increment int , id int not null primary key, date not null primary key, name
>char(20) );
>
> doesn't work.
You should rather say
create table test (
increment int ,
OK,
I changed the owner:group to mysql:mysql for /var/lib/mysql recursively and
got the same results.
I changed the permissions to 770 recursively and got the same results.
I changed the permissions back to 700.
Also, I downloaded the 3.22 version from the mysql website. It appears to
use
a di
*This message was transferred with a trial version of CommuniGate(tm) Pro*
is there an easy way besides doing a mysqldump to show all the indexes
on a table and their details?(name, table, column(s), type, etc).
I can't seem to find a way to do it. If one doesn't exist, does somebody
have a progr
HI,
Yes, but unfortunately, you need to upgrade to 3.23 to get this behavior.
Regards
Quentin
-Original Message-
From: luisma [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 January 2001 12:03
To: [EMAIL PROTECTED]
Subject: AUTO_INCREMENT question
I have a column, lets say "id", tha
I have a column, lets say "id", that is AUTO_INCREMENT. In it the most
recently
inserted row got an ID value of 100.
Now, lets say I kill off some rows from before,
and crunch down the
IDs
so that there are no skips in numbers, and now the most recently
inserted
row has an ID of 85.
Wh
This looks to be a misconfig problem with the mySQL server itself. Take a look
at the mysql.users table. Make sure there is some type of entry for user '%'
from host '%' with a password. Once those are in place, the server should let
you in. Be sure the db you are connecting has proper privileges
Hi,
I'm new to MySQL. I've installed MySQL on bothWin2000 and Solaris 2.8
machines. Everything locally works fine. When I tried to connect from
the Win2000 (dhcp-70-219) machine to the Solaris machine
I get the following error:
"ERROR 1130: Host 'dhcp-70-219' is not allowed to connect to thi
On Wed, 17 Jan 2001, Charles Crawford wrote:
> -
> I checked the log and saw this:
> 010117 16:24:54 mysqld started
> 010117 16:24:56 /usr/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 010117 16:24
hi george,
u might find "Monty all fired up over GreatBridge PostGreSQL benchmark
testing" at http://www.abriasoft.com/mysql_news_page.php?Id=7 interesting?
On Wed, 17 Jan 2001, Plytas, George wrote:
> this is a decent article for Postgres vs Mysql as requested.
>
> http://www.phpbuilder.com/
hi charles,
i thought by asking someone with a stable redhat 7 install to do a tree
-palug of the directory /var/lib/mysql so all could see the modes and
owner/group it would be helpful in solving your problem? also, the modes
and owner/group on /usr/libexec/mysqld.
i have not seen such a tree p
Hello.
I have been grappling with the Linux thread limit (1024 max) for some time with
little success. I believe I followed the instructions outlined in the Linux Notes
section of the manual. The newer kernels and glibc packages do not seem to correspond
exactly with the volano notes refe
this is a decent article for Postgres vs Mysql as requested.
http://www.phpbuilder.com/columns/tim2705.php3?page=1
-Original Message-
From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 4:34 PM
To: MySql list
Subject: MySQL vs. PostGress
Does some
This is a slightly biased overview of all the negative things about MySQL
vs. Postgress
http://openacs.org/philosophy/why-not-mysql.html
>
>
>
> Does someone want to point out the main differences or send me a link that
> might explain the differences of MySQL and PostGress. I am quite familia
We've just released (GPL) MysqlTool, a web-based management interface for
mysql written entirely in perl.
A more concise description of features, screenshots, the code, etc, is
available from http://www.dajoba.com/projects/mysqltool.
This is our first release of an open source project, so feedb
Does someone want to point out the main differences or send me a link that
might explain the differences of MySQL and PostGress. I am quite familiar
with MySQL, am happy with it, but with my new job, I have an option to go
with PostGress (which is what the Linux guys are suggesting).
Any how. T
Oh, I see. I've just checked the "Change Bit Integer Columns to Int" in the
ODBC Properties and have had no problems. Then again, I don't need the Big
Integer Data Type.
Lee
Hello, Lee,
I don't think the problem I'm having has anything to do with the ODBC
driver, because I used the same
Hello ,
I am new to this list and have an urgent question because I need to
get my problem fixed ASAP...
Well, I have a web server that hosts a huge number of guestbooks and
other homepage tools based on mysql. Every day approx. 20,000
connections to the mysql server are made and about one or tw
Description:
problems starting safe_mysqld --user=mysql &
How-To-Repeat:
OK, I tested this on two different servers and got the same results
with each. Both of the servers have a fresh install of RH 7.0 with
all of the rpm from the cd's. The version numbers for mys
Has anyone experienced problems using DBI and perl with update statements
not updating tables when the equivalent statement at the command line
works, and all other operations work perfectly?
Oliver Hinds
-
Before posting, ple
Hi,
I have searched the lists and have not found a solution to a problem ,
described in an ealier post, with which i am also suffering :
"I'm trying to install MySQL on redhat 6.2. I've tried the beta version
(http://www.mysql.com/downloads/mysql-3.23.html) and the stable version
(http://www.my
Hello, Lee,
I don't think the problem I'm having has anything to do with the ODBC
driver, because I used the same MyODBC driver under Windows 98, and I had no
problems whatsoever. Yes, I'm using ADO -- that explains why Access still
works. Somehow, there's some ADO functionality in Windows ME a
>From what I've read in the docs, this should work, yes?
select mcorder.ord_id, project.address, mcuser.last_name
from
project inner join
(mcuser inner join
mcorder
on mcuser.usr_id = mcorder.usr_id)
on project.prj_id = mcorder.prj_id;
Or am I just stoopid today?
---
With your VB App, are you using DAO or ADO? MS Access uses DAO to working
with ODBC while VB apps using ADO have problems with the MyODBC driver (at
least with me it did). I recently changed much code in my VB app to work
with MySQL from DAO to ADO. However, many methods aren't supported like
I use C++ Builder version 3 and myodbc to access a mysql database. As I
want to update some record, I receive the message record is already in
use by another user. I have defined a timestamp and an autoincremant
field in the table to access, but the problem still remains. I made the
tests with mys
Hi there,
On Wed, 17 Jan 2001, Sinisa Milivojevic wrote:
>
> First of all, you should not over-complicated things. Even in our
> server we do not call fork, as we have threads.
I don't want to call fork, because there are advantages of using threads
in this process (not involving mysql) that I
I noticed a little quirk when searching the manual...it seems that sometimes
when doing consecutive searches, the root directory disappears in the "href"
tags for the results:
for example resulting link will look like this:
http://p/e/Perl_support_problems.html
instead of something like
Hi,
I'm working on a SUN Sparc with Solaris 8
I've installed mysql-3_22_26a-sol8-sparc-local.tar.gz
I've downloaded the mm.mysql JDBC driver.
I'm trying to use MySQL whith WebLogic 6.0 for 2 days now but without
succes.
Does somebody have already done this ?
It's very urgent !
Thanks,
--
Pas
Hello,
I have written the program below and I have gotten it to compile and
run. However, it continually tells me that mysql server does not appear
to be running. I originally wrote this out of the MySQL book just to
test the DBI module and make sure everything would compile. Now, I just
want
Thank you, Quentin,
Hey, does anyone know where the problem lies here? Where in Windows ME /
2000? Why does Access still import OK? Is there something that needs to be
done with MyODBC to handle BIGINT types in the future?
Thank you,
Laszlo
- Original Message -
From: "Quentin Bennett"
Hi,
Don't you love M$.
ALTER TABLE CHANGE COLUMN myname myname INTEGER;
Regards
Quentin
-Original Message-
From: Laszlo G. Szijarto [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 January 2001 08:28
To: Laszlo G. Szijarto; [EMAIL PROTECTED]
Subject: Re: Windows ME / 2000 VB problem wit
Hello
> I need to be able to search (WHERE column LIKE 'search') in heading,
> body and/or author in all three tables, ORDER BY the latest date,
> and LIMIT 20.
MERGE table type is your friend, see section 8.2 of the manual.
Another possibility is to use a temporary table (CREATE TEMPORARY
TABL
Hi Nicolai,
Sorry for the delay in responding, I have been away on vacation.
FreeBSD 4.2 Release did have several threads problems related to the
compilers and the threads library. I have attacthed the commit log of
the fixes you are looking for and the minimum patch necassary
(patch-4.txt) to
I isolated the problem because if I do a
"select * from table" -- I get the error.
but if I do "select field1, field3, field4 from table", where I leave out
the BIGINT column, I'm fine.
and when I do a "select field2 form table" where field2 is the BIGINT
column, I get the same error
finally, I cr
I wrote to the list earlier on the above problem. I had a VB app that accessed a
mysql (on Linux) table through MyODBC. Apparently the problem is that the new ODBC
connection providers in Windows ME / 2000 do not like the BIGINT datatype. Yet,
strangely, MS Access 97 can import the data from
I have three tables of different data which I need to make a search in.
Every table has a column for date, heading, body and author.
I need to be able to search (WHERE column LIKE 'search') in heading, body
and/or author in all three tables, ORDER BY the latest date, and LIMIT 20.
If I want to m
Hello
> INSERT INTO new_table (campo1,campo2) SELECT (campo1,campo2) FROM old_table
^ ^
The 2nd set of parentheses should not be there.
> Mysql dont suport sub-querys yet, we will be waiting
It is not a subquery issue, see the section 7
You need to flush privileges after you add a new user.
FYI... Paul DuBois' mySQL book covers this in great detail and should be
considered the Bible for mySQL
Check the manual for flushing priliges if you don't have available access to
this book...
-Original Message-
From: Carlos Corz
Hello,
I am trying this security stuff out. Trial and error is the only way to
go.
I have logged in to mysql as root and then selected to use mysql table.
This is how I would grant priviledges to different users.
I used the commands successfully and typed:
insert into user
(Host,User,Password,S
Hello,
I am trying this security stuff out. Trial and error is the only way to
go.
I have logged in to mysql as root and then selected to use mysql table.
This is how I would grant priviledges to different users.
I used the commands successfully and typed:
insert into user
(Host,User,Password,S
According to MySQL rule, the column matching order in mysql database should be as
following:
++-+-
| Host | user|
++ +-
|localhost| |root ||localhost| | ||pit.sample.com |root
|||pit.sample.com | |
Carlos;
Carlos Corzo wrote:
> OK,
>
> I am just a bit confused still so I will try again. Do I need to stop mysql as it
> is running now before I start safe_mysql or will it just replace the current
> running version? Also, does it matter where I start it from? I can telnet to the
> server, e
I think you might be interested in some feedback after the newest PHP
snapshot with a fix was installed here.
The "Aborted connection ... (Got an error reading communication packets)"
messages disappeared. This may seem as expected behaviour. However there is
one additional point worth mentioning
Looks like this was my bad :)
Sorry,
Andi
At 01:47 AM 1/17/2001 +0200, Zeev Suraski wrote:
>Yep, you're right. Fixed.
>
>Thanks,
>
>Zeev
>
>At 23:24 16/1/2001, Steven Roussey wrote:
>> > OK. Look at a quick report. I've just installed php4-200101152345. It runs
>> > with mysql-3.23.27-beta. Apac
Yes stop the old and start the new...on a side note...should have bought
DuBios's book...ISBN: 0-7357-0921-1 Found it to be an invaluable source on
this sort of stuff. In any event safe_mysqld seems to be default on most
sytems...Yes please get you security straight...if the app is colocated on
th
OK,
I am just a bit confused still so I will try again. Do I need to stop mysql as it
is running now before I start safe_mysql or will it just replace the current
running version? Also, does it matter where I start it from? I can telnet to the
server, execute the command and then move on.
As
Dear list,
I'm new to MySQL and all of it's trappings.
Currently we're running PHP 3.x in conjunction with MySQL 3.22.22 and I need
to get better results from my text searches.
If anyone can help, thanks in advance.
Currently I'm "searching" a field in my DB using this type of query:
$searchQ
I'm running RH7 with the most recent updates to mySQL from RH's update
pages, but I'm still having problems accessing the SQL server through
the client as "myself" (root is fine, of course)
Even with full permissions,
I get
ERROR 2002: Can't connect to local MySQL server through socket
'/var/l
I have tried to make mm.mysql work with mysql
It seems to work if i grant to user@%, but not
user@localhost, or real host or localhost.localdomain
for that matter. I wonder what I should do to
allow it on localhost only... e.g. [EMAIL PROTECTED]
thanks :o)
versions??
mysql Ver 10.11 Distrib 3.2
Hi,
I was wandering if someone could help on this.
I am using mysql with php3 on a shared server, version 3.22.32
I had been running this for few days without any problems, but
when about 100 users were in to the database, the sign up form
at http://www.nettelephone.com/sign_up.php3 did stop
Posted for "De Q. Vo" <[EMAIL PROTECTED]>, who can't post to the list
because the list cop program doesn't like the netzero trailer:
Hello,
Is there an INDIRECT data type which can fetch and store data directly
from a file system? I wanted to build a dynamic web site with contents
derived from a
This is my first use of mySQL, so forgive my ignorance.
My problem is that I am not allowed to do anything as the new user I
just created.
The mysql utility refuses to allow access. Note that I did run
"mysqladmin reload" after granting privileges.
I have the mysql daemon running. I've crea
Please excuse me if I am a bit dense, but I thought I read on this group
that MySQL could not support enterprise java beans because MySQL lacked
transactions (yes I know about the gamma release, but its not production
quality in the transactions area last I heard).
On Tue, 16 Jan 2001, Van w
BD,
Sorry I can't help you with your corrupted data but here are some related
links for backing up MySQL data the proper way:
There are also some good "canned" shell scripts out there tha do what you
want as well.
It is a good idea to stop the server or lock the tables when copying or
backing up
Hi,
I guess you're talking about Views.
No, MySQL doesn't support views yetTo get arround it, put your query in
your script (php ?) and if needed, insert it into a heap table (check the
manual for heap tables).
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_
Hello Cindy,
I posted this in response to another date formatting question, hope it
helps.
The link should be helpful if you haven't found it already.
SELECT fields, DATE_FORMAT(datefield, '%M %d, %Y');
I just looked it up myself...It's all in the manual at:
http://www.mysql.com/doc/D/a/Date_an
[EMAIL PROTECTED] writes:
>It's (sort of) obvious what Cindy is looking for...
>
>In slightly clearer terms, is it possible to format a selected date using
>a
>format string similar to that available in C's strftime() function -
>where %M might stand for month name, %d might stand for day n
In the last episode (Jan 17), John Stumbles said:
> On 16 Jan 2001, Drew Wilder-Goodwin wrote:
> > what does a 'show processlist' reveal?
>
> I don't know: I restarted mysqld (and then when that didn't
> start properly rebooted the server, and then when that didn't come up
> again power cyc
Signing the applet will allow the applet to make the connection. The user
of the applet will have to accept and install the certificate use to sign
the applet.
- Original Message -
From: "Carfield Yim" <[EMAIL PROTECTED]>
To: "Paulo Mora de Freitas" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTE
Using Linux (Redhat 6.2) and MySQL-3.23.24-1
/ P
-- Forwarded message --
Date: Wed, 17 Jan 2001 16:35:04 +0100 (CET)
From: Paul Wisén <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Trim string problem
Hi everybody!
I can't find the solution to this problem.
Why is it doing
Kyle Cronan writes:
> Sinisa,
>
> My process has three threads and three different MYSQL structures.
> I have found that if I don't let the three mysql_real_connect() calls go
> one by one when I spawn the daemon, and then wait in each thread for them
> all to finish, I get an error that
Hello,
I bought MySQL by O'reilly. This thing is just as tough to read as the
manual but I am trying and utilizing both. When we installed MySQL on
our server, it seems to already be running. I was able to create a
database and everything so I assume that it is running. The book says
to run m
Hi everybody!
I can't find the solution to this problem.
Why is it doing this:
mysql> select trim('foo' FROM 'foobaar');
++
| trim('foo' FROM 'foobaar') |
++
| baar |
+--
Applet don't allow bulid new socket connection, which will do when you
make a connection from applet to database.
The solution is writing a servlet to let applet call it.
On Wed, 17 Jan 2001, Paulo Mora de Freitas wrote:
>
> Dear All,
>
> Could someone help me to access my mysql database from
It's a known bug with 3.23.22 - upgrade to the latest version (3.23.30?) and the
problem will go away. Please have a look at the upgrade history in the online manual.
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> Wolfgang Riedel <[EMAIL PROTECTED]> 2001/01/17 04:39:13 >>>
Hi,
after updating my my
> I've suffered thru the replication setup a few times recently. I am
> (tonight) attempting to update the MySQL manual to be more clear on
> some of the lessons I learned along the way. (I finally found a bit of
> the spare time I'd been hoping for...)
>
> If the MySQL team approves of the chang
Because it may update the table, it could compromise other processes
reading it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reque
Hi Cindy,
This might help... http://www.upan.org/rtfm/strftime.html
Cheers,
Mikel
Cindy wrote:
> OK. I went to the documentation at www.mysql.com and typed in
> DATE_FORMAT in the search box, hopefully find a list of the %M's, etc
> rules that may be used (I'd like December to become Dec,
Hi,
after updating my mysql server to version 3.23.22 on a linux box, I've
found the following problem:
select time_to_sec('03:53:00');
results with the correct value 13980.
But if I use a table of such time dates (in the simplest case: "create
table xy (st time); insert into xy values ('03:53:
Mysql no soporta sub-querys todavia, seguiremos esperando
Mysql dont suport sub-querys yet, we will be waiting
-Mensaje original-
De: Erick Tomás Izquierdo Cerra [mailto:[EMAIL PROTECTED]]
Enviado el: Wednesday, January 17, 2001 6:17 AM
Para: [EMAIL PROTECTED]
Asunto: bugs
no puedo eje
no puedo ejecutar la sentencia siguiente (I can't):
INSERT INTO new_table (campo1,campo2) SELECT (campo1,campo2) FROM old_table
Erick T. Izquierdo Cerra
Ing. Automática.
CITMATEL.
no puedo ejecutar la sentencia siguiente (I can't):
INSERT INTO new_table (campo1,campo2) SELECT (campo1,campo2) FROM old_table
Erick T. Izquierdo Cerra
Ing. Automática.
CITMATEL.
Rick Pasotto writes:
>
> Which applies to *all* columns, not individual ones.
>
> > But all column widths are resizeable, of course.
>
> What is this "of course" bit? There is no "of course."
>
> If you mean resizing with the mouse - of course I tried that.
>
> It didn't work.
>
This could also be related to hard coded thread limits in the linux kernel (which will
need a kernel recompile) and glibc libraries. The library issue will only come into
play if you compiled your own Mysql. This has been discussed previously on this list.
Search the archives at http://lists.my
Read the footer of EVERY message sent to the mysql list Including this one.
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> "Tomas Mas-Esteve (ECE)" <[EMAIL PROTECTED]> 2001/01/17 03:51:45 >>>
Hello,
is a archive where all the mails sent to mysql list are stored?
if yes, where is the archive and
Hello,
is a archive where all the mails sent to mysql list are stored?
if yes, where is the archive and how con I access to it.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
Please check the archive.
I posted a few functions last week that may be of use to you. Don't want to
re-post since your question is slightly OT.
Good luck,
Dennis
***
Beridney Computer Services & Beridney Talent
http://www.beridney.com
-
Hi there
I wonder how I step by step, connect to MySQL trhough Visual Basic 5.0?
I'm a newbe in MySQL... but I have knowledge of how to use Access database.
/Gustav Wiberg
-
Before posting, please check:
http://www.mysql.c
1 - 100 of 118 matches
Mail list logo
