Hi!
In 3.23.41 there was a serious BLOB bug which
corrupted the table if you updated the primary key
of a long row.
There was also another bug in 3.23.41 which could
crash a query if you selected two long columns in the
same query.
There is a special page for bug reports at
the InnoDB website:
Dear sir,
Please help and drop me a email.([EMAIL PROTECTED])
I have Apache 1.3.17, MySQL 3.23.30 install on a Sparc Solaris 8 and Apache
1.3.20, MySQL 3.23.40 installed on a Interl RedHat Linux 7.1, I got
mod_auth_mysql-2.20 and following below instruction to compile and failed on
both platf
Hello,
I use 2 MySQL-3.23.41 servers. These serers do mutual replication.
I have problem with one table. In the table is a UNIQUE field. This field
is used by a RADIUS server which sometimes wants to store 2 (or more) rows
with the same ID (which is unique). For the master server it is
I am writing a perl script on FreeBSD 4.3 running PHP and MySQL, however i
get the following error message when I try and use DBI to connect to a
MySQL database to pull some data.
Can't locate DBI.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
/usr/libdata/perl/5.0
0503 /usr/local/li
I think mysqlfront is excellent.
http://www.mysqlfront.de/
HTH
Andrew Braund
> -Original Message-
> From: mike [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 25 September 2001 14:36
> To: Mysql
> Subject: mysql remote administration
>
>
> I am looking for a good programme to admin the da
I am looking for a good programme to admin the database on the remote
server. Any advice? Anyone using one they could recommend? I have
DBTools
and using this I can view the database names on the remote but I cannot
connect. I can only connect to the local MySql server.
I am using Windows 2000 a
Nope, I'm trying to create a client program for Macintosh.
regards,
Indramin
> From: Neil Zanella <[EMAIL PROTECTED]>
>
>
> Out of curiosity, why would you want to do this?
> Are you trying to use mysql with ASP
> instead of with PHP? Just curious...
>
> Neil
>
>
> On Tue, 25 Sep 2001, Ind
Hi Guys,
The following query that I am using is returning duplicate rows.
For a two word search:
SELECT DISTINCT
pdf.title,
pdf.filename,
searchwords.ranking,
pdf.summary
FROM
pdf,
words,
searchwords
WHERE
words.id = searchwords.wo
Out of curiosity, why would you want to do this?
Are you trying to use mysql with ASP
instead of with PHP? Just curious...
Neil
On Tue, 25 Sep 2001, Indramin Darmadi wrote:
> Hi all,
>
> I'm a newbie. My question is : Is it possible to access a MySQL table using
> RealBasic?
>
> If any of yo
Hi all,
I'm a newbie. My question is : Is it possible to access a MySQL table using
RealBasic?
If any of you has an experience with it, thanks for sharing.
Regards,
Indramin
-
Before posting, please check:
http://www.mys
Hi Carlos!
> I was wondering how I could go about dropping all existing tables from a
> database? Rather than using a DROP TABLE that lists each table I wish to
> drop is there not some way to drop all existing tables in a database? Even
> if I cannot remember all the table names?
Mysqldump is
Does MySQL support SQL-92's DECLARE CURSOR and FETCH?
Thanks
Jeff Tanner
Seattle, WA
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
What I did to handle global changes was have one access file on the
fileserver that everyone had a shortcut to. That way the updates
were global since they were all to the same file.
Dave
On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote:
> > Another small research in Access made me t
> Another small research in Access made me to see the changed
> table structure
> completely. Please use this procedure to view or to refresh
> links when the
> structure or location of a linked table has changed.
>
> 1. Open the database in access that contains links to tables.
> 2. On the Too
> Another small research in Access made me to see the changed
> table structure
> completely. Please use this procedure to view or to refresh
> links when the
> structure or location of a linked table has changed.
>
> 1. Open the database in access that contains links to tables.
> 2. On the Too
On Mon, Sep 24, 2001 at 03:02:42PM -0700, Venu wrote:
> Hi
>
> Another small research in Access made me to see the changed table structure
> completely. Please use this procedure to view or to refresh links when the
> structure or location of a linked table has changed.
>
> 1. Open the data
> As a quick note, I tried the same with MS SQL Server through
> its latest ODBC
> driver by adding the new column, and I couldn't see any changes in the
> linked tables from Access 2002.
>
> So it shows clearly that, its some thing related to MS
> Access, not with the
> driver. It might be a b
Hi everyone,
I was wondering how I could go about dropping all existing tables from a
database? Rather than using a DROP TABLE that lists each table I wish to
drop is there not some way to drop all existing tables in a database? Even
if I cannot remember all the table names?
I could delete
Hi
Another small research in Access made me to see the changed table structure
completely. Please use this procedure to view or to refresh links when the
structure or location of a linked table has changed.
1. Open the database in access that contains links to tables.
2. On the Tools menu,
I would have to guess that you have a broken index.
bill
-Original Message-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 3:50 PM
To: [EMAIL PROTECTED]
Subject: very strange query behavior
can anybody explain this to me?
mysql> select count(*) from memb
Hi !!
As a quick note, I tried the same with MS SQL Server through its latest ODBC
driver by adding the new column, and I couldn't see any changes in the
linked tables from Access 2002.
So it shows clearly that, its some thing related to MS Access, not with the
driver. It might be a bug from Acc
>Description:
I compiled MySQL 3.23.39 from the Source RPM
Compilation went fine. (These is 1.1MB log file for anyone interrested)
Compile command was:
sparc32 rpm -bb --clean mysql-3.23.29.spec 2>&1|tee mysql.log
Starting mysqld however burbed with the following
I was never able to see the changes in table structure with
Access and Oracle unless I manually added the column to linked
table in Access after I had added it in Oracle.
Dave
On Mon, Sep 24, 2001 at 02:34:30PM -0700, Venu wrote:
> Hi Douglas and David !!
>
> > I have the following setup...
> >
> > Now I've found when I do changes to a table schema the
> changes are not
> > entirely at least reflected in a the same table linked in Access.
> > I had once
> > case where I changed a data type on one of the columns and
> that data type
> > was not changed on the linked table in Access. I h
Hi Douglas and David !!
> I have the following setup...
>
> - MySQL 3.22.32 on OpenBSD v2.9
> - MyODBC on Windows '98 SE
> - MS Access 2000
>
Cool !!!
> Now I've found when I do changes to a table schema the changes are not
> entirely at least reflected in a the same table linked in Access.
Harpreet wrote:
>
> I am trying to use MYSQL CLIENT for the first time. I have setup the mysql
> server and connect to it from my machine using Telnet.
> But everytime i try to connect using mysql client or through access 2000 i
> get the following error:
>
> Host 'ip address' is not allowed to
I've had the same issues. I have really avoided the dev side of things
for some time so I'm not sure whether there's a way around it. Mainly
just devoting myself to administration. Funny though I'm starting to
write jsp stuff to monitor the databases more effectively.
I agree with you on the MYO
> What type of schema do mean here ? Because as you know, MySQL doesn't
> explicitly supports any schema's except the catalogs( in MySQL term
> 'database'). If you can elaborate what exactly the problem
> you are facing,
> then we can provide a rapid solution.
>
> Also, as for as I know, when I
can anybody explain this to me?
mysql> select count(*) from members where country_id = 1 and read_array not
like '%20270%';
+--+
| count(*) |
+--+
|34884 |
+--+
mysql> select count(*) from members where country_id = 1 and read_array like
'%20270%';
+--+
| coun
What causes this error:
3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c
mysqld.cc
mysqld.cc: In function `void *handle_connections_sockets (void *)':
/usr/include/tcpd.h:131: too many arguments to function `void sock_host
()'
mysqld.cc:2339: at this point in file
/usr/include/
From: Bertrand TACHAGO <[EMAIL PROTECTED]>
> i'm using Linux Red Hat 7.0 and i want to know how to add mysql to my
> startup.
Your MySQL shipped with a file called 'mysql.server', this is the control script. Put
that into your RC tree and set it to be executable.
I've got this:
% cp /usr/lo
mysql must own the database directories.
chown -R mysql /var/lib/mysql
( or whatever the database directory is )
Mike Eggleston wrote:
> Folks,
>
> I know I am new here, and I really need your help. You see, the MySQL
> server is saying that it cannot find the host.frm file. Now, I can see i
Hi,
i'm using Linux Red Hat 7.0 and i want to know how to add mysql to my
startup.
Thanks in advance
--
Moise Bertrand TACHAGO
Computer scientist
Volunteer DBMS Specialist
SDNP Cameroon, 506 Hajal Center Building
Yaounde CAMEROON
(237)22 24 90
E_mail [EMAIL PROTECTED]
[EMAIL PROTECTED]
--
Folks,
I know I am new here, and I really need your help. You see, the MySQL
server is saying that it cannot find the host.frm file. Now, I can see it
clear as day, and I think that I have the configurations correctly. However
I really am a programmer, not a server admin. Could someone out th
>Description:
This is the log file (some characters are cyrillic KOI8):
Number of processes running now: 0
010924 21:57:51 mysqld restarted
InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequen
From: Gerald Clark <[EMAIL PROTECTED]>
> Default values must be constants.
> Håkan Elmqvist wrote:
> > Now I want to register who changed it...
===> MY two cents worth:
With MySQL, this sort of thing usually gets handled in a piece of software. In Perl,
we might say something like:
$sth =
>
> After working with me on a project, att.beready.com tech support has
noticed
> something wrong with one of the downloads, they have downloaded the
> mysql-3.23.40-pc-linux-gnu-i686.tar.gz
>
> problem identified:
> we have downloaded and ftped this file to three different boxes and
continue
>
So sprach »Erin Lilly« am 2001-09-24 um 14:53:27 -0500 :
>
> After working with me on a project, att.beready.com tech support has noticed
> something wrong with one of the downloads, they have downloaded the
> mysql-3.23.40-pc-linux-gnu-i686.tar.gz
Any particular reason you're trying to setup s
I am trying to use MYSQL CLIENT for the first time. I have setup the mysql
server and connect to it from my machine using Telnet.
But everytime i try to connect using mysql client or through access 2000 i
get the following error:
Host 'ip address' is not allowed to connect to this MySQL server
p
You can't.
Default values must be constants.
Håkan Elmqvist wrote:
> Timestamp is a useful datatype when you want to register when a record
> changed. Now I want to register who changed it and tried to use user()
> as a default value and my database just returned user() as the field
> value.
After working with me on a project, att.beready.com tech support has noticed
something wrong with one of the downloads, they have downloaded the
mysql-3.23.40-pc-linux-gnu-i686.tar.gz
problem identified:
we have downloaded and ftped this file to three different boxes and continue
to get a compr
Hi!
On Sep 24, Adam Douglas wrote:
>
> my main concern is to find a Windows MySQL GUI Client that will do everything
> in a similar fashion as Access.
If I'm not mistaken you can just continue to use Access as a GUI and for
rapid prototyping, connecting it to MySQL via ODBC.
Regards,
Sergei
-
Hi!
Just an update to this thread: the replication
failure of auto-inc columns has probably been
traced. Replication assumes that auto-inc
values for a multiline insert or
INSERT INTO ... SELECT ... are assigned strictly
consecutively, while InnoDB assigns them in parallel.
A symptom of the bug
R Talbot wrote:
R Talbot wrote:
Still having compile problems and GNU binary
produces the following info
> Michael Widenius wrote:
>
>
>
> The problem is probably that your tar
>program doesn't use user-names
>
> > but user-ids, in which case the files may
> be owned by 'anyone.
>>
> Wh
Hi!
On Sep 24, Thiago Madeira de Lima wrote:
>
>
> I lost the .MYI file, I still have the FRM and MYD files.
>
> There's any way to recover this table? Recreating the index file?
Sure.
See http://www.mysql.com/doc/R/e/Repair.html (Stage 3: Difficult repair)
Regards,
Sergei
--
MySQL
>> Now I have quite a bit of information on all these questions.. my
>> main concern is to find a Windows MySQL GUI Client that will do
everything
>> in a similar fashion as Access. I believe we would need the
>> basics but also
>> including visual query builder and reports. I've recently fou
Hi Robert,
I have experience the similar issue with MySQL, MM.MySQL and JBOSS.
I was using CMP-EJBs with INNODB table from MySQL-Max and data did not
persist in the table as I called EJB create(). The issue resolved as I
'alt' the table back to MyISAM tables.
I have posted the issu
From: T. S. Parikh <[EMAIL PROTECTED]>
> ...I would like to generate a MySQL DB from this data model.
> ...Er Studio doesnt directly support outputting to MySQL.
This is an interesting topic, IMHO. Tim Bunce has a mysql-to-oracle converter that he
mentioned on this list:
ARCHIVE: http://list
Hi again!
I had read all help in winmysqlamin, but i feel it's not enough, because i need tutor
step by step.Excepecially to Mr Miguel A. Solarzano, can you give me information about
manual to use winmysqladmin.
Thanks
Regard,
Feny Soeha
Student
-
Hi, I have used Er Studio to do my data modelling for a DB I am working on,
and now I would like to generate a MySQL DB from this data model. Problemis
that Er Studio doesnt directly support outputting to MySQL. Has anyone
found a work-around for this? Maybe I can output to SQL meant for anoth
Hi
> Now I have quite a bit of information on all these questions.. my
> main concern is to find a Windows MySQL GUI Client that will do everything
> in a similar fashion as Access. I believe we would need the
> basics but also
> including visual query builder and reports. I've recentl
I lost the .MYI file, I still have the FRM and MYD files.
There's any way to recover this table? Recreating the index file?
thanks
Thiago Lima.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I am not sure if my problem is with MySQL or PHP. I am trying to learn
both using the book PHP and MySQL Web Development. In using an example
script for creating a password protected logon page I receive an message
"Resource id #2" Does anyone know what this means?
Thank you very much for y
From: katty Iniguez <[EMAIL PROTECTED]>
> make: /usr/bin/ld: cannot find -lmysqlclient
> collect2: ld returned 1 exit status
> make: *** [radius] Error 1
>
> Now, i added the line: /proc/6/fd/mysqlclient - - - (that is where I found
> lmysqlclient)
This location probably isn't what you want. Y
"katty Iniguez" <[EMAIL PROTECTED]> writes:
> I use Linux RedHat 7.0
>
> I installed and Configured MySQL-3.23.42
>
> I am installing icradius-0.18.1
>
> installing icradius I got the following:
>
> make: /usr/bin/ld: cannot find -lmysqlclient
> collect2: ld returned 1 exit status
> make: ***
I use Linux RedHat 7.0
I installed and Configured MySQL-3.23.42
I am installing icradius-0.18.1
installing icradius I got the following:
make: /usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [radius] Error 1
Now, i added the line: /proc/6/fd/mysqlclient -
I use Linux RedHat 7.0
I installed and Configured MySQL-3.23.42
I am installing icradius-0.18.1
installing icradius I got the following:
make: /usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [radius] Error 1
Now, i added the line: /proc/6/fd/mysqlclient -
Hi!
I built my database and then used the command:
ALTER TABLE disc ADD FULLTEXT (title,recentdata,specialsound,uniqueid)
But if I try to search with this command:
SELECT title, recentdata, specialsound,uniqueid FROM disc WHERE MATCH
(title) AGAINST ('Superman')
Hi. I'm looking for any support/help that one is willing to give to
assist me in convincing the company I work for to switch over to MySQL as
there sole database system. We currently use MS Access which we all know is
a some what to be desired database. I have to answer the following quest
Alex,
at the maximum it has to scan the whole size of its log
files. In the 'applying log records to the database'
phase it may take a long time because of disk i/o.
Thus, it is really not possible to know the remaining
time precisely since the amount of disk i/o may vary
in different phases of
Howdy all...
New to MySQL and I've got a question. I have an application that does a
good deal of hierarchical reporting. In order to do this one of the tables
in my database contains nothing more than an individuals id and the team to
which that individual reports
TABLE - TEAMREPORT
At 04:03 24/09/01 -0700, John Nyukuri wrote:
Hi!
>I downloaded the installation.zip mysql version onto a windowsNT machine
>on a network.I installed it as a standalone server unfortunately I am
>unable to find the command prompt inorder to begin executing commands,can
>you specify for me the file
Very
There are tools to migrate from or to
oracle,XL,Access
Simon
-Original Message-
From: Radhakrishnan Sundaresan [mailto:[EMAIL PROTECTED]]
Sent: 24 September 2001 15:52
To: [EMAIL PROTECTED]
Subject: Migrating to other databases
Hi
I was won
Hi
I was wondering how easy or difficult it is to migrate from
MySQL
Radhakrishnan Sundaresan
Graduate Research Assistant
Cluster I/O Labs, Ohio State University
Ph: (Res) 614-291-1217
(Off) 614-292-8458
-
Bef
O' MyT SQL wizards!
I'm a total newbidiot w/ regard to MySql. I bought the O'Reilly
book and it's been a big help, but I have a problem that book
doesn't even gloss-over:
One table has a (large) list of developers (100,000+), each of
which can be a member of 0-5 project teams.
Another table is
Will,
First of all, if I sounded condescending, it was not my intent. I apologize
if that's how you (or anyone else) took it. I will, however, respond to
your smoking response to mine:
> > I think no-one's replied because the answer is really simple
>
> Oh I don't know Jay, I've seen some thre
Yes !! Marco Bizzarri find the trick : he said
You should install MySQL-client also and now mysql
and mysqladmin are there.
Thanks to all ans specially to Marco
Jean
On Mon, 24 Sep 2001 [EMAIL PROTECTED] wrote:
> Date: Mon, 24 Sep 2001 16:28:23 +0200 (
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 24 Sep 2001, jean.schuller wrote:
>
> Hi all,
>
> I get MySQL-3.23.42-1.i386.rpm and made a full install
> using rpm -i MySQL-3.23.42-1.i386.rpm which seems to
> be ok. My big problem is : nowhere I can found "mysql"
I've tried to read through a fair bit of the manual, but I haven't quite
found out yet: does MySQL support Unicode? I'm talking Strings from Java,
using mm.mysql driver.
--
Mvh,
Endre
-
Before posting, please check:
http:/
Hi.
On Sat, Sep 22, 2001 at 03:38:45PM +0200, [EMAIL PROTECTED] wrote:
>
> I have some questions about MySQL replication and table locking:
> 1. If I lock a table on the master server, the table will be locked on
> the slave server?
It will be locked whenever the slave gets to execute th
Hi all,
I get MySQL-3.23.42-1.i386.rpm and made a full install
using rpm -i MySQL-3.23.42-1.i386.rpm which seems to
be ok. My big problem is : nowhere I can found "mysql",
mysqladmin etc ?? Where are they gone ??
Thanks for all advices
Je
> I think no-one's replied because the answer is really simple
Oh I don't know Jay, I've seen some threads 4-5 responses deep to issues far
simpler than this.
> create a recordset using Select for the records you are interested
> in (using your joins), then use that recordset to perform your
> U
Hi Jacques!
> I'm working with a table that includes a field "id INTEGER AUTO-INCREMENT
> NOT NULL" .
>
> When I create a new record with the query "INSERT", I don't give any value
> for the id field, the value is automatically given by mySQL.
> As the database is supposed to be used on the WEB,
Hello!
I've had that same problem. I don't know the cause of the problem, but I solved it by
replacing:
my_socket fd; /* For Perl DBI/dbd */
by
/* my_socket fd;*/ /* For Perl DBI/dbd */
So, simply edit the mysql_com.h file and comment it out!
Greetin
Hello Laurent and jeroen!
> >I'm using mySQL/PHP on a macOSX machine and found myslf in trouble while trying
> >to import data from our filemaker pro database.
> i've got the same problem with a french vocabulary database that I want to
> import into a mySql database.
Has anyone seen http://www
I'm working with a table that includes a field "id INTEGER AUTO-INCREMENT
NOT NULL" .
When I create a new record with the query "INSERT", I don't give any value
for the id field, the value is automatically given by mySQL.
As the database is supposed to be used on the WEB, several queries INSERT
Thanx
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Sunday, September 23, 2001 9:35 PM
Subject: Re: MySQL 4.0
> On Sun, Sep 23, 2001 at 07:54:59PM
I'm not up on expect, but I would assume that since you can use sh then you
should ber able to use expect.
Generally speaking in sh you can do the following:
#!/bin/sh
MYSQLCMD="/usr/local/bin./mysql"
USER="me'
HOST="some.host.com"
PASSWD="whatever"
QUERY="SELECT userId FROM thisTable WHERE id=
Bonjour,
I've rebooted my server with "sync;sync;reboot". It seems that
Mysql/InnoDB did not have enough time for shutting down properly
because when the server restarted I had these messages in the error
log of Mysql :
InnoDB: Doing recovery: scanned up to log sequence number
Hi,
How much memory does mysql executable take in the ram?
What is its code memory foot print?
regards
Rock
=
__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger.
http://im.yahoo.com
--
>
> imho, the fact that mysql does not support joins in UPDATE and DELETE
> statements is by far its greatest weakness. I have posted a couple of
> messages to this group to see what creative work-arounds others
> have used to
> fill this gaping hole in functionality. Alas, no one has felt
> lik
Hi,
If you want to enter MySQL commands for making tables etc, run
'c:\mysql\bin\mysql.exe' (If thats where its installed on your machine),
from either the DOS command line (cmd) or the windows 'Run...' box.
Andrew
-Original Message-
From: John Nyukuri [mailto:[EMAIL PROTECTED]]
Sent: 2
I downloaded the installation.zip mysql version onto a windowsNT machine
on a network.I installed it as a standalone server unfortunately I am
unable to find the command prompt inorder to begin executing commands,can
you specify for me the file I should open.
---
Hi.
On Fri, Sep 21, 2001 at 02:31:44PM -0700, [EMAIL PROTECTED] wrote:
> I'm having a difficult time synchronizing my Master and Slave Servers.
> I've been doing this using MySQL Binary Logs, where the Master rotates the
> logs at 1 hour times, and the slave downloads it and imports it.
>
> What
Hello.
On Fri, Sep 21, 2001 at 04:29:04PM -0500, [EMAIL PROTECTED] wrote:
> If I want to filter out records when SELECTing from a database, how do I do
> it with an
> and/or type of statement. Like this:
>
> SELECT * FROM websites WHERE keywords LIKE '%akeyword%' AND/OR description
> LIKE '%des
Fred van Engen wrote:
>
> Rafal,
>
> On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote:
> > Why is mysql locking table during insert operastion? The version is 3.23.22, so
> > it shouldn't behave like this...
> >
>
> If you mean it shouldn't behave like this because it does concurrent
Hi All,
I am building a web site that will be connected to a mysql database. I
am testing both locally and on server. At the moment I have a problem.
Locally the connection is fine with no errors displayed. However, when
viewing the same file on the server I get the following error.
Warning: Sup
Rafal,
On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote:
> Why is mysql locking table during insert operastion? The version is 3.23.22, so
> it shouldn't behave like this...
>
If you mean it shouldn't behave like this because it does concurrent
inserts, then note that they work only o
Hi,
I have strange problem with mysql. When I run mysqladmin processlist i get
output (I cut off selects):
| 4045633 | konkursy | targi1.wp.pl | konkursy2 | Query |
14| Locked | insert into bb2_ludzie_tak values
('Marzena')
GUYOT Carole writes:
> I'm trying to insert records from a file. These records are separated
> with pipes.
>
> load data local infile "aid.exp" into table aid;
How is MySQL supposed to know that you're using a
non-standard way of separating your records if you don't
tell it? :-O
You need to sp
Ok,
I was able to repeat the
InnoDB: error in sec index entry update in ...
error with a table containing just 2 rows :).
The error happens when you UPDATE or REPLACE
a character column where only the case of the letters
changes:
mysql> update bob set b = 'AMBJORG' where a = 7400;
Query O
>I'm using mySQL/PHP on a macOSX machine and found myslf in trouble while trying
>to import data from our filemaker pro database.
Hi!
i've got the same problem with a french vocabulary database that I want to
import into a mySql database.
I tried to convert the comma-separated txt file into u
I'm trying to insert records from a file. These records are separated
with pipes.
use crous;
load data local infile "aid.exp" into table aid;
When I do "select * from aid" , the first column is OK but the
second and third columns are nulls for all rows.
It's weird!
Has anyone experienced t
93 matches
Mail list logo
