Hi,
all you have to do use a transaction enabled data-source and use the
Mm-MysqlDriver
for your JDBC connections. (http://mmmysql.sourceforge.net/)
Best is to read the InnoDB documentation carefully (http://www.innodb.com),
as you cannot choose from a wide
variety of transaction-levels ... in m
* [EMAIL PROTECTED]
> Hie
> I'm new in MySQL.anyone out there can help please?
> I'm actually experimenting with the mysqlimport utility to import
> data from
> a text file.however i'm always getting this error upon the command
>
> c:\mysql\bin>mysqlimport - - local - -fields
Hi
I am trying to move an Access 2000 database into MYSQL 3.27.47nt running on
a Win2K machine. MYODBC with the 3.51 drivers is also installed.
MYSQL is running and readily responds to SQL queries using the DOS window at
the mysql> prompt. However, when linking the MYSQL database with ADO and VB
Hi
As i already stated , i am not able to insert a null value in a child table
in 4.0.1 which i was able to do in 3.23.51
I have created a table parent and also another table child where parentid
column in child is a foreign key to the id column in parent table
It was possible that i have no e
From: Simon Ashby [mailto:[EMAIL PROTECTED]]
Sent: 01 July 2002 10:58
To: MYSQL
Subject: Speed issue
>
> Any pointers on how to get rid of the disk churning and get a normal
> response in this set up would be much appreciated.
Turn off OBDC logging.
Tim Ward
Brett Ward Limited - www.brettward.co
hi all...
i can't seem to get the fulltext searching working perfectly... single search terms it
works fine, multiple search terms it also seems to be ok - finding records with any of
the search terms.
however, if i try the boolean mode it gives out garbage all the time. i try for
example an s
Hi All,
Can anybody tell mysql supports foreign constraints. If i use Referential
Integrity cascade then, will MySql delete the same record in another table?
Thanks in advance.
Regards
Daya Krishan Dubey
-
Before posting, plea
hmm, but still sticking to that you'll have to specify a new WHERE argument
for each thing you want to test on. Isn't there maybe some way to do it like
this
WHERE skill IN (regexp("powerpoint", "php"))
I know this thing won't work, becuase I don't know if you can do regular
expressions on WHERE
Hi Dubey
Actually foreign keys are supporte dfor INNODB Table types..
Whats the version of MYSQL u r using
-Arul
- Original Message -
From: "D.K.Dubey" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 4:18 PM
Subject: Foriegn Key
> Hi All,
> Ca
Hi Arul,
Thanks, I m using MySQl 3.23. Will u please tell me how it is possible.
Regards
D K Dubey
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the l
> Description:
> The ALTER TABLE command behaves very strange when stopping and
> restarting the MySQL server afterwards. I noticed this after having
> rebooted my PC (which means that the MySql server is stopped and
> restarted). Before the reboot I dropped a column in one of my tab
César,
Thursday, June 27, 2002, 8:41:25 PM, you wrote:
CA> Hi all. I have multiple tables in which I need to delete rows from the
CA> beginning. I have them stored with an auto_increment id but I don't want
CA> the records to start from 5 but from 1... is there a way to use
CA> something like ALT
Elby,
Friday, June 28, 2002, 11:13:52 PM, you wrote:
EV> create table person(
EV> id_person smallint not null primary key auto_increment,
EV> name varchar(10));
EV> create table friends(
EV> id_friend smallint not null primary key auto_increment,
EV> age smallint,
EV> id_person smallin
Rahadul,
Saturday, June 29, 2002, 12:08:50 AM, you wrote:
RK> I have mysql running on RaQ4 system. I tried to move /var/lib/mysql to
RK> /home/mysql and then change the datadir to /home/mysql in safe_mysqld
RK> file, but it didn't work. so I copied back the /home/mysql to
RK> /var/lib/myql, and
Anil,
Friday, June 28, 2002, 8:57:06 PM, you wrote:
AG> I have a table with the following description:
AG> mysql> describe xoops_groups_modules_link;
AG> +-+-+--+-+-+---+
AG> | Field | Type| Null | Key | Default | Extra |
AG> +-+-+--+-
Hi!
On Jul 01, Marko Djukic wrote:
> i can't seem to get the fulltext searching working perfectly... single
> search terms it works fine, multiple search terms it also seems to be
> ok - finding records with any of the search terms. however, if i try
> the boolean mode it gives out garbage all t
Hi there,
I am wondering if anybody has experiance in saving images to blob in mysql.
I do save images with 1 K and 4 KB to blob fields while I used to save them
to file. It seams to me that this is much slower accessing the files. The
images take a bit (really short but absolutly noticable) to
Hi!
You can put this into /etc/my.cnf:
[mysqld]
user=root
This will allow to run mysqld as root. However,
consider running it under another account, it is
safer.
Satish Santhakumar wrote:
> Hi Guys,
>
>MySQL wont start it says 'Security' error cannot
> start mysql. Read the MySQL manual
Hi
Can i use left outer join in MySQL.
Like i have one condition in Oracle
ex:
select * from user,company where u.companyid = c.companyid (+)
can i rephrase the query in mysql like this
select * from user left outer join company c using (companyid)
-Arul
sql , query
--
Hi!
Joel is right. You can store both, however in 3.23.x and 4.0.x
mysqld can use rules of the only one charset for things like GROUP BY,
ORDER BY, DISTINCT, etc.
In upcoming 4.1, it's possible to have fields of different
charsets at the same table. So, japanese and korean sorting
will be pos
Anybody had a problem with MySQL that does not start on SUSE 8 with default
installation?
If yes, what was the problem?
Thanks Jacques
___
Jacques Steyn
+27 (0)11 478-1259
http://www.knowsystems.com
-
Before p
Hi, I have been trying for 4 days but I can't solve this problem and I
don't know why.
It's a bug?
I have a table (children) which has a field called borough; I have to
extract the sum of the children of each borough so I use this simple
query:
select count(*) , borough from children group by bo
What's your log file say?
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Jacques Steyn [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 8:28 AM
To: Alexander Barkov
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: mysql w
Two questions :
* have you installed MySQL as a service ??
* have you stopeed a service prior to rebooting ??
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\
Simon,
Several issues come to mind.
First, as Tim suggested, make sure ODBC logging is turned off. It should be
by default but if you turn it on, it will whip your HD like a bad puppy.
Second, run MySQL on a different machine. More importantly, understand the
difference between Access and MySQL
Hi
As i already stated , i am not able to insert a null value in a child table
in 4.0.1 which i was able to do in 3.23.51
I have created a table parent and also another table child where parentid
column in child is a foreign key to the id column in parent table
It was possible that i have no e
Dear all:
I have just removed an old version of mysql and install MySQL3.23.51
(tarball). After installation, I tried to start the server:
% bin/safe_mysqld &
It can't be started. Message stored in file: /mysql/var/hostname.err asking
"Do you already have another mysqld server running o
Unless I've misread your post, this was not so much a feature in .51 as it
was a bug. If you have a FK contraint then you should never be able to
insert a record into the child table that does not have a matching FK in the
parent table. (Null does not mean no matching record.)
Either remove the
mtop (MySQL top) monitors a MySQL database showing the queries which are
taking the most amount of time to complete. Features include 'zooming' in
on a process to show the complete query, 'explaining' the query optimizer
information for a query and 'killing' queries. In addition, server
performanc
Hi all,
Does anybody know if there is a function to retrieve the next unique ID
number for a record to be made in the future?
thx. Wilbert
mysql query for next unique ID
-
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http://ww
Arul,
Monday, July 01, 2002, 1:25:38 PM, you wrote:
A> As i already stated , i am not able to insert a null value in a child table
A> in 4.0.1 which i was able to do in 3.23.51
A> I have created a table parent and also another table child where parentid
A> column in child is a foreign key to th
Page,
Saturday, June 29, 2002, 8:06:56 PM, you wrote:
PWWS>I'm a newbie at this, so here's a newbie question. I have installed
PWWS> MySql on a Cobalt Raq 4 running Linux via a .pkg file. All seemed to go
PWWS> well, I am able to get into the MySql directory via telnet but no commands
PWWS>
Jacques,
Monday, July 01, 2002, 4:28:25 PM, you wrote:
JS> Anybody had a problem with MySQL that does not start on SUSE 8 with default
JS> installation?
JS> If yes, what was the problem?
What do you mean "does not start"? If you get any error please provide
more info. Check also you host_name.er
Cams Ismael writes:
> * I have indeed installed MySQL as a service. That's why I use 'net stop
> mysql' and 'net start mysql' to start and stop the MySQL server.
>
> * I have done nothing special before rebooting my PC. The problem doesn't
> seem to lay in rebooting the PC, but in stopping and
Have you went into YaST and turn it on? I won't run until you do so. You
can start it yourself as well;
/etc/rc.d/mysql start
Chuck Payne
On Monday, July 1, 2002, at 09:47 AM, Cal Evans wrote:
> What's your log file say?
>
> *
> * Cal Evans
> * Journeyman Programmer
> * Techno-Mage
> * http:/
Try this query:
SELECT
yourcolumn+1
FROM yourtable
ORDER BY id desc
LIMIT 1;
greetings,
richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
Hey all,
I'm having problems ! , my app was running fine until this morning.
I receive following error :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Function sequence error
/clientenrollment.asp, line 67
the line 67 for that file is
oRS1.movef
Yes, I have
go to my.cnf and write
[mysqld]
user=root
then start the server with mysqld.
This works on my computer, but I'm not sure if the right way cause the the
server shouldn't use with the user root but for a test it's ok.
Have you already started the script mysql_install_db? It's necessa
SuSE 8 and for that matter all version of SuSE MySQl doesn't run until
you use YaST to turn it. That why it's not starting. You can start it
your by the following command;
/etc/rc.d/mysql start
If there is no problem with mysql you should see this
mysqld
> So it may seem that on your machine, with both MySQL and Access loaded
> together Access runs ever so much faster. However, you are comparing single
> use Access to single use MySQL. (also, once mysql starts caching things, it
> gets faster. The more you use it, the faster it runs!) Also, once y
Hi,
Thanx for your mail
You are rightin my case the mysqld is getting restarted.
But, whey is mysqld getting restarted and giving the Lost Connection error.
How can i avoid that??
Thanx
anil
- Original Message -
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
To: "Anil Garg" <[EMAIL PR
Andy,
File Systems are made to store and retrieve files in an efficient way. You
may not expect better performance when you put a database in between. When
speed is an issue you should use MySQL to store and retrieve filenames and
something like ReiserFS, RAID and good hardware to store images.
I've tried to get MySQL to install and run from source.
I configured and compiled without any errors. However when trying to start
the service i get the following:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Can anyone help me please? I'm running SuSE En
D.K.Dubey,
Monday, July 01, 2002, 2:13:25 PM, you wrote:
DKD> Thanks, I m using MySQl 3.23. Will u please tell me how it is possible.
It's possible to set ON DELETE CASCADE since 3.23.50:
http://www.mysql.com/doc/S/E/SEC446.html
--
For technical support contracts, goto https://order.
Hi all,
I want to setup (on linux systems) a pair of redundant mysql servers,
working this way :
* one master and one backup
* the master handles all the requests, the backup updates its data
frequently (and, if possible, CONSISTENTLY) from the master
* on failure of the master, the backup comes
I have mySQL 3.23.49 which seems to be crashing a lot. What is happening is I'm
using a web-based application written in perl using the perl DBI interface for
mySQL. It seems like whenever I make a change to the database via this
application the database develops corrupted tables. I am using th
I have a working server and a development server. From time to time
I'd like to "refresh" the content of my development server with what's
on my working server. So I take one of my regular backups, that I get
by doing "mysqldump database > dbbackupJuly1-02". Then I gzip this,
ftp it over to my de
On Mon, 1 Jul 2002, Nigel George wrote:
> I've tried to get MySQL to install and run from source.
>
> I configured and compiled without any errors. However when trying to start
> the service i get the following:
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.so
Hi!
It seems you still have an old mysqld running.
Check this:
ps ax | grep mysqld
and kill it if it does really present.
duo fu wrote:
>
> Dear all:
> I have just removed an old version of mysql and install MySQL3.23.51
> (tarball). After installation, I tried to start the server:
>
Hi all,
anyone know why this error would come up. This is running on a Linux box
[admin admin]$ scripts/mysql_install_db
bash: scripts/mysql_install_db: No such file or directory
Shawn
-
Before posting, please check:
h
Dear group.
I have on server Intel Pentium IV 1,8 GHz, 1GB RAM.
I would like to set some efficiency settings into my my_multi.conf of mysql .3.23
BUT although I read docs (unclear for me ;-)) I don't know how to set proper values
and where to set ones.
Problem is that servers stops answering fo
Jesse,
try to make dump (mysqldump) with option "--add-drop-table" or "--opt" (it
will be faster).
Description of this options see here
http://www.mysql.com/doc/m/y/mysqldump.html
Best regards,
Mikhail.
- Original Message -
From: "Jesse Sheidlower" <[EMAIL PROTECTED]>
To: <[EMAIL PROTEC
Alors!
I run MySQL-3.23.41 on FreeBSD-4.5-STABLE but everytime I get my system
slowing down and on checking with `top` I see MySQL as the culprit:
last pid: 29586; load averages: 1.41, 1.45, 1.48
up 28+10:55:17
20:10:59
90 processes: 3 r
use the --opt option for mysqldump.
--opt Same as --add-drop-table --add-locks --all
--extended-insert --quick --lock-tables
Other than that, it's the method I use.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
On 1 Jul 2002, at 12:30, Jesse Sheidlower wrote:
> What should I be doing instead? The docs don't seem to specify this,
> and there doesn't seem to be an "ignore" or "replace" option for the
> mysql command. Do I actually have to drop all the tables on my
> development box before loading in from
On Mon, 1 Jul 2002, Jesse Sheidlower wrote:
> I have a working server and a development server. From time to time
> I'd like to "refresh" the content of my development server with what's
> on my working server. So I take one of my regular backups, that I get
> by doing "mysqldump database > dbbac
Thanks to all who responded to this posting.
The problem was due to ODBC logging turned on. When this was rectified the
system flew along like a greyhound!
I appreciate the other helpful suggestions given. The reason for moving from
Access to MYSQL is that I am moving a GIS application developed
Marek,
check this URL http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Best regards,
Mikhail.
- Original Message -
From: "Marek Wysmulek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 6:56 PM
Subject: efficiency of mysql 2.23
> Dear group.
>
> I have on serve
If the file is actually there...
make sure the first line actually points to the perl
binary.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002
Egor Egorov wrote:
> Takacs,
> Thursday, June 27, 2002, 3:50:02 PM, you wrote:
>
> TI> Can I lock a field somehow against modification?
> TI> So I have a table and it has 4 fields.
> TI> I want to lock the same two fields in two records,
> TI> to not enable to modify those fields.
>
> TI> Can I
New "binary" character set should appear in next release.
It provides case-sensitive comparisons. It even doesn't
require recompiling mysqld, you need just to put binary.conf
file into /share directory of mysql installation, then restart
mysqld with "--default-character-set=binary" argument.
If yo
Hi Everybody,
My organization is looking for some secure GUI tool for MYSql.
If possible, something which use SSH.
I am new to MySql. Can anybody highlight on this and suggest some tools.
We use lynix with apache, tomcat installed on it and installed ver 3.23
of Mysql.
Thanks in advance
Roma
On Mon, Jul 01, 2002 at 01:23:38PM -0400, Keith C. Ivey wrote:
> On 1 Jul 2002, at 12:30, Jesse Sheidlower wrote:
>
> > What should I be doing instead? The docs don't seem to specify this,
> > and there doesn't seem to be an "ignore" or "replace" option for the
> > mysql command. Do I actually ha
Hi,
As a first step I would find out what mysql is doing, Use either
'show processlist' or using mysqladmin 'mysqladmin proc'. Or even
better install mytop (cd /usr/ports/databases/mytop; make install; ).
This program sorts the output for you. There does seem to be a
sometimes bug with mysql
Could you please let me know that how will I design ER diagram in MySQL.
Abhi
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
---
On Monday 01 July 2002 10:29, W. Enserink wrote:
> Hi all,
You would just do something like
SELECT max(idcolumn)+1 as nextvalue FROM tablename
where idcolumn is the name of the column and tablename is the name of your
table, but remember that you may need to serialize this, since probably the
http://www.thekompany.com/products/dataarchitect/
$49.00 - Well worth it even with it's flaws.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: abhishek sahay [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 1:33 PM
To:
ERwin, in which I did the logical data model for a MySQL database,
doesn't support MySQL data types or specific MySQL code export. Do any
tools? Notepad and vi look like my best physical design tools at this
point, which is okay. But I wanted to be sure I wasn't missing anything
out there -- alon
PowerDesigner from Sybase is awesome.
Nilesh
-Original Message-
From: Bill Bernat [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 3:25 PM
To: [EMAIL PROTECTED]
Subject: er diagramming
ERwin, in which I did the logical data model for a MySQL database,
doesn't support MySQL data t
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Michael Heinrich
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>R
> - Original Message -
> From: "Steve Edberg" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, June 28, 2002 1:49 PM
> Subject: RE: RecordCount
>
>
> > I assume you are using ODBC to access MySQL; I have had this problem
> > before (sorry, don't remember
Hi,
> -Original Message-
> From: Dave Harms [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 26, 2002 9:05 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL client unusable with large data sets
>
>
> I've been a loyal MySQL fan for a few years now, and use it
> extensively
> in web site
permissin problem
- Original Message -
From: Christopher Marsh-Bourdon <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 28, 2002 12:22 PM
Subject: mysql.sock and other small animals
> I have a bit of an issue:
>
> I have just upgraded my version of MySQL on my Cobalt Qube L
On Mon, Jul 01, 2002 at 06:24:45PM +0200, Mathieu DESPRIEE - NO SPAM wrote:
> Hi all,
>
>
> I want to setup (on linux systems) a pair of redundant mysql servers,
> working this way :
> * one master and one backup
> * the master handles all the requests, the backup updates its data
> frequently (
On Tue, Jun 11, 2002 at 03:58:14PM -0700, Jeff Kilbride wrote:
> > both InnoDB and MyISAM keep also dynamically statistics about tables. In
> > most cases running ANALYZE TABLE does not bring any benefit in query
> > optimization.
>
> Personally, I'm pretty shocked to hear you say this. I was und
W.,
Monday, July 01, 2002, 5:29:41 PM, you wrote:
WE> Does anybody know if there is a function to retrieve the next unique ID
WE> number for a record to be made in the future?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by En
Jonas,
Saturday, June 29, 2002, 12:20:41 PM, you wrote:
JO> I have just started to use MySQL and I have come up with a strange
JO> problem.
JO> I have a table with 28 rows. When I do 'SELECT * FROM table_name;' in
JO> the MySQL client it only shows 12 of these rows. But if i specify one of
JO> t
Somewhere within www.mysql.com is a link to a site that has an ERD tool that
supports MySQL...think the name is Dezigner or EasyDezign or something like
that. Search through the MySQL site and you'll find it. Free trial version
(limited entities) and the full tool isn't very expensive.
- O
http://www.datanamic.com/
DeZign for Databases...
- Original Message -
From: "Bill Bernat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 3:25 PM
Subject: er diagramming
ERwin, in which I did the logical data model for a MySQL database,
doesn't support MySQL d
> "Bert" == Bert VdB <[EMAIL PROTECTED]> writes:
Bert> Hi,
Bert> all you have to do use a transaction enabled data-source and use the
Bert> Mm-MysqlDriver
Bert> for your JDBC connections. (http://mmmysql.sourceforge.net/)
Bert> Best is to read the InnoDB documentation car
I ran this on several of my tables... I expected it to give me reccomendations on how
to improve my tables performance...
SELECT * FROM `5323` PROCEDURE ANALYSE()
It returned no results ever am I doing something wrong? Or, is this feature simply
not enabled on my system?
Running
MySQL 3.
Yeah, found it (per your other message), Dezign for Databases, looks
great for what I need to do and although I haven't had a chance to do
much with it it seems to work for basic entity relationships. I never
seem to use the full $3000++ functionality of Erwin/ER Designer, etc.,
which don't have
hi guys,
i have installed mysql v 3.23.44-nt on my XP using *Binary*
distribution, how can i now develop an InnoDB tables?
thanks very much
sql
--
Hytham Shehab
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Dat
Is there a good URL that explains in detail exactly the concepts of SQL
left/right inner/outer join? I've found several that give very high-level
hints, but nothing that really summarizes exactly what these do.
--
===
David M. Karr
Books on Line for Microsoft SQL server explain it nicely, and are free
whether you use SQL Server or not at
http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp
-billb
-Original Message-
From: David M. Karr [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 3:56 PM
To:
I would think the incremental cost of adding support (both forward and
reverse engineering) for databases such as MySQL would be minimal for
Computer Associates and other's who provide robust ERD apps like ERWin.
Perhaps we haven't been vocal enough with mainstream tool companies aboout
the need
You need to determine if your MySQL is reading it's directives from my.ini
or my.cnf. In the correct one, make sure you have commented out or removed
any line that reads "skip-innodb". then make sure you have directories set
up for the innodb files and that you've edited the paths to point to th
No takers? Any thoughts would be great.
--
David A. C. Beck
[EMAIL PROTECTED]
Valerie Daggett Laboratory
Biomolecular Structure and Design Program
Department of Medicinal Chemistry
University of Washington, Seattle
On Thu, 27 Jun 2002, Dave Beck wrote:
> the question:
>
> I am trying to use
G'day,
I've got a problem with the ODBC driver for MySQL, in that when I use an
SQL select statement on a field of type UNSIGNED INTEGER, the resulting
recordset in asp uses SIGNED INTEGER data types, so any data > 2^31 is
dropped by asp.
The offending code is as follows:
Set sqlComman
>Does anybody know if there is a function to retrieve the next unique ID
>number for a record to be made in the future?
I believe you can reliably allocate sequence numbers from a "sequence
table" (a table used only to dole out sequence numbers) like this:
create table sequence ( seq int not nul
hi everyone
function calls is workin fine now thnx a million :(
a new problem
im trying to upload a file from client
and i want it to be stored in mysql db table type myisam
is that possible
right now my code only copies the file on the disk
simple text but i want it in my data b
I am trying to import a text file that is tab delimited.
I am using the following , but it only returns one line.
LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO TABLE
Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
Why would it do one line and then stop? MySQL i
Hello Sinisa,
this has nothing to do with services. I have also tried this without
creating a service and the result is the same.
Normally the services are also stopped automatically when logging of, so I
don't understand why I should stop it manually. Also I have tested this
constantly by stopp
Hi,
I'm still stuck. If anyone has time, please take a look at this session
I had and any pointers would be great. I just went to mysql.com to search
the problem, but no site there..Weird.
thanks all,
Shawn
[root /root]# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: '
Hi again,
I really think you should walk yourself through the InnoDB user manual at
http://www.innodb.com/ibman.html
There's a lot of usefull and explanory information in there.
For your question:
ib_arch and ib_logfileX are the logs that InnoDB uses to track
committed transactions
and p
Hi all,
I have a problem about the access permission of mysql. I found that the
mysql client will be denied by the mysql server even I have granted the
permission already. The mysql client has already run and can connect to
the mysql server before... I am not sure what the problem is and so I
jus
96 matches
Mail list logo
