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
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,
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: '
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
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
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
>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
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
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
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
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
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:
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
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
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
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.
> "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
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
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
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
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
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
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 (
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
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
> - 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
>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
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
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
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:
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
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
---
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
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 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
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
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
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
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
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
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
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
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
*
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
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
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
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
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:
>
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
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
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
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
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.
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
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.
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
> 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
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
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
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
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
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:/
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
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
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>
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
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
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
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
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
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
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
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
/_/ /_/\
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
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
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!
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
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!
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 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!
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
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> +-+-+--+-
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
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
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
> 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
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
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
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 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
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
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
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
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
* [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,
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
96 matches
Mail list logo
