i'm using Mysql ver. 3.23.49...
Ritu
On Fri, 10 May 2002, Jeremy Zawodny wrote:
On Fri, May 10, 2002 at 10:12:15AM +0100, ritu singla wrote:
Hi!!
I used BACKUP TABLE command to take the backup of a
table...but when i say
RESTORE TABLE, i get the following ::
mysql restore
on 12/5/2002 9:21 pm, Phil Dobbin at [EMAIL PROTECTED] wrote:
Well, I finally got in but now I get a 1044 error:
[localhost:~] phil% mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 3.23.49-entropy.ch
Not sure this is a MySQL problem or an ASP issue so apologies if it's OT.
Code in ASP Page :
Dim intWeekID
objRSWeekID.open SELECT WeekID FROM WeekControl _
WHERE WeekStart NOW() AND WeekEnd NOW(), objConn
intWeekID = objRSWeekID(WeekID)
This fails to bring back a value for
So far I've experienced it on one SMP box and one single CPU box. I
Silly question: what is SMP...?
Best regards,=20
Eivind :-)
sql, query
-
Before posting, please check:
when I try to tar the MySQL file mysql-3.23.49.tar in a RS6000 machine
running
AIX 4.3.3, I got some error messages like these
x ././@LongLink, 109 bytes, 1 media blocks.
x
mysql-3.23.49/sql-bench/Results-win32/ATIS-db2_odbc-NT_4.0-cmp-db2,informix,
ms
SMP is System Multi Processor
Like a server with 2 or more CPUs ...
David
- Original Message -
From: webmaster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 1:07 PM
Subject: Re: Re: mysql uses 99% cpu under freebsd 4.3
So far I've experienced it on one SMP box
when I try to tar the MySQL file mysql-3.23.49.tar in a RS6000 machine
running
AIX 4.3.3, I got some error messages like these
x ././@LongLink, 109 bytes, 1 media blocks.
x
mysql-3.23.49/sql-bench/Results-win32/ATIS-db2_odbc-NT_4.0-cmp-db2,informix,
ms
Jay
I created another user on My PC to try out your suggestion and all was revealed
(I think). The problem appeared to lie with the MySQL ODBC driver.
I created a user DSN in the ODBC control panel for the new user. Two of the
TDX ODBC configuration dialogue boxes asked for a username and a
Hi
Mihail Manolov wrote:
Hey guys,
did you spot this problem?
mysql select truncate(199.20,2);
++
| truncate(199.20,2) |
++
| 199.19 |
++
1 row in set (0.00 sec)
Bug?
No. Feature :)
This is described in
Well, all I can say is that
SELECT * FROM table ORDER BY id, RAND();
works just fine. It may not be standard SQL, but MySQL handles it just
fine. If you need to make it a table field, then you can do it this way:
SELECT *, RAND() AS r FROM table ORDER BY id, r;
I would hope that query would
Hello folks,
can anybody share there expertise in SQL syntax to help me with the
following ..
$SQL = SELECT * FROM quotes,details
WHERE details.id = quotes.relID
AND relID='$sess_id'
AND ($sess_initial_status)
Big apologies.
The path to my connection file was wrong, so I was looking at the wrong
database.
*shuffles to the corner in embarrassment.
- Original Message -
From: Dave [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 12:02 PM
Subject: NOW()
Not sure this is a
Todd,
Monday, May 13, 2002, 8:06:03 AM, you wrote:
TC 1) Can I add new users with mysqladmin?
Nope. You can only set new password for existing user with mysqladmin,
look at:
http://www.mysql.com/doc/m/y/mysqladmin.html
TC 2) With mysqladmin as root I can get a response to
TC #
Todd,
Saturday, May 11, 2002, 6:46:21 PM, you wrote:
TC Coming from an Interbase background, I am use to using the Interbase Data
TC Definition language to create the DB then use PHP to access it. From my brief
TC reading, it appears that I should create a PHP script that creates the DB. Is
TC
Sigalit,
Sunday, May 12, 2002, 3:47:24 PM, you wrote:
SCD I am new in the MySql business so I'm sorry if my question is too simple.
SCD Is there any way to nest queries in MySql in the following manner:
SCD select field from table where id = (select ...)
No, MySQL doesn't have sub-selects yet.
Kittiphum,
Monday, May 13, 2002, 8:52:38 AM, you wrote:
KW Thanks after got your mail that
perror 28
Error code 28: No space left on device
KW I try to check my disk spack it have 2 GB space left so it may not cause by this
problem .And I found that with MySQL 4.0.1 it error but not error
Amer,
Monday, May 13, 2002, 2:03:28 AM, you wrote:
AN Win/98
AN MySQL 3.23.46
AN I'm trying to use AUTO_INCREMENT=1000 to specify my staring value in an
AN ID column in batch mode, but it doesn't want to work. I can get it to
AN work in interactive mode though.
AN In a file (create_tables.sql)
Justin,
Sunday, May 12, 2002, 5:13:53 PM, you wrote:
JF I'm a total newbie when it comes to windows set-ups... I've managed to get
JF Apache and PHP4 running nicely on an old Pentium laptop running Win95, and
JF have managed to install MySQL with ease.
JF However, I'm not all that sure how to
Hello dear group
I have a problem with an authentication in mysql. I got a database-table
'user' with columns for 'login' and 'passwort' and several other columns.
A customer shall be able to enter his UserID and Password into fields
(html input types) and these are posted to the following
Philip Spradling wrote:
I'm trying to link libmysqlclient into a C/C++ program using g++.
But I get the following errors:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.o(.text+0xaa): undefined reference to 'uncompress'
Jereymy,
Thanks a lot for your explanation on Repair with key cache, I was reading
the online help, but could not get a clear picture of what was going on. So
I gess allocating as much memory as posible to the key buffer will improve
the performance of this stage?
Thanks
Ramon
Hi,
When I have been browsing the mysql documentation on
http://www.mysql.com/documentation/mysql/bychapter/
I have recognised that the documentation is referring the 4.0.2 version of MySQL.
I would like to compile MySQL from source files. At the moment I am able to download
the 4.0.1
Whps!
I am using PHP on a Linux platform.
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
Georg Richter wrote:
On Monday, 13. May 2002 07:06, Todd Cary wrote:
Hi,
However this does not work in a script:
Egor -
Here is the code:
?
$link = mysql_connect(209.204.172.122, root, mypassword);
if ($link) {
print(Connectedbr);
} else {
print(Cannot connectbr);
}
?
The error is a timeout with the following message and I think the answer is right in
front of me: need to open port 110.
ritu,
Friday, May 10, 2002, 12:12:15 PM, you wrote:
rs I used BACKUP TABLE command to take the backup of a
rs table...but when i say
rs RESTORE TABLE, i get the following ::
rs mysql restore table rs from '/tmp';
rs +---+-+--+--+
rs | Table | Op
Sorry I found a mistake in my text. $pass pwd, like it is used in the php.
One more thing: I guess it's the php.ini. there are a few differences
with the two versions. if you want to compare i'll send you the two
phpinfo-files to compare.
The script doesn't work when the username is compared
I have created a .my.cnf file in my home directory. When I start mysql as that user,
it should read that file automatically correct?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply.
This problem happened to me when i first installed mysql, basically you need
to add root to the user table of mysql. The first time you log in, password
is not set so you log into the system with and hit 'enter', blank for a
password, then you have to set password...
-Original Message-
Hello folks,
can anybody share there expertise in SQL syntax to help me with the
following ..
$SQL = SELECT * FROM quotes,details
WHERE details.id = quotes.relID
AND relID='$sess_id'
AND ($sess_initial_status)
Description:
Using gcc version 3.0.4 on HPUX 11.00, configure fails to run sucessfully i.e.
The define __STDC_EXT__ is thrown out as a redefine and so many test compilation fail
How-To-Repeat:
run configure on HPUX 11.00: Fails to pick up existence of most system headers
e.g. float.h
Hello,
I get the following error message: Too many tables. MySQL can only use 31
tables in a join
(tested on MySQL 4.0.1-alpha-log and MySQL 3.23.49a-log)
Is there a way I can use more then 31 tables in a join (setting a server
variable) ?
Thanks
Han
At 09:25 PM 5/11/2002, you wrote:
I ported several applications from Firebird 1.0 to MySQL 4.
The main things I ran into was little SQL Syntax differences, Stored
procedures, and
Triggers...
mike
Mike,
Out of curiosity, why did you switch from Interbase to MySQL?
(I've
Hi,
access table it's your table or you make reference to the mysql.user table
?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original
Below is the output from the error log
I started slave replication, it replicated about 5 tables, then just after
it created the next table, it stops. I am not sure of the problem (does
anyone know what server_errno 2013 is?)
020513 10:01:07 Error reading packet from server: Lost connection
Hi,
I have database developed on my laptop. What is the quickest way to
backup the database and restore it on the server? Can I restore the
database as empty database? Howa bout creating SQL statements based on
the database structure?
Thanks
Viliam Batka clear wrote:
Hi,
When I have been browsing the mysql documentation on
http://www.mysql.com/documentation/mysql/bychapter/
I have recognised that the documentation is referring the 4.0.2 version of MySQL.
I would like to compile MySQL from source files. At the moment I am
Yes, but that file would only have user specific information such as your
password in addition to the gloabl variables read from the gloab options
file ...
If you want to have server specific global variables in your my.cnf file in
your directory, than you need to start mysqld with --defults-file
actually, the access table is a table that i've created, in a different
database than mysql, that holds usernames and passwords for a site that i'm
working on. It has nothing to do with user table of mysql database.
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
(This might be a repost I got this message after I sent the last one:
Sorry. Your message could not be delivered to: w3d3demo (Mailbox or
Conference is full.)
Hello,
I am experiencing a problem when compiling QT 3.0 (trolltech.com) (OS: OS X
10.1.2) with their mysql/libmysqlclient.a (ver:
Hello, thanks for the suggestions so far but...
mysql select * from access where UserID='myusername' and Password =
password('mypassword');
Empty set (0.00 sec)
mysql select * from access where UserID='myusername' and
password('mypassword');
returns correct result...
mysql select * from access
thank for all your help
ORDER BY status = 'DEAD', '$sess_quotes_search_by' ...
was the correct modification
paul
- Original Message -
From: Svensson, B.A.T. (HKG) [EMAIL PROTECTED]
To: Harald Fuchs [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 3:24 PM
Subject: RE:
Hi,
I think it's your problem it raise from type of field User from access
table.You try to compare some 'char' with 'bin'.
So...for this reason you must change type of the User field from :
User char(How_much_char_are)
to
User char(How_much_char_are) binary.
... and work fine.
Regards,
Gelu
Concerning my actual question to the group, I got the feeling that the
function mysql_fetch_object is just not working correctly.
Is it possible that mysql_fetch_object is not working, if something gone
wrong during compilation-time or if there's a wrong entry in any
cnf-file (or php.ini)?
I
... work fine with:
mysql select * from access where UserID='myusername' and
password=password('mypassword');
- Original Message -
From: Tewfic Kidess [EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; Tewfic Kidess [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent:
I have an sql question. I have a table that holds user information that
includes their id and who they report to.
user
-
id (int)
supervisor (int)
This heirarchy goes several levels deep. Without changing the db structure,
what is my easiest way to determine if user x is a supervisor for
Great suggestion, as soon as i changed the field to varchar() binary and
then reset the value of Password = password('mypass') it worked. Than you
so much for the continued help.
Regards,
Tewfic.
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13,
Description:
I was getting a read-only error on one of my many databases. So, I tried doing
mysqladmin restart and now I'm getting Can't find file: './Belzon/jobs.frm' (errno:
13). I've tried looking up this error online and tried doing some of the suggestions
(UMASK), but nothing
Sorry to bother the list with the mundane, but I have searched the
entire MySQL manual and can't find the answer. Is there a way to output
the table description (using DESCRIBE) into an OUTFILE like you can for
SELECT query statements? Thanks! Aaron
Kinda OT but it all works :-)
Does anyone know where I can get info on using MySQL database for keeping
track of time spent on projects? An example or something would be cool.
Goal:
I need to be able to post my time spent on various CVS projects and such
and the owners need to see how many
PR,
Monday, May 13, 2002, 5:47:23 PM, you wrote:
P I have database developed on my laptop. What is the quickest way to
P backup the database and restore it on the server? Can I restore the
P database as empty database? Howa bout creating SQL statements based on
P the database structure?
Taylor,
Monday, May 13, 2002, 5:04:20 PM, you wrote:
TL I have created a .my.cnf file in my home directory. When I start mysql as that
user, it should read that file automatically correct?
Yeah, MySQL reads user-specific options from that file. If you
want to specify some global options in
Todd,
Monday, May 13, 2002, 4:44:30 PM, you wrote:
TC Egor -
TC Here is the code:
TC ?
TC $link = mysql_connect(209.204.172.122, root, mypassword);
TC if ($link) {
TC print(Connectedbr);
TC } else {
TC print(Cannot connectbr);
TC }
?
TC The error is a timeout with the
Viliam,
Monday, May 13, 2002, 4:27:01 PM, you wrote:
VBc When I have been browsing the mysql documentation on
VBc http://www.mysql.com/documentation/mysql/bychapter/
VBc I have recognised that the documentation is referring the 4.0.2 version of MySQL.
VBc I would like to compile MySQL
Hello,
Mike Robinson wrote:
Hello to all,
I've had some severe issues on redhat-7.x boxes and
mysql compiled from source with gcc-2.96 much like
the warning states on the download page. On these boxes,
more than say 20-25 concurrent or near-concurrent connects
produced unexpected results
Hi,
Dave wrote:
cut
Dim intWeekID
objRSWeekID.open SELECT WeekID FROM WeekControl _
WHERE WeekStart NOW() AND WeekEnd NOW(), objConn
intWeekID = objRSWeekID(WeekID)
This fails to bring back a value for WeekID.
Just want to mention couple of things:
1. storing both
curdate()
- Original Message -
From: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED]
To: MYSQL [EMAIL PROTECTED]
Sent: Sunday, May 12, 2002 12:34 AM
Subject: NOW()
Hi,
I have a table with a timestamp field called dtins. When i insert a row to
the table, the value of this field is
Where is the user table? Can it be viewed? How can I tell what is in it with
mysqladmin?
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
-
Before posting, please
Symmetric Multi Processing ;-)
url: http://webopedia.lycos.com/TERM/S/SMP.html
David BORDAS wrote:
SMP is System Multi Processor
Like a server with 2 or more CPUs ...
David
- Original Message -
From: webmaster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 13,
Hello~
Having some problems installing MySQl on unix ~ when i executed the
bin/safe_mysqld --user=mysql
I got these error messages:
*you need to configure slave
do a SLAVE START
*../std_data/words.dat not found
Any ideas on how to fix these?
Also, when installing modules for
Hi,
I have a directory of professional magicians, consisting of a MySQL table
like
this:
+-++-+
| artist | area| magic |
+-++-+
| Joe Bloggs | AZ*IN*TX | childrens |
jcapp,
Monday, May 13, 2002, 6:30:54 PM, you wrote:
jDescription:
j I was getting a read-only error on one of my many databases. So, I tried
doing mysqladmin restart and now I'm getting Can't find file: './Belzon/jobs.frm'
(errno: 13). I've tried looking
j up this error online and
You can do it using tee command in your mysql shell.
See: http://www.mysql.com/doc/m/y/mysql.html
Gurhan
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 11:26 AM
To: Mysql List (E-mail)
Subject: OUTFILE and DESCRIBE
Sorry to bother the
[snip]
Does anyone know where I can get info on using MySQL database for keeping
track of time spent on projects? An example or something would be cool.
Goal:
I need to be able to post my time spent on various CVS projects and such
and the owners need to see how many hours / minutes I have spent
Make sure mysql owns its database files and directories.
[EMAIL PROTECTED] wrote:
Description:
I was getting a read-only error on one of my many databases. So, I tried doing
mysqladmin restart and now I'm getting Can't find file: './Belzon/jobs.frm' (errno:
13). I've tried looking up
Thanks for your note.
You wrote:
There are known problems with gcc-2.96 which comes with RH 7.2
distribution. There is disclaimer about it at
www.mysql.com/downloads/mysql-3.23.html as you noticed.
There is much reading on the GCC 2.96 issue.
There seems to be two paths of dicussion. I
The easiest way is simply to copy the files. Go to the directory that mysql
was installed to. There should be a subdirectory called data. Under that
should be a subdirectory named after your database. You can simply copy that
entire subdirectory to a mysql server and the database will be copied
Hi,
Given the number of questions i've seen regarding later versions of
mysql
I've decided to provide a snapshot release system of the data on the
work.mysql.com server for 4.0.x you can access the nightly builds here:
http://www.mysqldeveloper.com/snapshots/
Good luck and have fun.
Luciano
The first timestamp field in any table is always updated when the row
changes:
http://www.mysql.com/doc/D/A/DATETIME.html
If you don't want this behavior, use a date or datetime field instead.
--jeff
- Original Message -
From: Damnish [EMAIL PROTECTED]
To: Edilson Vasconcelos de Melo
Thnaks . I tried several variation and they are giving me sql syntax
error:
Mysqldump --no-data database XXX tmp.sql;
I also tried mysqldump --no-data database c:\tmp1.sql
What is the proper syntax? I also get message outfile disabled?
Thanks
Paul
-Original Message-
From: Victoria
Description:
Our mysql server is crashing multiple times every day. In looking through the
logs, in mentions that we should check our key buffer, but the memory size is well
within our systems ability. Basically, if I don't find out how to prevent this/what
the problem is then my boss
Hi,
I have a directory of professional magicians, consisting of a MySQL table
like
this:
+-++-+
| artist | area| magic |
+-++-+
| Joe Bloggs | AZ*IN*TX | childrens |
[snip]
+-++-+
| artist | area | magic |
+-++-+
| Joe Bloggs | AZ*IN*TX | childrens |
+-++-+
| Fred Smith | All| close-up|
Todd wrote:
TC The error is a timeout with the following message
TC and I think the answer is right in front of me:
TC need to open port 110. Could that be true?
No. Port 110 is used for POP. Barring any unforeen setup, the MySQL daemon
runs on port 3306.
TC Warning: Can't connect to
Error message:
Cannot find one of include/mysql/mysql.h, include mysql.h in
home/local/mysql at lib/DBD/mysql/Install.pm line 165, STDIN chunk 4
This came after i tried to tell it where mysql was installed
any suggestions?
On Mon, May 13, 2002 at 09:23:36AM -0400, Ramon Arias wrote:
Jereymy,
Thanks a lot for your explanation on Repair with key cache,
I was reading the online help, but could not get a clear picture of
what was going on. So I gess allocating as much memory as posible to
the key buffer
Daniel,
- Original Message -
From: Daniel Rand [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, May 13, 2002 5:24 PM
Subject: InnoDB Foreign Key Constraints
Hi,
Does anyone know if it's possible to set up a foreign key constraint where
one table references the
Hi All,
I am running MySQL on Unix and Linux and I would like
to know whether different locales are supported.
I am interested, more specifically, in developing a
database which is going to be populated with Greek
names, so I am after any support provided for Greek
locale.
Could you please
i am successfully using the following query to select the number of hours an
employee works on each project per month:
mysql SELECT SUM(IF(MONTH(period)=01,hours,0)) as 'Jan',
SUM(IF(MONTH(period)=02,hours,0)) as 'Feb', . . . SUM(IF(MONTH
(period)=12,hours,0)) as 'Dec' FROM log WHERE id =
Jason,
there are two known bugs which could cause this. A memory overwrite bug in
the glibc build in .49a, and a BLOB handling bug which was only fixed in
3.23.51.
To get resolvable stack traces you should upgrade to 3.23.50 which you get
from http://www.mysql.com/downloads/mysql-3.23-pre.html.
I would like to know if there's anyway I can setup 2 servers running
MySQL to either share the same database or keep in sync with each other.
So if something happens and one server goes down the other one can still
be able to serve the users.
Thanks
Jean-Rene Cormier
Mike, what kind of problem? What exactly goes wrong with PHP4?
Thanks,
Vadim
Mike Robinson wrote:
I am able to reproduce this problem very easily, including on
Redhat-7.2. Basically, any app using the libmysqlclient.so
compiled with gcc-2.96 connecting to a server compiled with
gcc-2.96
Amer,
Monday, May 13, 2002, 2:03:28 AM, you wrote:
AN Win/98
AN MySQL 3.23.46
AN I'm trying to use AUTO_INCREMENT=1000 to specify my staring value in an
AN ID column in batch mode, but it doesn't want to work. I can get it to
AN work in interactive mode though.
AN In a file
Kind Regards,
Chris Knipe
MegaLAN Corporate InterNetworking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 9:10 PM
Subject: Re: auto_increments
Your message cannot be
Use gcc 2.95.3
[EMAIL PROTECTED] wrote:
Description:
Our mysql server is crashing multiple times every day. In looking through the
logs, in mentions that we should check our key buffer, but the memory size is well
within our systems ability. Basically, if I don't find out how to
Vadim P. writes:
Mike, what kind of problem? What exactly goes wrong with PHP4?
Thanks,
Vadim
Mike Robinson wrote:
I am able to reproduce this problem very easily, including on
Redhat-7.2. Basically, any app using the libmysqlclient.so
compiled with gcc-2.96 connecting to a server
Yes,
Just add default-character-set=greek line in your /etc/my.cnf (or whereever
the global server specificationa are read) .
Gurhan
-Original Message-
From: GEORGE KONSTANTINOY LEKEAS [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 2:07 PM
To: [EMAIL PROTECTED]
Subject: MySQL
Do you know if freshmeat is only online certain times of the day/week? I
have tried from several different servers of ours to get to it, but it
always gives me the Cannot find server message.
Thanks
Steve
At 11:38 AM 5/13/2002, Jay Blanchard wrote:
[snip]
Does anyone know where I can get
Hi All, I am fairly new to mysql..
I am using perl, mysql, and apache to do a little development, and to learn quickly I
am trying to do some real dbase transactions...
I have a program whcih gets a bunch of stock quotes from the internet (say about 5000)
it returns symbol, price, time, etc
You can run two different servers pointing to the same data dir, but for
what you are asking you should use replication..
See: http://www.mysql.com/doc/R/e/Replication.html
For redundancy , you have to write scripts.. See:
http://www.mysql.com/doc/R/e/Replication_FAQ.html
Gurhan
-Original
I pulled this DDL from a MySQL server and am trying to load it into a
MySQL server runinng 3.22.49, but I get errors with the DDL.
CREATE table news (
id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
subject varchar(80),
when timestamp(14),
body text,
who smallint(5) unsigned
Amer Neely wrote:
Yes, I understand that, but I'm trying to create the table and
initialize UserID by redirecting a .sql file into mysql (batch mode). I
don't want to insert a 'dummy' record starting at 1000, I want MySQL to
do that, like it says in MySQL by Paul DuBois [p.94, chap.2.]. Again,
At 15:23 -0400 5/13/02, Amer Neely wrote:
Amer,
Monday, May 13, 2002, 2:03:28 AM, you wrote:
AN Win/98
AN MySQL 3.23.46
AN I'm trying to use AUTO_INCREMENT=1000 to specify my staring value in an
AN ID column in batch mode, but it doesn't want to work. I can get it to
AN work in
Mike,
BTW, have you been able to build Mysql 4.0 under RH7.x from the development
tree lately?
I keep getting some missing definitions messages as of last week, when I
performed a regular 'bk resync'. Prior to that, all had been just fine.
TIA,
Vadim P.
Mike Robinson wrote:
Hello to all,
How about:
UserID SMALLINT UNSIGNED AUTO_INCREMENT NULL PRIMARY KEY DEFAULT 1000
Curtis
Amer Neely said:
Amer,
Monday, May 13, 2002, 2:03:28 AM, you wrote:
AN Win/98
AN MySQL 3.23.46
AN I'm trying to use AUTO_INCREMENT=1000 to specify my staring value
in an AN ID column in batch
Simle query request: I want to display the ID for everyone in a table who is
NOT in a second table.
so this is what I have come up with
SELECT student.SID, student.firstName
FROM student
WHERE student.SID NOT IN
(SELECT msoccerroster.SID
FROM msoccerroster)
It comes up with an
On Monday 13 May 2002 1:49 pm, Taylor Lewick wrote:
Hi All, I am fairly new to mysql..
I am using perl, mysql, and apache to do a little development, and to learn
quickly I am trying to do some real dbase transactions...
I have a program whcih gets a bunch of stock quotes from the internet
http://freshmeat.net
Methinks this is what Jay meant!
;)
~Rob
%-Original Message-
%From: Steve Buehler [mailto:[EMAIL PROTECTED]]
%Sent: Monday, May 13, 2002 2:44 PM
%To: Jay Blanchard; [EMAIL PROTECTED]
%Subject: RE: Project Time
%
%
%Do you know if freshmeat is only online certain
Hi
Seems to be offline, can't get it from here too - its giving 500 server
error
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
when is a reserved word. If you really wanna have it as a column you have
to put it in between backticks, i.e. `when` . Unless you absolutely have to
, don't use reserved words as your column, table names for sake of
clarification.
See: http://www.mysql.com/doc/R/e/Reserved_words.html
Gurhan
Hi.
Please don't write only to me, but also to the list.
On Mon, May 13, 2002 at 09:35:46AM -0400, [EMAIL PROTECTED] wrote:
Benjamin
I had seen that article before, but I still don't understand what
delay_key_write does?
Well, than you better had asked, what the explanation in the
1 - 100 of 120 matches
Mail list logo