Hello all,
I wud like to know one query by which i can
copy/create the same table from existing table.
Rgds,
Jenny
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
* Jenny Christy
I wud like to know one query by which i can
copy/create the same table from existing table.
CREATE TABLE newtable SELECT * FROM oldtable
URL: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
--
Roger
-
Hello Sinisa,
have you already found the origin of the problem ? How does the bugs get
fixed - are they solved in patch releases or are they solved in a next
release of the MySQL server ?
Kind regards,
Ismaël
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent:
Hello
I have created a table:
CREATE TABLE data (no int auto_increment, topic text, author text, date date,
description text, file text, note longtext, name varchar(15), password (15),
folder text, key(no), FULLTEXT(topic,author,description,file,note));
Then, I would like to a FULLTEXT SEARCH
Hi all again,
I've been experimenting and would like to know if there is a known bug in
the std function when used with a group by clause?
I'd like to know if others have found this problem or is it just me:
I have a query without a groupby clause and the avg and std functions work
fine.
I add
Hi all im aware this might not be the correct forum but i believe it's
the same beast and it should be ansewered quite easily .
I have been creating a M$ Access Front-end database with a MySql
Back-end that im about to upload onto a ISP that supports Mysql/Php thus
i have just downloaded
Hi all im aware this might not be the correct forum but i believe it's
the same beast and it should be ansewered quite easily .
I have been creating a M$ Access Front-end database with a MySql
Back-end that im about to upload onto a ISP that supports Mysql/Php thus
i have just downloaded
Hi,
I have 2 tables, X and Y.
table X table Y
++---+ ++---+
| id | title | | id | assoc |
++---+ ++---+
| 1 | one | | 1 | 3 |
| 2 | two | | 2 | 3 |
| 3 | three | | 2 | 4 |
| 4 | four | ++---+
| 5 | five |
Hi,
This is my first post...
I'm on redhat 7.2, using apache 1.3.23 (patched)
on a PowerEdge 2500 in RAID 1 and I want to install
MySQL 3.23.51...
Must I set to configure the --with-raid ?
Do you have good link for documentation ?
I reach for in google...i'm late...
thanx
bbsc
ism
hi guys
im trying to retrieve 5 record each page from my db
my code iz :
$query_nme = SELECT firstName, lastName, title, summary FROM ctnt_inf
where ctnt_id ORDER BY RAND() LIMIT 5;
$query_result_handle_nme = mysql_query ($query_nme)
or die ('qry failed ! DA tbl
RAID --with-raid splits tables up to stop size problems or put one table on
more than one disk.
So is not required for hardware raid.
Simon
-Original Message-
From: Ismael Touama [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2002 10:26
To: [EMAIL PROTECTED]
Subject: RAID
Hi,
This is my
Ok so it's to emulate it following you explanation.
That's OK, I enter the line (without this option).
thx
bbsc
ism
-Message d'origine-
De : Simon Green [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 9 juillet 2002 11:42
À : 'Ismael Touama'; [EMAIL PROTECTED]
Objet : RE: RAID
RAID
Description
Having followed the instructions in section 5.2.8 to create a table using
LOAD
DATA INFILE *without* its indexes, the indexes are *still* created at the
end
of the LOAD DATA INFILE statement
How-To-Repeat:
The following shell script demonstrates the problem. There are two directory
* Ismael Touama
This is my first post...
I'm on redhat 7.2, using apache 1.3.23 (patched)
on a PowerEdge 2500 in RAID 1 and I want to install
MySQL 3.23.51...
Must I set to configure the --with-raid ?
No, this is only if you need support for tables with file size bigger than
your OS can
ismaeel
Do you have good link for documentation ?
http://www.mysql.com/doc/C/o/Configuring_MySQL.html
good luck
toby .
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
Hi,
I am a student, I am due to return for my final year where I must
complete a final year project. I have decided to develop a JSP website
connected to a database.
I have installed TomCat and have been recommended to use MySQL. I have
downloaded MySQL but I would like help on how I would
if this interests you at all, i found this yesterday on the evolt.org
mailing list. the gentleman who has put this very useful code basically
suggested that i could base36 my auto_increment IDs. i will leave this
here for those of you who are intersted:
toby - [EMAIL PROTECTED] wrote on 09.07.2002 11:35:40:
Hi Toby,
hi guys
im trying to retrieve 5 record each page from my db
my code iz :
$query_nme = SELECT firstName, lastName, title, summary FROM ctnt_inf
^^
I think you should include id, to get the row id
where
I want to create a CD-ROM which contains a copy of MySQL (for
Windows) and a set of MySQL databases. Is it possible to set up
a read-only MySQL, that is, a MySQL running from a r/o media?
Kristian
-
Before posting, please
Hi!
Thank you for your test case, thanks to which this bug was solved.
Full fix will appear in the next 3.23 and 4.0 releases.
This is a patch :
= sql_table.cc 1.101 vs edited =
*** /tmp/sql_table.cc-1.101-460 Mon Feb 11 12:56:48 2002
--- edited/sql_table.cc Mon Jul 8 22:05:06
Cams Ismael writes:
Hello Sinisa,
have you already found the origin of the problem ? How does the bugs get
fixed - are they solved in patch releases or are they solved in a next
release of the MySQL server ?
Kind regards,
Ismaël
Sorry to have lost your e-mail.
If that is about BDB
Is there a way of turning on the general query log in the my.cnf file
or do I have to edit the init-script?
Personally, I would very much like to have only one place to set all
the configuration options (preferrably my.cnf). Setting datadir and
other options both in the my.cnf file and the
Hello Sinisa,
the problem I had was that after I restarted mysqld (after have
dropped/added a column) my data was dissapeared. So if you meant this
problem I am indeed the right person.
How do I apply this patch ?
Kind regards,
Ismaël
-Original Message-
From: Sinisa Milivojevic
You check index files, not table names.
myisamchk -k 0 -rq $MYSQLDIR/test/BestGuess.MYI
Archer Barrie wrote:
Description
Having followed the instructions in section 5.2.8 to create a table using
LOAD
DATA INFILE *without* its indexes, the indexes are *still* created at the
end
of the LOAD
what is generally better to use:
- one field of type 'set' (eg.: 'apples','cherries','pears','bananas')
- or multiple fields of type true/false for each value above?
just to make sure, mysql doesn't store each value selected in the set in each record?
or does it?
thanks,
marko
Hi guys,
I am trying to install MySql on Linux (Mandrake 8). And everytime
when I try to start the server. like this
[mysql@127 support-files]# ./mysql.server start
I get the message like:
./mysql.server: @hostname@ command not found
./mysql.server: my_print_defaults command not found
Chuck,
- Original Message -
From: Chuck Simmons [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, July 09, 2002 4:29 AM
Subject: possible bug: alter table trashed foreign key constraints in innodb
sql query
In version 3.23.49a when using an innodb table, alter
Chuck,
- Original Message -
From: Chuck Simmons [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, July 09, 2002 5:24 AM
Subject: minor enhancement request -- adding files to innodb
As a minor enhancement, the innodb database could look at improving its
handling of
* Marko Djukic
what is generally better to use:
- one field of type 'set' (eg.: 'apples','cherries','pears','bananas')
- or multiple fields of type true/false for each value above?
Field type SET, because the field types BIT and BOOL are 'fake' (synonyms
for TINYINT), occupying a full byte
William,
I assume you are compiling with the -O3 gcc flag? Otherwise gcc does not
handle 'extern inline' functions right.
The problem is probably that your gcc/libtool/linker is configured in a way
that it does not do inlining as instructed by the 'extern inline' directive,
or it removes the
Hi,
I´ve emailed the list but my problem doesnt seem to have catch much
attention. I guess a re-phrasing might help.. It´s pretty
simple (I´m using myODBC 3.51 and VC++ 6.0 ) : how do I declare and bind
variables/parameters for a TIMESTAMP column?
Here´s what I´ve done so far: I declare my
Hi all!
I have a user that I am specifying for one database within the system. I
have granted, reloaded, deleted, re-done, and screamed at the server. None
the less, it still will not allow this user to do mysqlimport, as follows;
mysqlimport --user=rcr_user --password=thepassword -f
if you don't restart MySQL after changing the grants priviliges, you have to issue the
flush privileges command from the MySQL Monitor. If you don't do either one your
privilege changes will not take affect.
not sure if when you said reloaded you meant flush privileges but if not try it
and
[snip]
if you don't restart MySQL after changing the grants priviliges, you have to
issue the flush privileges command from the MySQL Monitor. If you don't do
either one your privilege changes will not take affect.
not sure if when you said reloaded you meant flush privileges but if not
try it
Chuck,
Tuesday, July 09, 2002, 4:26:31 AM, you wrote:
CS In version 3.23.49a when using an innodb table, alter table appears to
CS corrupt foreign key constraints. Try the following test case:
It's described in the MySQL manual:
http://www.mysql.com/doc/S/E/SEC446.html
and fixed since
jusob,
Tuesday, July 09, 2002, 10:20:36 AM, you wrote:
j I have created a table:
j CREATE TABLE data (no int auto_increment, topic text, author text, date date,
j description text, file text, note longtext, name varchar(15), password (15),
j folder text, key(no),
Rafal,
Monday, July 08, 2002, 4:44:32 PM, you wrote:
RJ mysql version 3.23.50
RJ Field kwData_wydania is of type date. As you can see, dates are different that
RJ expected. Is this a bug?
Nope. Check the manual:
You should never have any conditions in the ON part that are
used to
Chuck,
Tuesday, July 09, 2002, 5:17:49 AM, you wrote:
CS The current mysql interfaces don't support multiple servers in a
CS fantastic fashion -- either multiple servers on a single machine or
CS multiple servers on multiple machines. It may be there is no great way
CS to do this, but...
David,
Tuesday, July 09, 2002, 12:04:52 AM, you wrote:
DK I keep getting Access Denied Errors when I try to login to MySql after
DK running mysql_install_db script. I ran the mysql_install_db script, made
DK suer the mysql process is running(checked it using netstat -a), changed the
DK
The user might need the FILE permission, I'm not sure.
Also might need the LOCK TABLES permission.
http://www.mysql.com/doc/G/R/GRANT.html
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Jay Blanchard [mailto:[EMAIL
Hi,
- Original Message -
From: Jay Blanchard [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 7:01 PM
Subject: Grants UGGH! Not working for some reason ...
Hi all!
I have a user that I am specifying for one database within the system. I
have granted, reloaded,
Hi
Thanks for all your help, much appreciated.
I edited my both the /etc/resolv.conf and /etc/hosts to include the line
'hostname 142.135.134.154'
of course, that's not my real ip addy. Am i suppose to edit these files? or
did you mean to edit the /etc/sysconfig/network file. THe
[snip]
if you don't restart MySQL after changing the grants
priviliges, you have to
issue the flush privileges command from the MySQL Monitor.
If you don't do
either one your privilege changes will not take affect.
not sure if when you said reloaded you meant flush
privileges but
[snip]
I have a user that I am specifying for one database within the system. I
have granted, reloaded, deleted, re-done, and screamed at the server. None
the less, it still will not allow this user to do mysqlimport, ...
[/snip]
Figured it out. The user must have FILE privileges in order to
Oï,
I just configure my Makefile (is that the good one ?),
and I obtain the following errors...
make[2]: *** [libmysql.lo] Error 1
make[2]: Quit the '/root/MySQL/mysql-3.23.51/libmysql' directory
make[1]: *** [all-recursive] Erreur 1
make[1]: Quit the '/root/MySQL/mysql-3.23.51' directory
make:
I was able to login and generate a database instance, but then got a little
crazy and tried to automate the starting and stopping of the mysql service.
I copied the mysql.server file to my /etc/init.d directory and then created
the necessary links to the rc0.d and rc3.d directories. When I
Hi,
I've continued trying to solve the problem that I emailed yesterday
regarding AUTO_INCREMENT, and I just seem to be going backwards.
The sample database/software that I sent yesterday had a UNIQUE
constraint and a couple of SELECT statements. I thought that removing
them bizarrely made
Victoria thanks for the response but I was able to solve my issue already.
Yes I needed to run mysql_install_db then I started the safe_mysql
--skip-grant, logged on as root without password and updated the root user's
password on the user table. Thanks for the help!!!
DK
David
-Original
Hi all,
Sorry should have got my mind around the LOAD_FILE('./image.tiff')
method.
M.
In message [EMAIL PROTECTED], Mark Worsdall
[EMAIL PROTECTED] writes
Hi,
After a good old slurp of an image I am trying to stick it into my
table.
# Slurp file
foreach (@image_list) {
my $image =
Håkon Eriksen wrote:
Is there a way of turning on the general query log in the my.cnf file
or do I have to edit the init-script?
Yes, all command-line options can be specified in my.cnf. Read the
following page for more info:
http://www.mysql.com/doc/O/p/Option_files.html
-myk
Hello list.
At the end of a db programming job (using php) I have been asked for a document
describing in details the structure of a MySQL database.
The purpose of the document is to make other DB people able to manage and interface
the database (I can figure out that there is also the intent
Hi,
I'm using the MySQL built-in C function, mysql_data_seek, for accessing a
particular row from the Result (MYSQL_RES) returned by mysql_store_result.
int sql_result;
MYSQL_RES *MResult;
MYSQL_ROW row;
MYSQL
I'm not very sure of myself ... but maybe you'd try to use quotes around the
file path?
--
Alle door mij verzonden email is careware. Dit houdt in dat het alleen
herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde
en daar buiten. Als je het hier niet mee eens
List,
I'm looking for a developer in eastern Massachusetts with the following
skills to work on some ongoing projects:
MySQL
Oracle
CGI
Perl
PHP
Java
JSP
C++
This is a contract position. Resumes can be sent to
[EMAIL PROTECTED]
I have a fairly basic question: How do I sort
numerically? Normally when I query using ORDER BY
(field), it orders by the first digit (i.e. 1, 10, 2,
21, 3, 32) rather than by number (1, 2, 3, 10, 21,
32).
Thanks for any help
Dave
__
Do You
Hi.
I keep getting Lost connection to MySQL server during query
marcos:mysql-3.23.51 {117} mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server during query'
Server timeout is set for 8 hours (default) and I have been trying
to hit the
It looks like your field is a text field rather than BIGINT or some
numerical field. Changing the field type should solve your problem.
Serge.
- Original Message -
From: CVIOG at UGA [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 4:22 PM
Subject: Basic Q's:
Here is the solution I posted about t months ago. I would also add, this solution can
handle both text and numbers in the same field...:
my boss figured out a nice solution to this
ORDER BY IF(ABS(Item) 0,LPAD(Item,9,'0'),Item)
This will pad numbers ( ok it might not do so hot with DECIMAL,
In the last episode (Jul 09), CVIOG at UGA said:
I have a fairly basic question: How do I sort
numerically? Normally when I query using ORDER BY
(field), it orders by the first digit (i.e. 1, 10, 2,
21, 3, 32) rather than by number (1, 2, 3, 10, 21,
32).
Either alter the table to make that
Is there anything in the error log?
See mysql/data/hostname.err
-M
On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
I keep getting Lost connection to MySQL server during query
marcos:mysql-3.23.51 {117} mysqladmin version
mysqladmin: connect to server at 'localhost' failed
No, nothing other than the startup and shutdown messages.
And every once and a while:
020708 21:00:46 Error in accept: Bad file descriptor
But this doesn't happen all the time after restarting the database and I
still
have problems so I don't think that this is related.
Thanks!
-- Steve
People,
there is a new tool on the site:
http://geocities.yahoo.com.br/burbello/
it's worthwhile.
sql, query
___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/
Hi,
It's ok but you must retrieve data from row.
int sql_result;x,i;
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);//mysql_store_result return in
This returns
mysql Select Field1, Field2, MAX(IDField) From amain Group by Field1;
+++--+
| Field1 | Field2 | MAX(IDField) |
+++--+
| A | 1 |4 |
| B | 7 |8 |
| C | 1 | 12 |
Hi Francico, yes that would work. Thanks. The only thing I don't like is
created a 200,000 record temporary table.
I may have a different solution, will post it soon.
-Original Message-
From: Francisco Reinaldo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 10 July 2002 02:22
To: Miles
There appears to be an undocumented change from 3.23.49 to 3.23.51,
possibly for the worse.
Consider two sessions executing the following sequence of commands on an
innodb table (assume maximum ACID properties):
session 1 begin;
session 1 update table set field = field + 1 where
Hi,
My opinion:
This can be a very good reason to kill the socket(is a file too) which is
open during query.
This error show you that you have too many open files in the system.I tested
something like this(Linux - Red Hat 7.2) some time ago and after 2000 (this
mean sockets) clients connected
Hi All,
Well I think I actually managed to fumble my way to a solution to this. I
took the example avg_cost UDF function and modified it somewhat (well,
hacked it to pieces). I've tried this before but I actually tried to
rewrite it, bad mistake. This time I just deleted all the bits I didn't
Hi,
These tools are not open source:
http://www.thekompany.com/products/dataarchitect/
You can download the evaluation. It supports MySQL
directly:
http://www.datanamic.com/download/download_dezign.html
If you are not familiar with database methodology and
relation entity diagrams, I
Hi all,
I would like to confirm that MySQL only allows putting COMMENT in TABLE
LEVEL but not in COLUMN LEVEL. Am I right?
Regards,
Michael
---
Michael Tam - NFI
Chuck,
- Original Message -
From: Chuck Simmons [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 10, 2002 1:08 AM
Subject: undocumented change in behavior?
There appears to be an undocumented change from 3.23.49 to 3.23.51,
possibly for the worse.
Consider
Description:
I was trying to find every row in a table which contains the umlaut
ü (ue). MySQL listed every row which contained the umlaut and rows
which contained the letter y, but no umlaut... Client and server
characterset is latin1.
How-To-Repeat:
I posted a couple of days ago on what appears to be a bug in
drop database of mysql-max-4.0.1-2. Here is a recipe to
see if others are seeing the same problem.
This is on Red Hat Linux 7.2 and is extremely repeatable
nor is it limited to a single linux box (ie. not likely
hardware problem).
Kristian:
Possible? I suppose, but not very practical. It would be
ssllooww, you'd need to supply an application to permit
access to the data, and how would you handle licensing?
Gerald Jensen
- Original Message -
From: Kristian Koehntopp [EMAIL PROTECTED]
To: MySQL
Like Kristian says,
I don't see why you couldn't do something like that, Though you may
want to setup mysql to have a very large amount of cache to pool from
this way you can speed performance of it.
Gerald R. Jensen wrote:
Kristian:
Possible? I suppose, but not very practical. It would
Is there a query to update record by specify the position of record or row?
update tableA set col_name = somthing ...( at row number 123)
thanks for help!
Regards,
_
MSN Photos is the easiest way to share and print your photos:
In the last episode (Jul 09), Pichan M. said:
Is there a query to update record by specify the position of record
or row?
update tableA set col_name = somthing ...( at row number 123)
SQL tables do not have row numbers. The only way to absolutely
identify a record is by a unique ID in the
Hi All,
I have 3 mysql servers with Red Hat 7.2 as the OS (Mysql-3.23.49). I am
naming the 3 PCS as A,B and C. I have a table named files-info in all the 3
mysql servers. My requiremnet is I want two way replication between A to B
and A to C. Now I have two way replication between A to B. I want
I am using MySql with InnoDB and have just discovered
that tables created using char types show up as
varchars when I type, describe tableName. Previously,
I was using MyIsam tables and did not see char types
being changed to varchars so I am a bit puzzled.
This is true for almost all of the
Description:
I have been writing an SQL tokenizer for the phpMyAdmin project, on which I am
a core developer.
I used this page (Manual 6.1.2 Database, Table, Index, Column, and Alias Names) for
reference
as to what a valid token was. As well as this reference on SQL User Variables
In the last episode (Jul 09), Michael Ivanyo said:
I am using MySql with InnoDB and have just discovered that tables
created using char types show up as varchars when I type, describe
tableName. Previously, I was using MyIsam tables and did not see
char types being changed to varchars so I
In my mysql dump of a DB using the -B switch, I get
CREATE DATABASE /*!32312 IF NOT EXISTS*/ sfyc;
What is the significance of /*!32312 IF NOT EXISTS*/ - the /*!32312? Isn't
the statement commented out?
With the CREATE TABLE, what happens if the table already exists?
Todd
--
Todd Cary
At 01:15 PM 7/9/2002, you wrote:
Hello list.
At the end of a db programming job (using php) I have been asked for a
document describing in details the structure of a MySQL database.
The purpose of the document is to make other DB people able to manage and
interface the database (I can figure
At 10:19 PM 7/9/2002, you wrote:
I am using MySql with InnoDB and have just discovered
that tables created using char types show up as
varchars when I type, describe tableName. Previously,
I was using MyIsam tables and did not see char types
being changed to varchars so I am a bit puzzled.
This
On Tue, Jul 09, 2002 at 08:51:05PM -0700, Todd Cary wrote:
In my mysql dump of a DB using the -B switch, I get
CREATE DATABASE /*!32312 IF NOT EXISTS*/ sfyc;
What is the significance of /*!32312 IF NOT EXISTS*/ - the
/*!32312? Isn't the statement commented out?
That's a hint to MySQL
I downloaded mySql++ for mac OS X. It didn't give me any header files
but the examples required them. Where can I get those or do I not need
them?
===
Hari Dass S. Khalsa
[EMAIL PROTECTED]
-
Before posting, please
Hi,
I would like to export Table Data which is on my
localhost mySQL Server, to a Table in mySQL on the
Internet Web Server. How can i do that? Basically it's
just moving mySQL Table Data from localhost to web
server on the internet! Is it possible? if so, how?
Thanks,
T. Edison Jr.
87 matches
Mail list logo