Hi guys..
I've been thinking on something for a little while and I need some advice.
I am inserting several fields into a table, however there's an 'id' (id integer not
null auto_increment) column that I use as the primary key.
the problem lies in the fact that I want to get the 'id' that was
On Fri, Jul 27, 2001 at 09:29:20PM -0700, Michael Collins wrote:
>
> I have a table that shows MUL in the key field column, what does
> that indicate?
That means it's a non-unique key.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (
On Fri, Jul 27, 2001 at 09:01:09PM -0400, Nick Seidenman wrote:
>
> I'm seeing two problems with temporary tables:
>
> 1) I keep getting "table is full" errors. I set sql_big_tables to one, as
> the docu directs, but this doesn't seem to have had any effect.
Do you have sufficient disk space?
Hi,
I worked with PHP and MySQL for about a year now, but this is the first time
I did my own MySQL instalation on my server instead of having it
preinstalled. This is when i got a very weird error that I've never seen
before.
Warning: Host 'blahblahblah.com' is not allowed to connect to this M
At 2:18 AM + 7/28/01, Sudarshan Kumar wrote:
>I installed mysql sucessfully. I changed the root password. But I am
>not able to login as root. I said 'mysql -u root' I got access
>denied.
Did you try:
mysql -u root -p
then to enter your password at the prompt?
If you forgot it then use
Mark:
the key to this puzzle is the separator, the ';'
for your first question, you need to find the ';' followed by a 6. not just
any ';', but the first ';'
the pattern would be "^[0-9]*;6"
which says
^ find beginning of line
[0-9]* followed by zero or more instance
This virus is becoming wide spread. It appears to use a machine's address
book and mail itself to the members of the address book. i've received mail
with the virus from a number of people, in addition to receiving it from
this list.
At 05:04 PM 7/27/01 -0400, you wrote:
>On Fri, 27 Jul 2001,
I have a table that shows MUL in the key field column, what does that indicate?
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-
On 28-Jul-2001 azharmg wrote:
> hi..good day,
>
> how to filter the fields from table that we wish to dump it..
> ie.table : abc fields:name,address,phone..
>
> so we only want dump for field name and address only,...
> how to do that..
>
Start with this:
localhost.dread$ cat csvdmp
#!/bin/
On Wed, 25 Jul 2001, David Miller wrote:
I know it's bad form to followup ones own message, but enough digging
turned up an answer that someone else may find useful.
> Hi All:)
>
> I'm running mysql-3.23.30-gamma on FreeBSD 4.3-stable and running into a
> problem with max file sizes.
>
> I've
Hi All,
I need to import about 30,000 data records from a text file into a MySQL
database table, thru the LOAD DATA feature. The table in question will have a
auto increment column, plus 5 other columns. Should I include a field in the
text file to insert a value into the auto increment column,
select *,count(case_id)
from blah
where (status = 'FAILED')
group by case_id
having count(id)>1
having applies to grouped results.
results:
FAILED,1,453,0,0,0,2
FAILED,6,464,3,2,5,2
FAILED,7,468,0,2,5,2
FAILED,8,469,0,2,5,2
without the having clause, you get:
FAILED,1,453,0,0,0,2
FAILED,6,464,3,
delete from mysql.user where mysql.user.user='somebody';
or
use mysql;
delete from user where user='somebody';
for a list of users,
delete from user where user in ('somebody', 'anotherone', 'yetanother');
Jim Michaels
- Original Message -
From: "Jerad Hampton" <[EMAIL PROTECTED]>
To: <[E
On 27-Jul-2001 Joshua J. Kugler wrote:
> Is this an undocumented feature that I missed? You just have to specify the
> as TYPE_passwd and it will automatically encrypt using that algorithm? I
> don't see anything in the documentation for ENCRYPT about this. Or am I
> really missing something
Hi,
I installed mysql sucessfully. I changed the root password. But I am not
able to login as root. I said 'mysql -u root' I got access denied. Is
there a way to reset the root password.
Regards,
Sudarshan.
_
Get your FREE downl
Hi all,
I use setenv CXX gcc and then ./configure --prefix=/usr/local/mysql. No
problem appear. then I use gnu make to continue the process. It gives
the following error:
Undefined first referenced
symbol in file
__cxa_pure_virtual
Hi !
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 27, 2001 11:54 AM
> To: [EMAIL PROTECTED]
> Subject: MyOdbc to unix
>
>
> Ok, I can't seem to find the answer to this which leads to believe its
obvious, but anyway. MyOdbc can be used to
hi..good day,
how to filter the fields from table that we wish to dump it..
ie.table : abc fields:name,address,phone..
so we only want dump for field name and address only,...
how to do that..
Rgds,
-
Before posting, please
I'm seeing two problems with temporary tables:
1) I keep getting "table is full" errors. I set sql_big_tables to one, as
the docu directs, but this doesn't seem to have had any effect.
2) temp tables seem to get fouled up in replication. The docu says temp
tables replicate properly as of 3.
hehe, this got rejected because i didn't say
database or sql or query or table
:)
on 7/26/01 5:17 PM, Kory Wheatley at [EMAIL PROTECTED] wrote:
> is the TIMESTAMP option where I get the current date from.
try "now()" instead of "TIMESTAMP"
-- mike cullerton
-- mike cullerton
---
It may be a solution for you...i simply copied the Mysql databases from
windows to suse 7.1 and it worked just fine!
David.
Glyn Davies wrote:
> Good day,I have created a database using MySQL under Windoze and am
> trying to move the data to MySQL running on Linux. I have exported the
> data to
Hello:
I have read and re-read the available documentation and a variety of
tutorials regarding the MySQL Access Privelege System, but am still unclear
on a few details. MySQL is successfully installed, I am able to connect,
create databases,
tables, etc., and have so far been successful in obtai
I have something that should be simple but I can't figure it out. Here is my
problem:
I have an exsisting database with an ID number and another field called
image. I have a delimited text file as such:
998|/images/something2.jpg
999|/images/something.jpg
I want to import the text file accordin
Ok, I can't seem to find the answer to this which leads to believe its obvious,
but anyway. MyOdbc can be used to connect an Access database on a Windoze
machine to a MySql server on a unix machine, correct? The reason I;m asking is
that tech support went , huh? So now I'm questioning my
sanit
When a try to fix a .MYI file , myisamchk dumps core. You can download the
file from http://gofind.ro/dbs.MYI
I fixed a lot of other files and it worked perfect, but this one
I have MySQL-3.23.40-1 installed from original RPM , running on Linux
Mandrake 8.0 on a P3 CPU.
Savencu Catalin
www
I prefer to use Auto_Increment for ease of use. In addition, I don't think
that MySQL supports sequences outright (like you may be used to with
Oracle). There are some workarounds availabe within the MySQL manual, do a
search with "sequences".
Good Luck,
Dennis
**
Hi,
Is there a command-line SQL interface or Perl module that allows you to
do a join between databases on different mysql servers? I've heard of
ODBC, but its specific functions are somewhat hazy to me. I've been
playing around with making a prototype that when given a query, extracts
queries
Hehehehe.
- Original Message -
From: "Geoff Blake" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 11:37 AM
Subject: Re: possible bug in sum() function
> On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
>
> >
> > the query was:
> >
> > select
I'm replying to the list because I got so many of these back:
Ya know gang... some days it just doesn't pay to get outta bed.
Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
Sorry and to the guy who replied with no spam please? what can I say, my face is ver
Sinisa,
Wow we did it finally:
mysql> create table genpept_sequence_protein
-> select sequence_id, genpept_20010726_113345.* from sequence_protein,
genpept_20010726_113345
-> where sequence_protein.sequence=genpept_20010726_113345.sequence
-> order by sequence_id;
Query OK, 14573 row
Steve - thanks for positive feedback...
>
> We push MySQL to handle a lot of queries per second. Any query that last
> several seconds can be enough to cause a cascade under a real heavy load. We
> have three things that are slow:
>
> 1) select ... order by xyz desc
>
> Workaround: create an
Server Version: Apache/1.3.19 (Unix) PHP/4.0.4pl1
MySQL 3.23.33
To find out about a peculiar phenomenon I am hunting for 10 days
already, I added a stopwatch and record for each URL the elapsed
time from entry of page construction to end.
Right from the start, I get significant data:
auto Times
On Fri, 27 Jul 2001, Steve Brazill wrote:
> It's nice to see that someone has an 'auto-response' setup for incoming
> infected messages...
>
> BUT, by the looks of the original Email (at the bottom of this message), it
> was an intentional attack on the list...
> > > - Original Message
Is there any performance difference between running a query on a compressed
MyIsam Table rather than a normal MyIsam Table ?
Thanks in advance
Bye
Steve,
They're both messages sent from windows machines infected with the
SirCam worm, Just discard them.
Steve Brazill wrote:
>
> Here's another one that appears to be a 'carrier' for something devious...
> (though I didn't see any attachments)
>
> How did it get thru the list without any
No
that's a 4.1 TODO.
Bryan Capitano wrote:
>
> Do any of the newer versions of MySQL support sub-queries yet?
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql
Should not reply to such non-existing guy/email ... But how can one know
before he/she puts time in?
Original Message
Subject: Returned mail: see transcript for details
Date: Fri, 27 Jul 2001 14:43:29 -0500 (CDT)
From: Mail Delivery Subsystem <[EMAIL PROTECTED]>
To: <[EMAIL PROT
>Description:
I'm compiling with GNU make and tar, and SunPro C++ V6 r2
This compiler is now called Forte C++, but it is SunPro.
I did miss the Solaris section in the docs. I believe I followed
them to the letter this time. I did the following defines:
CC=cc CFLAGS="-Xa -fas
SixK wrote:
>
> Hello ,
>
> here is a strange result I obtain,
> could someone tell me if it's a bug or if my request is wrong
>
> I'd like to obtain the number of times the word 'liste' is found in
> column page and the number of times the word 'piece' is found, all in
> a single request...
>
On Fri, 27 Jul 2001 08:54:19 -0700 (PDT), Bryan Capitano
<[EMAIL PROTECTED]> wrote:
>>Usually this means your MySQL daemon, mysqld, is not started. Which OS are
>>you using? Under RedHat Linux, you can get your mysqld running on init
>>runlevels 3 and 5 (network services with and without X-wind
Hi,
I have recompiled mysql using the hungarian character set, reindexed all
the tables,...
I have strange problem now:
If I do:
select count(*)
from sites
where match(site_content)
against('tõzsde');
it returns 0.
If I do:
select count(*)
from sites
where site_content like "% tõzsde %";
it retur
Is this an undocumented feature that I missed? You just have to specify the
as TYPE_passwd and it will automatically encrypt using that algorithm? I
don't see anything in the documentation for ENCRYPT about this. Or am I
really missing something?
Thanks.
j-- k-
> mysql> select enc
Hi,
I have a problem here.
I installed mysql-3.23.37 on my linux 2.4.2 i686 box...as specified in the
INSTALL_SOURCE file itself.
For configure prefix I gave the value of /usr/local/mysql. But, when I see
the directory, everything is present but the data or var directory is
missing.
Is it possible to have a single mysql server with multiple data directories? I would
like to be able to specify where a database is physically located. I know that I can
do this for all databases by setting the 'datadir' environment variable, but I have
not seen a way to do this for multiple l
Hi everyone,
I wonder if MySQL 3.23.40 for Windows is available. I went to mysql.com
and couldn't find the binary of 3.23.40 for Windows.
Regards,
Michael
-
Before posting, please check:
http://www.mysql.com/manual.php
When a try to fix a .MYI file , myisamchk dumps core. You can download the
file from http://gofind.ro/dbs.MYI
I fixed a lot of other files and it worked perfect, but this one
I have MySQL-3.23.40-1 installed from original RPM , running on Linux
Mandrake 8.0 on a P3 CPU.
Savencu Catalin
www
lets say i have a query the returns me the following data:
+++-+-+-+-+
| status | id | case_id | analysis1 | analysis2 | analysis3 |
+++-+-+-+-+
| FAILED | 1 |
We have MySQL running with PHP on Windows 200 Server. We found that the only
stable version is 3.23.38 mysqld-max-nt. This is working like a dream. But
we are running a search (MATCH) facility on our clients website and they
have specified that the MIN_WORD_LEN (i think thats what its called) shou
I'm perplexed.
My company develops a browser-based application that uses the mySQL 'C' API
to talk to the MySQL backend.
I'm currently trying to find a solution to a problem my company is having
with migrating from MySQL v.3.22 to v.3.23. Here are the details:
1. Running a MySQLd service, v. 3
Have you tried using ASTA w/Delphi and MySQL? Using the ASTA MySQL Server you connect
like the native and the ASTA componets allow you to build your Client GUI from Delphi.
Very Slick! MySQL, the worlds greatest database, seems to work just fine with it.
You can get the Server here http://www.a
pc-xx-xx-190-118-du:~/mysql++-1.7.9/examples # g++ -I../sqlplusint/
-I/usr/local/include/mysql -c simple1.cc -L../lib
../lib/libmysqlclient.a -lsqlplus
g++: ../lib/libmysqlclient.a: linker input file unused since linking not
done
g++: -lsqlplus: linker input file unused since linking not done
Thi
Dear JH,
use c:\mysql\bin\mysqlc.exe instead of mysql.exe. This one has a history
list.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-4
Dear Christiane,
as it really seems to be your first database, I will help you ;-)
> create table table_name (
> Column_Name not null
> );
CREATE TABLE table_name (Column_Name CHAR(50) NOT NULL) is correct.
Replace the field type and length (CHAR(50)) to suit your needs.
Regards,
--
Ste
Dear Stroker Dog,
why don't you just get PHP Triade Setup? It will install Apache, PHP,
Perl, and MySQL on a Windows machine. Tried it out, works great. No
configuration at all. Simply restart Windows, and web server, php
interpreter and MySQL server will be up and running :)
http://sourceforge.
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
>
> the query was:
>
> select sum(worktime),user from timecard where tcacct=project group by user;
>
> the answer was:
>
> 8.00user1
> 14.00 user2
> 160.00 user 3
>
> Now, where I went to school, this adds up to 184!
>
> Suggestions?
>
T
Here is what an employer database could track,
Usually Checks are issued in a warrant, and all the line items are actually
tracked in a detailed table by Warrant ID, and Employee ID,
The actual checks are run as a report that selects all the fields needed to
print on the check.
All do evolve
Thanks Stefan,
I really appreciate your help!
Susan
- Original Message -
From: "Stefan Hinz" <[EMAIL PROTECTED]>
To: "sjs" <[EMAIL PROTECTED]>; "Stefan Hinz" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 8:43 AM
Subject: Re: installing mysql
> Dear Susan,
>
> > My
Hello,
I'm just learning mysql and have found how to add users but I need
to delete some and can't find out how to do it.
Can some one tell me how to do this.
Thanks
Jerad Hampton
Network Administrator
The King's University College
-
Does anybody know which approach is better with mysql:
Create sequences for tables or an auto_increment columns???
and why???
Siomara
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---
Here's another one that appears to be a 'carrier' for something devious...
(though I didn't see any attachments)
How did it get thru the list without any of the necessary 'words' ?
Perhaps someone should block this Email address from the list:
[EMAIL PROTECTED]
P.S. Database
- Original M
It's nice to see that someone has an 'auto-response' setup for incoming
infected messages...
BUT, by the looks of the original Email (at the bottom of this message), it
was an intentional attack on the list...
P.S. Database
> - Original Message -
> From: "Bulk Mail Response" <[EMAIL PR
I'd rather not fire up Viz C just to build MySQL 3.23.39 NON-DEBUG.
Is there much of a performance difference between DEBUG & NON-DEBUG ?
Also with the Windows binary builds how does one NOT use MySQL MAX, is that a runtime
option or do you need a different build entirely ?
Is there much of
I think you meant that you're Sun server is using version "3.22.xx"...
The files with the ".ISD" and ".ISM" extensions belong to the "3.22.xx"
family of MySQL Isam file version types... (while the newer "myisam" have
the ".MYD" and ".MYI" extensions).
You would either have to 'upgrade' the MySQL
On 27-Jul-2001 David wrote:
> I want to log my paychecks in my own database for my own personal use. I
> am in the design phase: Do I need a table for year to date since this
> can be calculated automatically? I don't want to have to enter a lot of
> information when entering the data for each p
Do any of the newer versions of MySQL support sub-queries yet?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
Dear Skylineds,
> DD> The Sun datafile cannot be read. The file extension in the tables
is .ISD and .ISM for Sun, and .MYD and .MYI on W98 machine.
Convert all tables under Solaris to MyISAM format. It's easiest like
this:
mysqldump --all-databases > all_that_dump.sql
mysql < all_that_d
Dear Claudemir,
> No. This is the standard format. You can, however, reformat the
> result sets according to your needs.
The function is DATE_FORMAT, and a SELECT statement will look like this:
SELECT DATE_FORMAT(time_field, "%d-%m-%Y) FROM tbl
This will output 2001-07-27 as 27-07-2001.
Have
Dear Glyn,
you can dump a database under Unix and Windoze in the same way (shell under Unix,
command line under Windoze. You should go to c:\mysql\bin\ first if Windoze can't find
the path. I assume there are no privilege restrictions on either machine, otherwise
you will have to enter -u user
Dear Jackson,
> What does this error mean? I am trying to authenticate from a php
script using the following code...
> $db=mysql_pconnect("localhost","username","password");
> The user "username" is able to login to mysql ata command prompt.
Not really. At the command prompt you are supposedly l
Dear Glyndower,
> I want to import data into this table from the csv file from excell.
So...i
try to convert the CSV data to Unix format with an editor capable to do
this (e. g. PFE32, ftp://ftp.js-webshop.com/pfe32.zip). I encountered
problems from time to time when trying to import CSV data in
Usually this means your MySQL daemon, mysqld, is not started. Which OS are
you using? Under RedHat Linux, you can get your mysqld running on init
runlevels 3 and 5 (network services with and without X-windows) this way:
% chkconfig --level 35 mysqld on
% /etc/init.d/mysqld start
check to make su
Hello ,
here is a strange result I obtain,
could someone tell me if it's a bug or if my request is wrong
I'd like to obtain the number of times the word 'liste' is found in
column page and the number of times the word 'piece' is found, all in
a single request...
In the last example, it look li
On 27-Jul-2001 Brad Bonkoski wrote:
>
>
> Don Read wrote:
>
>> On 26-Jul-2001 sachin shetty wrote:
>> > Hi
>> > Is it possible to authenticate a logged on user by comparing the unix
>> > passwd file entry with the mysql user table entry(after copying passwords
>> > from the password file to th
Is there a way to do calculations on a timestamp field in mysql.
I would like to be able to find time elapsed and then the average of the elapsed times.
I am using php4 to connect to the database.
Any help Will be greatly appreciated.
Joel
> -Original Message-
> From: Mary Hippensteel [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 26, 2001 12:23 PM
> To: [EMAIL PROTECTED]
> Subject: window me support
>
>
>
> Can I use MySQL with Window ME. If so which
> one??
Yes. Download the any windows based and it should work fine.
Dear Jackson,
>shutdown. This problem arose today when I started tinkering with grant
privileges. But >doesn't make sense.
Try this: GRANT SHUTDOWN ON *.* TO the_one_who_can_shutdown@localhost
IDENTIFIED BY "some_shutdown_password"
Log on to the server admin tool like this:
mysqladmin -u the_on
Dear Susan,
> My question: Do I need to do anything to the ini file, or is that now
done?
> Am I now good to go?
You will have to look at the my.ini (usually in c:\windows or c:\winnt)
only if you forget the MySQL admin password ;-)
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
pyxl writes:
> Found a bug in 3.23.40 with GRANT:
>
> Statement:
>
> grant file on db.* to peeps@"%" identified by "password";
>
> emits no error message, however when one does a select for that user
> from the user table, one
> will find that the user "peeps" which was dutifully created has NO
Oh junhui writes:
> Hi,
> I am currently using mySQL 3.23.39, under windows 98 SE environment. When i am
>running mySQL using MSDOS-prompt, there is no shortcut key available (all the arrows
>keys, ctrl+p, etc, don't work, even though doskey was enabled).
>
> Thanks in advance.
> JH
Try m
Hannes Niedner writes:
> I just checked upon the following query which was already running for 3+
> hours. The sequence field is a non-indexed text field (is for once only
> join).
>
> mysql> create table genpept_sequence_protein
> -> select sequence_id, genpept_20010726_113345.* from sequenc
I installed it on Sun Solaris box from binary so I can't find any .cnf file
under ../share/mysql dir. Would you mind sending me a sample of my.cnf file?
Appreciate ...
Michael
>From: Jason Burfield <[EMAIL PROTECTED]>
>To: Michael Lin <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>
>Subject: Re
j.urban writes:
> I'm experiencing some unexpected and undesired behavior attempting to run
> SHOW COLUMNS FROM TABLE using Delphi via ADO.
>
> MDAC: 2.6 RTM
> MyODBC: 2.50.37
> O/S:Windows 98
> MySQL: 2.23.24 (Linux)
>
> I can run most queries just fine (ie SHOW TABLES, selects, etc.).
[EMAIL PROTECTED] writes:
> >Description:
> I'm comiling with GNU make and tar, and Forte C++ v6 r2.
>
> The compiler is current, as is the Solaris.
>
> My configuration line looks like:
>
>./configure --prefix=/usr/local/mysql --with-innodb
>
> I'm getting the following errors when ru
If you are running Linux, you can drop the my.cnf file into: /etc/my.cnf
If you installed from source, you should already have a my.cnf file on the
machine, but it probably is not located where it is being used by the dbase
server. If you installed from source check here:
/usr/local/mysql/s
Thanks, Jason.
Another question, where is the my.cnf stored? I don't have this config file
under my MySQL dir. Do I need to create one or ...?
Thanks,
Michael
>From: Jason Burfield <[EMAIL PROTECTED]>
>To: Michael Lin <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>
>Subject: Re: disable the mys
[EMAIL PROTECTED] writes:
> We keep a timecard database and I was just asked how much time had been charged to a
>particular project code. No problem says I and did the following:
>
> select sum(worktime) from timecard where tcacct=project;
>
> The answer came back 182. Then I was asked who h
Date |Fri, 27 Jul 2001 00:47:50 EDT
>From |[EMAIL PROTECTED]
Hello!
C> I am having trouble setting a column attribute to not null. Below is the
C> statement I am using:
C> create table table_name (
C> Column_Name not null
C> );
C> If this is not the correct way to do it, can someone please h
Date |Thu, 26 Jul 2001 19:11:21 -0700
>From |Hannes Niedner <[EMAIL PROTECTED]>
Hello!
HN> I just checked upon the following query which was already running for 3+
HN> hours. The sequence field is a non-indexed text field (is for once only
HN> join).
mysql>> create table genpept_sequence_protei
try to use
mysqlfront ( http://www.mysqlfront.de ), a windows GUI for mysql i've tried
it and it works like a charm
you can export table structure in a .sql format and then dump data into a
csv file and use the same utlity to import the files into your linux machine;
regards;
At 08:00 27/07/0
Example:
CREATE TABLE rassen (
id smallint(5) unsigned NOT NULL auto_increment,
bezeichnung varchar(50) NOT NULL,
kurz varchar(25) NOT NULL,
total smallint(5) unsigned DEFAULT '0' NOT NULL,
totalDeck tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY id (id, bezeichnung),
You mean within mysql? That's a program, doskey won't do anything
inside that program.
Oh junhui schrieb am Freitag, 27. Juli 2001, 06:49:05:
> Hi,
> I am currently using mySQL 3.23.39, under windows 98 SE environment. When i am
>running mySQL using MSDOS-prompt, there is no shortcut key av
Hi!
You are obviously running a 3.23.38 binary.
Sorry, the executable mysqld.exe was
in that version accidentally compiled with __NT__
defined, which means that mysqld.exe does not work
on Win 98. Use mysqld-max.exe from the same
distribution, or download 3.23.39 from www.mysql.com.
InnoDB does
On Thu, 26 Jul 2001, cjackson wrote:
> Thanks everyone for immediate response to this problem. I can kill the mysql process
>but I cannot stop it using
> /etc/rc.d/init.d/mysqld stop. I can start it like this using start but not stop it
>using stop. All of this is done as system root. So runlev
You can add : skip-networking : to your my.cnf file. You will only be able
to connect to the database server from localhost then.
-- Jason
On 7/26/01 5:21 PM, Michael Lin was heard saying:
> Hi,
>
> Does anyone know how to disable mysql listening port?
>
> Thanks,
> Michael Lin
>
> __
On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote:
> We keep a timecard database and I was just asked how much time had been charged to a
>particular project code. No problem says I and did the following:
> select sum(worktime) from timecard where tcacct=project;
> The answer came back 182. Then I wa
[EMAIL PROTECTED] wrote:
> I am having trouble setting a column attribute to not null. Below is the
> statement I am using:
>
> create table table_name (
> Column_Name not null
> );
>
> If this is not the correct way to do it, can someone please help me...this is
> my first mysql datab
[EMAIL PROTECTED] wrote:
> We keep a timecard database and I was just asked how much time had been charged to a
>particular project code. No problem says I and did the following:
>
> select sum(worktime) from timecard where tcacct=project;
>
> The answer came back 182. Then I was asked who
Don Read wrote:
> On 26-Jul-2001 sachin shetty wrote:
> > Hi
> > Is it possible to authenticate a logged on user by comparing the unix
> > passwd file entry with the mysql user table entry(after copying passwords
> > from the password file to the table).
>
> The password_crypt routine used in M
You must specify a datatype:
create table table_name (
Column_Name integer not null
);
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Fri, 27 July 2001 06:48
To: [EMAIL PROTECTED]
Subject: not null
I am having trouble setting a column attribute to not n
1 - 100 of 190 matches
Mail list logo
