on 8/6/01 10:13 PM, Trond Eivind Glomsrød at [EMAIL PROTECTED] wrote:
Ling Wang [EMAIL PROTECTED] writes:
I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was
installed together with the Redhat Linux. I can not start the mysql
server by executing /usr/bin/safe_mysqld .
Date |Fri, 3 Aug 2001 17:21 +0200
From |TIGNAC BRUNO [EMAIL PROTECTED]
Hello!
TB --- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21
TB Hello,
TB I plan to use MySQL/InnoDB to store about 13 GB of data, into 40 tables. One
TB of the tables is over 5 GB, and a second
Anyone seen this in your log file before?
It's perlscripts on the same host, so before the DBI
routine all the data needed for an insert is on the
machine, not like it's loggin in from another machine.
Could this be a problem with the loop back device? Any
other ideas as to what causes mysql to
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
-- http://lists.mysql.com/ (the list archive)
DS wrote:
Anyone seen this in your log file before?
It's perlscripts on the same host, so before the DBI
routine all the data needed for an insert is
Description:
I tried to compile the mysql client stuff.
The first configure command was:
./configure --prefix=/jaw0_3/jops/verkout --without-server --without-docs
--without-bench --without-debug --with-pthread
This (obviously) did not fully work. Almost
I was wondering what would be a better database design for long term
performance growth.
Design A:
Data Mapping
Definitions
Three Tables: Corporation ID 1 -- many Corporation ID
Corporation Data Code ID 1 -- 1
Code ID
hello,
i must convert a Web application from Unix to Windows NT.
The application is in C (cgi) and uses the library libmysqlclient.a
But this library doesn't exist in the Windows version of MySQL.
Somebody could help me ?
Thank you
N.G.
Hi,
i just tried using INET_ATON() and INET_NTOA() and i keep getting syntax
errors
snip
am i missing something easy here? is this a known issue? perhaps a version
thing? i am running 3.22.32.
Yes, you are missing something. If I may quote from the manual - in section
F.2.20, Changes in
Hi
On Tuesday 07 August 2001 07:23, mike cullerton wrote:
i just tried using INET_ATON() and INET_NTOA() and i keep getting syntax
errors
near '(100.100.100.100)' at line 1
no manner of quoting that i can think of solves this. i tried the examples
at the bottom of
Is it possible for mysql 3.23.40 to support SSL.
hm, how?
i guess..
i will download, openssl? first.
then
./configure -- etc
make
make install
then, download the mysql source.
then..
./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldfla
gs=-all-static
I think this is supported from 3.23...not sure though, but might be:-)
hey folks,
i just tried using INET_ATON() and INET_NTOA() and i keep getting syntax
errors
near '(100.100.100.100)' at line 1
no manner of quoting that i can think of solves this. i tried the examples
at the
Hi Venu,
I want some sample codes for ODBC connection to MySQL. Where can I get it?
R.Srivatsan
[EMAIL PROTECTED]
-
Before posting, please
I have a general how do you do that SQL question.
I have a table with links in it. One link per row, with URL link name, etc.
The client wants to be able to specify the order in which the links appear.
In other words, they want to set any link to show up first, another other
link to show up
I've tried mysqldump, it worked perfectly, my data is now on the new machine.
I did have to alter the output file so the tables in the mysql database where
recreated without error.
(eg adding drop table columns_priv; before the CREATE TABLE columns_priv;
line)
What I want to know now is why
Colin Faber schrieb am Dienstag, 7. August 2001, 09:29:45:
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
-- http://lists.mysql.com/ (the list archive)
Very nice hint, indeed, I didn't think of it before, and I
experience these things, too. So I
Hi folks,
Can someone please point me in the right direction to let me know how to
define a relationship between tables in MySQL eg one-to-many. I haven't
come across it in the manual yet, but am sure it must be there somewhere.
Many thanks in advance,
Chris Malloch
- Original Message -
From: Grigory Bakunov [EMAIL PROTECTED]
To: SDiZ Cheng [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 1:16 PM
Subject: Re: Localization..
Date |Tue, 7 Aug 2001 04:01:17 +0800
From |SDiZ Cheng [EMAIL PROTECTED]
Hello!
SC I have a table
Hello mysql,
It seems like you made an incomportable changes in 3.23.40 without
taking a time to write a release note :(
The mysql 3.23.39 used the system timezone by default:
maindb:/spylog/mysql/logs # date
Tue Aug 7 13:31:56 MSD 2001
| transaction_isolation |
My company just stole my web server running MySQL. I will now have to
host my site on a consolidated server that has MS SQL Server.
How do I migrate? I think my SQL code will be good except for
auto_increment, but are there any migration tools?
Frank Fisher
I have a table that includes a device ID (indexed) and the name of the
device with multiple records ordered over time. How can I retrieve the last
record for each device ID without retrieving them all to find the most
recent name?
Eldon Ziegler
ProAtion Systems
[EMAIL PROTECTED]
Halim Chtourou writes:
I was able to compile and install the MySQL++ API on my Mac OS X system,
however, whenever I try to run a program linked against the library, I
get undefined symbol errors.
dyld: bin/wopsql Undefined symbols:
[EMAIL PROTECTED] writes:
Description:
I tried to compile the mysql client stuff.
The first configure command was:
./configure --prefix=/jaw0_3/jops/verkout --without-server --without-docs
--without-bench --without-debug --with-pthread
This (obviously) did not
I shut the server down but did not flush the tables, presumably that
shouldn't matter (data saved to disk at server shutdown) ?
Also if I replace the binary files (debian) on the old server with the new
compile I can restart sql (now source build) use my databases perfectly,
its only when I
Hi
Im trying to convert an oracle database to a mysql database, and have run in
to the problem that oracle alows more signs in some types for some columns
than mysql do, now I heard that it is possible to change the max length
paraeter before compiling the mysql server, do enyone know witch
SRIVATSAN RAGHURAMAN writes:
Hi Venu,
I want some sample codes for ODBC connection to MySQL. Where can I get it?
R.Srivatsan
[EMAIL PROTECTED]
To connect from Unix or from Windows ??
--
Regards,
__
You need to call .next() and check to see that true was returned on your
ResultSet before trying to read any data from it (see the api-docs for
java.sql.ResultSet for more information)
-Mark
-
Before posting, please check:
Hi All
Currently I have rented space on a Web Server that has MySql installed and
PHP, They have created a database directory for myself. Do I need to install
Mysql and PHP locally to take advantage of this. If so where do I start. I
have had no experience of the above two products, although I
Hi Sinisa,
Sorry I should have mentioned this earlier. From Windows.
R.Srivatsan
[EMAIL PROTECTED]
___
Sinisa Milivojevic [EMAIL PROTECTED] Wrote---
(I'm sorry if my question does not fit to this
mailing list)
Hi~ there.!
Is there A Book about implementing RDBMS?
I just found Database System Implementation
written by Ullman.
looking for another Book if there is.
Monty, What's the Best Resource(helping you) when
you have started making
Hello Sinisa,
Tuesday, August 07, 2001, 4:48:56 PM, you wrote:
1) SUSE. Destributions does not have TZ variable set by default. And
the idea is it worked quite well wothout it with .39
2) The strange thing is why settng TZ makes mysql to print correct
timezone in variables but still produces
Den 01-08-07 14.57, skrev Anders Alstrin [EMAIL PROTECTED]:
Does anyone know how to do this sub select in MySQL.
I know how to do it in Oracle!
table media
+--+---+--+
| media_id | price |filename |
+--+---+--+
|3 | 0 | cal.jpg |
|
Is it possible to open two recordsets for the same table without closing the
first one?
With Regards
Priti
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi!
"Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:
Peter Hello mysql,
Peter It seems like you made an incomportable changes in 3.23.40 without
Peter taking a time to write a release note :(
Peter The mysql 3.23.39 used the system timezone by default:
Peter
I don't think MySQL supports sub selects.
Tyler
On Tue, 07 Aug 2001 14:57:33 +0200
Anders Alstrin [EMAIL PROTECTED] wrote:
Does anyone know how to do this sub select in MySQL.
I know how to do it in Oracle!
table media
+--+---+--+
| media_id | price |filename |
Peter Zaitsev writes:
Hello Sinisa,
Tuesday, August 07, 2001, 4:48:56 PM, you wrote:
1) SUSE. Destributions does not have TZ variable set by default. And
the idea is it worked quite well wothout it with .39
2) The strange thing is why settng TZ makes mysql to print correct
timezone in
Good Morning -
Thank you so much, your suggestion worked perfectly!
Best Regards,
Rob
--- Grigory Bakunov [EMAIL PROTECTED] wrote:
Date |Mon, 6 Aug 2001 14:46:13 -0700 (PDT)
From |Rob Doornbos [EMAIL PROTECTED]
Hello!
RD Good Afternoon -
RD I receive the following error when
No need to install locally. You could write everything locally, upload it
to the server, and see if what you wrote works.
Tyler
On Tue, 7 Aug 2001 13:51:01 +0100
Matt Gaskin [EMAIL PROTECTED] wrote:
Hi All
Currently I have rented space on a Web Server that has MySql installed
and
PHP,
Is there a method I can use to log into a remote mysql server through something such
as telnet to pass queries on my database?
On 07 Aug 2001 07:24:59 -0400, Eldon Ziegler wrote:
I have a table that includes a device ID (indexed) and the name of the
device with multiple records ordered over time. How can I retrieve the last
record for each device ID without retrieving them all to find the most
recent name?
I
Peter Zaitsev writes:
Hello mysql,
It seems like you made an incomportable changes in 3.23.40 without
taking a time to write a release note :(
The mysql 3.23.39 used the system timezone by default:
maindb:/spylog/mysql/logs # date
Tue Aug 7 13:31:56 MSD 2001
|
you can rewrite this query to simple joins so you dont use sub selects.
select media.media_id , media.price, media.filename
from media,category_locks,categories
where media.media_id = category_locks.media_id
and category_locks.category_id = categories.category_id
and categories.dynamic_media =
Matt:
MySQL and PHP are both 'server-side' components, so there is no need to
instal them locally (unless, of course, you want to do your development and
testing off-line).
If you are doing any significant level of PHP work, I would suggest
installing a local version of both MySQL and PHP. I
Hello Michael,
Tuesday, August 07, 2001, 10:20:18 PM, you wrote:
OK guys I think I've found the problem.
It seems like new innodb version (40b) does something bad with time.
I've tested 3 binaries
1) Plain .40 with normal GLIBC - OK
2) Plain .40 with patched GLIBC - OK
3) Plain .40 with new
Hello,
SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc
gcc version 2.95.3 20010315 (release)
I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box.
I get the following error which has me completly confussed:
ctstset: Compile tstset.cc -- tstset.[c|s] -- tstset.o
Assembler:
On 07 Aug 2001 22:18:04 +0900, Heo, Jungsu Mr. wrote:
Umm. MySQL AB Has any plan to make MMDB or Embedded DBMS?
(Last month's survey asked us 'bout Embedded DBMS)
Yes we are working hard to get embedded MySQL version possible in MysQL
4.0. This should make life easier for many software
Anders Alstrin [EMAIL PROTECTED] writes:
Does anyone know how to do this sub select in MySQL.
MySQL doesn't have subselects. Some workarounds can be found at
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Missing_Sub-selects
PostgreSQL supports them.
--
Trond
On 07 Aug 2001 14:57:33 +0200, Anders Alstrin wrote:
SELECT * FROM media
WHERE media_id = (SELECT media_id FROM category_locks
WHERE category_id = (SELECT category_id FROM categories
WHERE dynamic_media = 'true'))
A MySQL way to do it?
Something like that should work:
SELECT * FROM
Hi!
No idea what is wrong. Below is the code which
prints the timestamp in InnoDB:
.
struct tm cal_tm;
struct tm* cal_tm_ptr;
time_t tm;
time(tm);
#ifdef HAVE_LOCALTIME_R
localtime_r(tm, cal_tm);
cal_tm_ptr = cal_tm;
#else
cal_tm_ptr = localtime(tm);
#endif
Hi,
Could you create a linked list of the links- i.e. have a 'Next' field,
which contains the ID of the next URL in order. You will also need a
field to store if the link is the first (i.e. root) of the list. Then
you can just iterate though the rows, using the next field to tell you
which URL
Is there an easy way or perhaps a utility to import a tab delimeted text
file of data into a mysql table
Thanks,
--
Kevin Fonner
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
chown -R mysql /var/lib/mysql
Ling Wang wrote:
I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was
installed together with the Redhat Linux. I can not start the mysql
server by executing /usr/bin/safe_mysqld . It always ends immediately.
When I look at the
You can also do it programatically. I find, even with MySQL that this is
faster since it avoids the NxM intermediate table creation where one can
limit the number of rows intially. I'm using Debian so I'm stuck on .22
for now, this might change in .23. It would definitely be the way to go
Thanks for pointing out mysqldump.
I now need to be able to copy a limited number of data records. I see that
mysqldump allows data copy by providing the cooresponding INSERT statements.
However, I don't always want all of the records. Some of my tables have
thousands of records and I may
You are correct, Tyler.
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
The above URL has some more information on this.
HTH :)
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
[EMAIL PROTECTED]
-Original Message-
From: Tyler Longren
Hi!
At 02:59 PM 8/7/01 +0300, you wrote:
Grigory Bakunov writes:
Date |Fri, 3 Aug 2001 17:21 +0200
From |TIGNAC BRUNO [EMAIL PROTECTED]
Hello!
TB --- Reçu de CMB.TIGNABR 0298426574 03-08-01
17.21
TB Hello,
TB I plan to use MySQL/InnoDB to store about 13 GB
I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was
pkg_delete the old MySQL and install the new one. Before I delete the old
MySQL I copied all the database files to a temporary location. Once the new
installation was successful I copied over all the database files into the
proper
Get the mysql client from www.mysql.com.
Tyler
On Sun, 5 Aug 2001 13:38:09 -0400
Chris [EMAIL PROTECTED] wrote:
Is there a method I can use to log into a remote mysql server through
something such as telnet to pass queries on my database?
Hi !
-Original Message-
From: SRIVATSAN RAGHURAMAN [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 6:13 PM
To: [EMAIL PROTECTED]
Subject: RE: MyOdbc to unix
Hi Sinisa,
Sorry I should have mentioned this earlier. From Windows.
Setup a user account that can access your databases from the remote hosts
you wish to use. Do this using GRANT. Then install the mysql client on
those systems and use
mysql -h hostname -u user -p password to connect.
Shon Stephens
At 01:38 PM 8/5/01 -0400, Chris wrote:
Is there a method I can
Dear Eldon,
record for each device ID without retrieving them all to find the most
recent name?
SELECT * FROM my_table WHERE ID = LAST_INSERT_ID(ID)
Check: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce
Dear Anders,
subselects have not yet been implemented. You can find lots of
workaround examples here:
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
#
Dear Wang,
/usr/libexec/mysql: Can't find file './mysql/host.frm' (errno: 13)
It's tricky, but you have to install the two databases (mysql and test)
shipped along with the MySQL distribution. Here's that part:
shell ./scripts/mysql_install_db
And here's the manual part:
Dear Carsten,
Hi, Sorry to bother you people but I've just locked
myself out of my own DB.
Stop the MySQL server (mysqladmin shutdown) and start it again like
this: mysqld --skip-grant-tables :)
Here's the manual part:
http://www.mysql.com/doc/C/o/Command-line_options.html
Regards,
--
Dear Chris,
look here: http://www.mysql.com/doc/J/O/JOIN.html
It's one of the JOINs (INNER JOIN or LEFT JOIN) you are looking for.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355
Dear Steve,
(eg adding drop table columns_priv; before the CREATE TABLE
columns_priv;
You can use various options for mysqldump, like --add-drop-table. This
will add a drop table statement :)
Anyway, it's always a good idea to re-create tables and their data. One
reason: By default, mysqldump
Dear Louie,
how can i delete a database table?
Check the manual? http://www.mysql.com/doc/D/R/DROP_TABLE.html
DROP TABLE [IF EXISTS] tbl_name [, tbl_name,...]
Or something like DROP TABLE my_database.my_table
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions
Dear Chip,
you cannot use reserved words as column names. You have password as a
col name which is a reserved word in SQL. The error derives from there,
only MySQL gets it wrong and points you into the wrong direction as to
where to search.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO
Dear Matt,
have had no experience of the above two products
just some useful links:
www.phpmyadmin.com
www.php.net/documentation
www.mysql.com/documentation
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
#
You did not mention what the 'client' or the 'server' were (i.e. NT, UNIX,
Mac), or what the 'distance' between the 2 was (over the Internet ?, thru
firewalls, etc).
If you're trying to connect over any distance on a network, make sure you
DON'T use 'telnet' or 'ftp' (or you will find your
Hi,
I want to save object into MySQL database. Since MySQL
in not object relational database, is any problem to
save object into it? Which attribute I should select
to save object? Varchar BINARAY?
Thanks for your help!
Zengfa
__
Do You Yahoo!?
Ok, I follow that, in future when moving databases I will use mysqldump.
However, I still wish to know why moving the databases by duplicating the
files directory structure does not work. This is 100% repeatable and I
can't see why (unless file(s) exist I am not copying).
If for some reason
Dear Chris,
Is there a method I can use to log into a remote mysql server through
something such as telnet to pass queries on my database?
If you have a telnet account on the remote machine, log in. Then start
mysql (MySQL monitor, command line tool) which will connect to the MySQL
server. You
I have a table with (char)Username attribute which is the primary
key of the table and also acts as a foreign key in many other tables.
My question is if the queries would be faster if i used a numeric
value for the primary key?
Integers would be faster, but the question is really
by
On 07 Aug 2001 13:51:01 +0100, Matt Gaskin wrote:
Currently I have rented space on a Web Server that has MySql installed and
PHP, They have created a database directory for myself. Do I need to install
Mysql and PHP locally to take advantage of this. If so where do I start. I
have had no
Dave Rigby wrote:
Hi,
Could you create a linked list of the links- i.e. have a 'Next' field,
which contains the ID of the next URL in order. You will also need a
field to store if the link is the first (i.e. root) of the list. Then
you can just iterate though the rows, using the next
On 07 Aug 2001 16:21:13 +0800, louie miranda wrote:
Is it possible for mysql 3.23.40 to support SSL.
hm, how?
No, from MySQL 4.0 only.
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL
Title: Blank
Has anyone built or implemented field level
auditing in a mysql database? Any body have a quick down and dirty way of doing
this?
Thanks for the suggestions
Wyly Wade
Forefront Inc
1413 S. Howard Ave
Suite 104
Tampa Fl, 33606
813-253-2267
Date |Tue, 7 Aug 2001 17:25:48 +0800
From |SDiZ Cheng [EMAIL PROTECTED]
Hello!
SC I have read these docs. I can't find any charset option in CREATE TABLE
SC syntax.
Oh no.
You need to set up charset in mysql configuration.
like this:
http://www.mysql.com/doc/C/h/Character_sets.html
Look up
IMPORT DATA INFILE
in the manual
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-Original Message-
From: Kevin Fonner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 5:09 PM
To: [EMAIL PROTECTED]
Hi
Problems started after I upgraded my Driver from mm.mysql.jdbc-1.2c to
mm.mysql-2.0.4-bin.jar,
still using MySQL v.3.23.33 on ApacheTomcat (Win2000) where I formerly had
the \org\ Driver dir in \classes\ but now have new Driver in \lib\ and
haven't unzipped jar. Yes, updated Environ Var'bles
http://www.mysql.com/doc/L/O/LOAD_DATA.html
http://www.mysql.com/doc/m/y/mysqlimport.html
http://www.mysql.com/doc/L/o/Loading_tables.html
On Tue, 7 Aug 2001, Kevin Fonner wrote:
Is there an easy way or perhaps a utility to import a tab delimeted text
file of data into a mysql table
Thanks for pointing out mysqldump.
I now need to be able to copy a limited number of data records.
I see that
mysqldump allows data copy by providing the cooresponding INSERT
statements.
mysqldump -w
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
Did you see the -w, --where option? It might be what you're looking
for...
Dump only selected records.
--http://www.mysql.com/doc/m/y/mysqldump.html
If you have a more complicated query and you are using Windows, you can
use urSQL + MyODBC to accomplish this as urSQL
Hi All,
Not sure if this is a bug or just a standard behavior of a auto_increment
zerofill column.
I have a column in a MySQL database table assigned as such:
memid int(8) auto_increment zerofill primary key,
now when the a new row is inserted in fills the column with the appropriate 0's,
but
emacs
MJM
- Original Message -
From: Kevin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 11:30 AM
Subject: WANTED: Utility to reverse engineer existing database II
Thanks for pointing out mysqldump.
I now need to be able to copy a limited number of data
Greetings,
I am attempting to use MySQL's MERGE feature to link tables from different
databases. All tables have identical structures, and I need to do this
because each table is right up against the 2-Gbyte limit imposed by Linux's
ext2 filesystem.
System info: OS is RH Linux 7.1 (2.4.3-12smp
Geez, if it ain't one thing it's another. :-(
My fbsd server went down hard today, now my mysql database is supposedly
gone.
I see the .MYD, .MYI, and .FRM files in the /usr/var/db/mysql/ directory,
but I get this -
mysql use bulletins
Can't read dir of './bulletins/' (Errcode: 13)
Database
Thanks for all the responses to my posting below.
I was using phpmysqladmin to check on updating the database, and I finally
figured out that phpmysqladmin was misconfigured, with the same database on
two different servers but with different column names. Naturally I was
sending the query to the
HI,
i am trying to install MySQL over an HP-UX 10.20 machine:
# uname -a
HP-UX hpbmp01 B.10.20 E 9000/899 1653421311 8-user license
When i try to run the Installation procedure this fail with the follow
error (Memory failt).
# scripts/mysql_install_db
Creating db table
Creating host table
Please see section 6.17 of http://www.mysql.com/doc/index.html.
Bing
Bing Du [EMAIL PROTECTED], 979-845-9577
Texas AM University, CIS, Operating Systems, Unix
Kevin Fonner [EMAIL PROTECTED] 08/07/01 10:08AM
Is there an easy way or perhaps a utility to import a tab delimeted
text
file of
Date |Tue, 7 Aug 2001 17:25:48 +0800
From |SDiZ Cheng [EMAIL PROTECTED]
Hello!
SC I have read these docs. I can't find any charset option in CREATE TABLE
SC syntax.
Oh no.
You need to set up charset in mysql configuration.
like this:
Date |Tue, 7 Aug 2001 17:25:48 +0800
From |SDiZ Cheng [EMAIL PROTECTED]
Hello!
SC I have read these docs. I can't find any charset option in CREATE TABLE
SC syntax.
Oh no.
You need to set up charset in mysql configuration.
like this:
http://www.mysql.com/doc/C/h/Character_sets.html
...Some of my tables have thousands of records and I may only want the first
200 or so. I did not see
an option on mysqldump that would limit the number of records. Any ideas
without writing a program?
Kevin
Try the WhereClause option in mysqldump.
Syntax is:
-w 'where_clause'
-or-
A numeric value will be faster in most cases. The reason being that a
comparison between two numbers at most takes 1 comparison... but a
comparison for a char at most takes n comparisons (n being the length of the
field/string). In addition a numeric value would take less space... all
around its
Dear Kevin,
Is there an easy way or perhaps a utility to import a tab delimeted
text
file of data into a mysql table
Try PhpMyAdmin (www.phpmyadmin.com). Great browser based utility. You
need to have PHP installed in order to use it.
You may as well use the LOAD DATA INFILE command. Check
Dear Kevin,
an option on mysqldump that would limit the number of records. Any
ideas
without writing a program?
AFAIK you cannot do this with mysqldump. But you can use the SELECT ...
INTO OUTFILE syntax, in some way like this:
SELECT * FROM my_table INTO OUTFILE some_records WHERE id
Speaking of Mysql and PHP, has anyone had a problem compiling PHP 4.0.6 (as
a DSO) with MySQL 3.23.40 in use with Apache 1.3.14 on a redhat 7.0 box?
The error I get occurs when I run apache, during startup it says that it can
load the php module because the libmysqlclient.so.10 file cannot be
Hi,
I want to save object into MySQL database. Since MySQL
in not object relational database, is any problem to
save object into it? Which attribute I should select
to save object? Varchar BINARAY?
First of all, you need to serialize the object
somehow. I assume that the language in
What is the process of upgrading v3.23.36 to 3.23.40 on Windows NT. Can I just
install over top or is there some other steps that should be taken? I am running two
mysql servers, one a master and one a slave. Does this make a difference?
Hi,
If this kind of question has been asked and answered, I'd appreciate if
somebody can point me to the right direction looking for the answers.
The question is how I should load different external text files into
different columns of the same table. For instance, file1.txt contains
'ssn
1 - 100 of 129 matches
Mail list logo