Can you update an auto_increment with NULL in MySQL? Obviously if you
try and put a NULL in directly it will increment to the next integer.
Is there some way to actually get a NULL in there instead of the
integer?
-
Before postin
gerald_clark writes:
>Danny wrote:
>
>>Can you update an auto_increment with NULL in MySQL? Obviously if you
>>try and put a NULL in directly it will increment to the next integer.
>>Is there some way to actually get a NULL in there instead of the
>>integer?
>&
Hello,
What version of UNIX are you running?
Solaris, Linux, FreeBSD, BSDI?
You can find that out my typing in uname -a
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 11:01 AM
Subject: help starting up mysql
> Hi,
> I hope I'm at t
Besides using Phpmyadmin to edit the data. I actually prefer to use
something like webmin to manage my data.
Do a search on Webmin on the internet.
- Original Message -
From: "Aqua" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 12:42 PM
Subject: How to access
Whenever you install someting like mysql on Linux RH you should consider
using RPM (Redhat Package Manager)
Go to the www.rpmfind.net and do a search for mysql
- Original Message -
From: "Javier Gonzalo Gloria Medina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 06, 2
I think you need to install both the mysql-client and the mysql-server?
What does the output of "rpm -a" say? (this lists all the rpm installed)
What does "whereis mysqladmin" say?
- Original Message -
From: "Steve Dickey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July
The .sql or txt file has to be on your LINUX machine.
However, I recommend you should create the .sql or txt files in the LINUX
machine using vi , pico or whatever your favoprite text editor mitght be.
Looking forward to your feedback.
dannyh
[EMAIL PROTECTED]
On Mon, 12 Feb 2001, C.o.m.b.u.
-Hello
- If you are running FreeBSD 4.0 why not install mysql using
/usr/ports/database/mysql-server.3.xxx
make install
make clean
On Tue, 13 Feb 2001, pdewaha wrote:
> Hi,
> I've mysql 3.23.32 running on FreeBSD 4.0.
> It runs a site with heavy traffic and heavy
> database
In some RDBMS there is something called ROLLBACK.
However, I am not sure if MySQL does support features such as ROLLBACK,
If mySQL doesnt support ROLLBACK then you need to do a recovery from your
previous backups.
On Sat, 03 Mar 2001, Pål Wester wrote:
> When you delete somthing... is there
Look very carefully at the mysql database by typing in
mysql -u root -p mysql
Look at the manunal for how you can INSERT INTO the user table or how you can
use GRANT
On Thu, 05 Apr 2001, J.Heegsma wrote:
> >%_Dear Sir/Madam,
>
> I am a student and my teacher want's to try to break in into
Hi
Ok, This must be a fimiliar login script. I want to change the target of
werk.htm in the header to a specific frame. How to do that? something like
in html
Danny
FROM user
WHERE username='$PHP_AUTH_USER' and
password='$PHP_AUTH_PW'";
$result
-Hallo
- If you want views and stored procedures you can try something like
Postgresql.
- I believe this is explained in the MySQL documentaton.
On Thu, 11 Jan 2001, Pål Wester wrote:
> Is there any way to create views or stored
> procedures in mysql?
>
> thx in advance,
> Pål Wester
>
>
There are mnay free RDBMS around besides MySQL
This includes:
Postgresql
mSQL (mini SQL)
Oracle 8i is free for Linux
The learning curve from any RDBMS eg: from Postgresql to MySQL or Oracle to
MySQL because they are ANSI SQL compliant.
On Fri, 12 Jan 2001, you wrote:
> Hi everybody,
>
> I
Database systems Design implementation and management by Rob and Cornel
explains the concept the relational schema prefectly.
I highly recommend it for people starting out in IT and university students
On Sun, 14 Jan 2001, [EMAIL PROTECTED] wrote:
> I am a new user to MySQL.
>
> I am having a
-Hello
This depends on what OS you installed MySQL in.
Did you install it on :
Linux?
BSDI
FreeBSD?
Windows 98?
If you installed it using Linux did you install using RPM?
If you installed it using FreeBSD did you isntall it using ports?
On Mon, 15 Jan 2001, Ujwol wrote:
> >%_Hi,
> I
Look in the MySQL manual for mysqldump
you should find the correct syntax
On Mon, 15 Jan 2001, sanaa wrote:
> hi
> I want to know how to backup and restore databases in mysql.
>
>
> thanks for help
>
> -
> Before posting, pl
Hallo
- Just out of interest .
Did you install MySQL on FREEBSD using www.freebsd.org/ports
if you didnt I highly recom,mend you should.
Looking forward to your feedback.
dannyh
[EMAIL PROTECTED]
On Tue, 16 Jan 2001, Nicolai Gylling wrote:
> Hi
>
> I'm currently running a FreeBSD4.2-Sta
-Hello
- You can try the following methods:-
Use php to code the report. This is easy once you have experience
with php but there are many free php code out there such as phpwizards.net
which can assist you.
Cystal Report by Seagate is also a very good report generator. I am sure
Cystral Repo
MySQL has nothing to do with /etc/passwd
You need to look at the mysql by typing in
mysql -u root -p mysql
Then you type in
DESCRIBE mysql
You should see somehting like the user table.
All you have to do is use INSERT INTO sql statements or even look up the mysql
manual for the usage of GR
You should ponder install mysql using
ports
eg
/usr/ports/database/mysql-server.xxx.xx
make install
make clean
This will put files in standard places for FreeBSD It will install any
dependencies for you automatically.
If you don't know how to insitall mysql using ports email me off the mysq
For UNIX users (eg BSD, linux) there is something called dia which allows you
to draw ERDs
But, I assume you are looking something more like a RAD tool rather than a
simple program that allows you to draw UML, ERD's etc.
However, if you are intersted in dia and using Linux you can find the rpm
Hello
Thats probably you username in user table has given you only SELECT prilvages
(Select_priv)
You can log in as root in mysql and UPDATE the user table to give you INSERT,
DELETE privlages
Refer to any sql book on the syntax of UPDATE
On Fri, 02 Feb 2001, Matthew Halliday wrote:
> I have
-When you deleted the rpm version of mysql did you use the rpm command to
dlete mysql?
- What version of mysql are you trying to install?
- Maybe, look at deleteing all the current mysql rpm with the rpm command and
try it without the --no-deps option.
- Or install a prevous version of mysql?
Have you create a startup script in /etc/rc.d?
I believe you haven't created a startup script and you should type in ps -gax
to see if mysql is running.
On Tue, 06 Feb 2001, Vadim Selitskiy wrote:
> Hi
> How are you?
> No, I used rm command to delete, because rpm told that it is unable to
> r
I have an unexplained crash I am trying to figure out.
This is a pretty static system, that has been running fine for a couple years.
It crashed at 7:45am which is after any nightly bakups have all been done, so
not even under any load. All other aspects of the system such as i/o,ram,cpu,
number
odule, the call to
mysql_real_connect() fails.
Anyone have any idea why this is happening?
Anyone have a suggestion of an email list that is more appropriate
for this question?
-Danny Swarzman
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
I posted a question about running mysql in an Apache module. Maybe I
need a list with a different focus. Please suggest.
-Danny Swarzman
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d on.
Best Regards,
Danny Stolle
Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-h -D
- mysqladmin -u -p -h flush-tables
are you granted for a remote logon?
does your mysql-client tools hang as well?
the statement show a no-space between '--host=xxx--user=xxx' it should
be '--host=xxx --user=xxx' or are you aware of that?
Best Regards,
Danny Stolle
N
Berman, Mikhail wrote:
Hi Danny,
Thank you for helping me here.
Yes, I am aware of need to have the space between --host=xxx and
--user=xxx, and command I am executing actually has a space.
It looks like you believe that my problems related to security of remote
logon. That is something, I am
n find the installation program and tutorials to help you get
through MySql
If you are new to Linux, then perhaps reading some stuff about linux first.
Good luck and enjoy :^)
Best Regards,
Danny Stolle
Netherlands
EmoeSoft (http://www.emoesoft.nl)
--
MySQL General Mailing List
For list arc
Is there a problem with the mysql-general list? I haven't had any messages?
Danny Stolle
Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
'localhost' (using
password: YES)
Yet, when I go in as root and re-grant permissions with the user
password, access is restored. When I reboot, I get the error again.
What could possibly be causing this?
Thanks,
Chris Fonnesbeck
Sorry again ... forgot the mailing group ...
"Did you &#
Michael Stassen wrote:
Danny Stolle wrote:
Chris Fonnesbeck wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000
ngine by setting the mysqld-option:
--default-storage-engine=type similair to --default-table-type=type in
your .my.cnf file.
So now also my question: When to use innodb instead of myisam? What
performace advantages does this engine have?
Danny Stolle
Netherlands
--
MySQL General Mailing Lis
ith 3 disk each - 1 for the
OS, the other for Data, and the last one for Logs.
If the Logs disk crashes, will MySQL be able to write logs to the
Logs disk on the 2nd server via DRBD ?
Regards,
Danny
Daniel Cummings wrote:
This forum has been very helpful.
There is always somebody that is willing to respond to queries.
Does anybody know of a good Oracle forum?
TIA
Dan
Dan,
You could try http://www.lazydba.com/
Best regards,
Danny Stolle
Netherlands.
--
MySQL
thread with "SLAVE START". We
stopped at log 'CentracDB-bin.013' position 2989111
Any idea on what could be causing this ?
Regards,
Danny
i use the values which are used in the
insert-string and convert them into hex using this function?
the example provided in the documentation is not realy helpfull though.
hopefully i am clear, otherwise please let me know.
Thank you.
Danny Stolle
Netherlands.
--
MySQL General Mailing List
I thought it was something like that ... I just found it strange
allready. I'll give it a try, thanx.
Danny
Paul DuBois wrote:
At 19:43 +0200 8/16/05, Danny Stolle wrote:
Hello all,
can somebody explain to me the c-api mysql_hex_string().
when i debug my example in DDD i get the ful
ill automatticaly be applied :-)
Danny
Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote:
Here is the problem that I am having. I am trying to make a copy of a
full record in a table that has a primary key with auto-increment. The
real problem is that I want the statement to use SELECT * so t
utomate an export and use the load datafile to
import the information; but then again you have to rewrite the datafile.
Best regards, Danny
Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote:
That is the effect that I am looking for, but exactly the method that I
am trying to avoid. If
I am not familiour with Cold Fusion but: cant you use 'show columns from
table' ?? and use the result object?
This normally works in e.g. C or PHP
danny
Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote:
I am using Cold Fusion and as I stated in my original message,
Hi,
I was wondering if you have solved your problem. I am quite interested
excually.
Best regards, Danny
Todd Ellison wrote:
OK, I am ready to get flamed. I have done so much stuff wrong on this
MySQL server that it finally came back to bite me. I've learned my
lesson and hope
Hello,
Can anyone tell me what advantages there are in keeping dates and times in a
MySQL DateTime field, as opposed to storing its string equivalent in a Varchar
field ?
Regards,
Danny
n isp
address, the database name. connecting without proxy, that is directly,
works fine; but i need to make a connection behind a proxy.
Danny
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, see if it reacts the same
as your database.
can you tell me the mysql>\s values?
i am just giving you some hints, to analyse the problem using trial and
error. i am sorry i can't give you the full solluton; because too many
factors can cause the error.
Danny
Roberto Rodriguez Garri
change the permissions
on the data directory to: mysql:mysql.
Hopes this small description will help you on your way to run a complete
mysql database :-)
Danny
Charles Gambrell wrote:
I am running Whitebox linux 4 and have MySql 4 installed.
When I run the mysqld_safe file, mysql starts then
your ActivitySelections
holds the data pure for this perpose.
Hope this small info will help you on your way :-)
Best regards,
Danny
Jesse wrote:
I need to be able to add a foreign key that will allow a constant is
possible.
I have a table named Campers that has a field named ID. I also have
an
Hi,
Did you check your error log file?
Is there allready a pid file in the directory? You have to delete this
one first.
Hope this helps :-)
Danny
ali asghar torabi parizy wrote:
hi to all
i have mysql5.1 installed on fedoracore3
it was worked sucsessfully since yesterday.
but when i
rm.
Hope this little info helps you :-)
Danny
Marc wrote:
I forgot to mention - I'm running MySQL 4.0.14 on Linux. And I'm not very
knowledgeable on databases. I just use MySQL with Knoda to get the job done.
==
I've got a MySQL table that I'd
he
regexp function it doesn't work. But this sure does.
Before you use the update, create a selection first with the regexp
function; if that works, your update will do fine.
Hope this little info helps you :-)
Danny
Jerry Swanson wrote:
I have 290 records in the database with backsl
the error gone?
Danny
Brittingham, John wrote:
I am having trouble with table lock.
The query is as follows:
INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT (
CUID
) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID
FROM `TV_LOG_ALL`
group by 2,3;
I keep getting this error: #1206 -
Hi john,
When did you start getting this error message?
There aren't any trouble with MyIsam tables?
Danny
Brittingham, John wrote:
They are InnoDB and max_write_lock_count=4294967295.
The same thing happens when I create a copy of the table.
-Original Message-
From: Danny S
interesting and i am trying to get this error on my mysql
databases by changing the bufferpool and inserting a lot of data;
Best regards,
Danny
Brittingham, John wrote:
They are InnoDB and max_write_lock_count=4294967295.
The same thing happens when I create a copy of the table.
-Original
How about a start in the dev.mysql.com and browse for documentation.
Start with the differences of all kinds of installations ;-) and using
the [.]my.cnf file[s].
Cheers, Danny
Bayrouni wrote:
Hello,
I would like to understand the mysql administration, is there any good
doc for beginners
be i
guess, consistency; because you now have a value (NULL) which is not
present in the country table.
The country_id is an example, but you can guess there would be more
examples you can think of.
If I am not clear enough please let me know; and I can be more specific.
Danny
--
MySQL Ge
fer
euh .. would that be on a windows platform ;^) ?? i am running the 14.7
on a linux distro and i have no trouble since ...
danny
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
fer
euh .. would that be on a windows platform ;^) ?? i am running the 14.7
on a linux distro and i have no trouble since ...
danny
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ust plain simple (or stupid) what are your experiences on user
management in a MySql environment.
Best regards,
Danny Stolle
Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
other privileges? he will get a new or already created role userID,
but would still be able to logon using the previous user id.
why wouldn't you choose for the 3th option or 1st option? what
disadvantages do you think would option 1 and 3 have?
Best regards,
Danny Stolle
EmoeSoft, Nether
would somebody create roles?' is an
interesting question. i have no direct answer to this question. the only
thing i would come up with is: when you have a lot of tables and you
have to change a privilege on several tables. you have the choice for
changing that for 40 users each or 5 roles each
George,
from a MySql point of view, how would you deal with security on a site?
would you than create individual users?
Best Regards,
Danny Stolle
EmoeSoft, Netherlands
[EMAIL PROTECTED] wrote:
Danny,
My 2 cents (American dollars): From a security standpoint (if you are a financial
Peter,
that is an interesting formulation which you gave. can you please
comment that with an example? would you create roles for users who are
assigned the same privileges and individual users who have multiple roles?
Best Regards,
Danny Stolle
Netherlands
Peter Brawley wrote:
Danny
/&g
uot;
when i `mysqladmin -u root shutdown` the database, the mysql.sock is
removed.
does your system errors when starting mysqld?
Best Regards,
Danny Stolle
EmoeSoft, Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
he also got the nulls after
ID_streettype_spec_hosp. he is working with version 5.0 mysql server.
this has got to be a bug, or there must be something else going on.
Danny Stolle
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Danny Stolle wrote:
hi,
i would like to discuss 'user management' in mysql. Working with Oracle
you can assign users to roles giving them privileges provided by that
role. MySql doesn't have Roles. I have read (Managing and Using MySql,
O'Reilly) 3 options on managing u
James M. Gonzalez wrote:
-Original Message-
From: Danny Stolle [mailto:[EMAIL PROTECTED]
Sent: 15 June 2005 21:09
To: James M. Gonzalez
Subject: Re: help joining tables in a query
James M. Gonzalez wrote:
Greetings,
I'm facing a difficult query at the moment. I have tried
Paul Mitchell wrote:
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option in
my.cnf: socket="/tmp/mysql.sock"
when i `mysqladmin -u root shutdown` the database, the mysql.sock is
removed.
does your system errors when start
Hi all,
I am curious to know if the query times I'm seeing are reasonable or not.
Here's my situation:
I am using a database to keep up with web statistics. The table is
currently growing at about 2 million records a day. The sample table I am
working with has right at 4 million rows.
When I exe
, I check my DevDBs database, and it has been
updated, but not all tables that I'm expecting to be restored have been restored.
Further, the DevDBs directory has only about 250 megabytes of data, rather than the
one gigabyte I am expecting.
Any help would be appreciated.
Danny
Hello,
I am from Indonesia and newbie in Mysql.
Why if I execute command MySql in dos prompt,
appear in screen " ERROR 2003 : Can't connect to MySql Server on 'localhost' (10061)
Thanks
Dani
-
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
1.18, perl
5.8.0, libdbi-perl (1.35), libdbd-mysql-perl 2.1026
Danny.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What do you mean by "appropriate indexes?"
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 3:43 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Long Running Queries
You need Appropriate Indexes on the tabl
uot; would mean indexes on columns specified in your
where criteria.
On this List, people mostly post table structures, as well as the
queries they are firing, or else it really doesn't help.
-Original Message-
From: Danny Willis [mailto:[EMAIL PROTECTED]
Sent: Thursday, October
a TCL environment (with an tcl mysql library).
So you feel my question... How to read human readable values from those
fields so i can process them furter with tcl ?
Thank for any reply.
Greetings,
Danny Terweij
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
ields works just fine
And if i do the same way on blob fields i see just garbage like
"&*(^yuhg789" But i know that fields holds a number or word.
So i think its something to do with converting binary-format to ?.
Danny Terweij.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
x27;m a newbie with MySQL, so I don't know what other info to provide.
I appreciate your help.
Danny S.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ffic, like you would get when
trying to decompress a 10k part of a large zip file.
hth
danny
On Tue, 2003-10-07 at 10:49, Director General: NEFACOMP wrote:
> Hi group,
>
> I have read in the MySQL manual that the client/Server Compression protocol adds
> some security to the applica
Crystal was pulling the data through MyODBC, Mascon was just used for
inserting the image into the database.
hth
danny
On Thu, 2003-10-09 at 16:20, Director General: NEFACOMP wrote:
> I want to ask you one thing:
> Is your Crystal Report accessing the database through the Mascon U
x27;m a newbie with MySQL, so I don't know what other info to provide.
I appreciate your help.
Danny S.
*
Adventure Cycling Association
Inspiring people of all ages to travel by bicycle.
800/755-2453, 406/721-1776
www.adventurecycling.org
--
MySQL General
some user have "Too many connections" error.
I've "solved" problem with wait_timeout=120 instead of 28800 but this is not
a good solution.
I assume you are using mysql_pconnect()? That way, PHP will reuse old
connections instead of opening up a b
living on the "edge of a knife", running a production system
on 4.0.1/2/4/5 for the last few months, had some minor problems with
4.0.3 but every other release has been quite solid. So, no, I dont think
you'll run into any prob
ctStopTime FROM radacct;
danny
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To uns
I too would be interested in a good way of clearing the binary log files
(preferably non disruptive to the server ;-)
The only thing thats saving me so far is that the systems capacity is 320Gb.
danny
Anirudha Kukreti wrote:
hi all
i have established a two way replication setup
my problem is
been a long time Linux
fan) because the IIS boxes were driving me up the wall (poor
reliability, inflexibility and the torrent of fixes and patches).
Ever since then i've been a devout LAMP (Linux, Apache, MySQL & PHP)
fan. The platfo
I try to run the import test as listed in the document.
mysqlimport: Error: The used command is not allowed with this MySQL version,
when using table: imptest
My server version: 3.23.49.
What is the problem? How can I fix it?
Thanks!
Danny
d limit
the results afterwards by using LIMIT 1). This is mainly for boosting the
performance of mys queries.
Actually where using mysql to dynamically assign ip addresses to our
dial-in users. We query the database for available addresses -> there are
more than 1 available but I only need 1!
Th
ailover. The
>failed machine should then (manually) reboot and the database should start
>to catch up with be new master.
>
>- Are the any of you that have experience with this kind of setup? How did
>you do it?
>
>
>Any info on this would be great.
>
>
>Cheers,
>
chine should then (manually) reboot and the database should start
to catch up with be new master.
- Are the any of you that have experience with this kind of setup? How did
you do it?
Any info on this would be great.
Cheers,
Danny Kruitbosch
sql, mysql,
Hello there,
I have an issue where upon system (YellowDogLinux v2.2) reboot or halt,
if the mysqld is running i get the message that shutting down mysql:
FAILED
Has anyone experienced this? Or can someone perhaps help me understand
what is going on?
Sincerely,
Danny
Hello there,
I have an issue where upon system (YellowDogLinux v2.2) reboot or halt,
if the mysqld is running i get the message that shutting down mysql:
FAILED
Has anyone experienced this? Or can someone perhaps help me understand
what is going on?
Sincerely,
Danny
93
BBB| 143 | 22
CCC| 344 | (NULL) <- There are NO field2=1 where field1=CCC
DDD | 287 | 38
etc.
How can I do this?
Thanks,
Danny
-
Before posting, please check:
http://www.mysql.com/manual.php (t
MySQL reported this error when i tried to connect using JDBC :
Error during query: Unexpected Exception: java.sql.SQLException message
given: Communication link failure: java.io.IOException
the funny thing about the error is that it only happens once in a while.
Meaning that an SQL statement mig
processor makes it faster than
if I were to get mysql running on both processors?
Or maybe I am even wrong about using pthreads being the method to
have mysql take advantage of both processors?
--
struct Programmer/Analyst 'Danny Rathjens' {this.place = "MyCity.com";}
"How
I bet you downloaded the source code version and not the binary version.
check your download.
Daniel Katcher
202-619-7643 ( voice )
202-619-7655 ( fax )
[EMAIL PROTECTED]
>>> "Amit" <[EMAIL PROTECTED]> 04/07/01 12:40PM >>>
Dear Sir,
This a mail from a new established software company. We are
mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
-
the master.
any pointers gladly taken, however small..
best regards to you all,
danny
- --
Danny Haworth
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Ge2 System Administrator
Gas~Elec Safety Systems
Tel : 01895 422 997
Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])
-BEGIN PGP SI
.
|
| How can I do it in MySQL.
after inserting into the auto_increment table, do a 'SELECT
LAST_INSERT_ID()' which will return the last autoincremented value. You
can use this value in your second insert statement.
danny
- --
Dan
started jumpin' under
real load.
I know this probably isn't of much use to you, i'll try writing up a few
perl scripts to create some "virtual load" and see what happens then.
If there's anything else i can provide for you to help trace this bug
d
1 - 100 of 111 matches
Mail list logo
