I am trying to install the mySQL on our remote server thr putty (SSH).
Following are the set of commands given by me,
I have downloaded mysql-3.23 for BSDi.
1)put into /usr/home/mysql-src directory and given following 2 commands
going into
shell>cd /usr/home/mysql-src
shell>gunzip mysql-.
Hi Jenny,
The formatting are the same -MM-DD HH: -
The timestamp field is set automatic by the system when updating a record.
The date/time fields are for Your control and usage.
Take a look in the manual 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types
Best regards
Peter
- Origin
Hi,
You can have a look at the Delphi 5&6/Kylix 1&2 single source components from SciBit
at www.scibit.com/mysqlcomponents.
Kind Regards
SciBit MySQL Team
>
> -Original Message-
> From: "Pierre du Parte" <[EMAIL PROTECTED]>
> To: "Daniel Kiss" <[EMAIL PROTECTED]>
> CC: "[EMAIL PROTECT
Can anyone see any problems with using the HPUX 10.20 MySQL binaries on
HPUX 11.00- it seems to work fine in small scale tests.
Regards,
Ian Collins.
-
Before posting, please check:
http://www.mysql.com/manual.php (t
Hello All,
I m using mysql 3.23.42 and myodbc 3.51 on linux7.2.
I use SQLDescribeCol API to get type of column(field).
When i call above functuon it returns type of datetime
and timestamp is 93 for both. but the format of
inserting using sql query, datetime value uses ( " "
)and timesstamp value i
Hello All,
I m using mysql 3.23.42 and myodbc 3.51 on linux7.2.
I use SQLDescribeCol API to get type of column(field).
When i call above functuon it returns type of datetime
and timestamp is 93 for both. but the format of
inserting datetime value uses ( " " )and timesstamp
value is different.
I m
Hello Daniel!
It works fine. Been using it for several years. Close your connection and
query objects and there will be no AV problems...
Fredrick
- Original Message -
From: "Pierre du Parte" <[EMAIL PROTECTED]>
To: "Daniel Kiss" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesda
hi all,
is there any command in mysql prompt for set page size and set line size
like SQL*Plus?
TIA
ivan paul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Tue, Jul 23, 2002 at 09:22:55PM -0600, Steve Dickey wrote:
> Can anyone tell me how to get an RPM that provides the
> libmysqlclient.so.10? I am trying to install the
> php-mysql-4.1.2-7.i386.rpm and it says that this is a requirement. It
> comes in an older version of the mysql database r
Another grant command for the existing privileges + index privs. should work
Bhavin.
- Original Message -
From: "Paul Maine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 24, 2002 5:33 PM
Subject: RE: Grant question
> I have an existing mysql user that I wish to add
Pada Wed, 24 Jul 2002 18:52:44 -0500
"Paul Maine" <[EMAIL PROTECTED]> menulis :
> I have an existing mysql user that I wish to add the INDEX privilege. Is
> there a command that I can use to add a privilege without first deleting the
> user and then recreating with the GRANT command?
you can run
>From: [EMAIL PROTECTED]
>To: "Desmond Lee" <[EMAIL PROTECTED]>
>Subject: Re: THIS IS NOT AN ADVERTISEMENT Date: Thu, 25 Jul 2002 03:37:48
>+0200
>
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>o
I have 3 tables tableA, tableB and tableC and the fields tableA.id,
tableB.idA and tableC.idA.
I'm using this query (bellow) to call information from the database that has
in tableA but tableA.id is not found on tableB.idA and tableC.idA.
SELECT tableA.*
FROM tableA
LEFT JOIN tableB ON (tab
I may be a little OT, but the current myODBC driver does work quite well
with Access. So you can use Access to write your queries and app etc and
have mySQL as your backend.
I've mainly used Access and myODBC to port & manipulate Access data to
mySQL. For writing mySQL frontends my preferred d
Daniel,
Personally I found ZEOS a pain in proverbial - poorly documented,
constant AVs etc.. D6 dbExpress works very well for me, but I think it
only comes with D6 Enterprise. The myODBC driver is another way to go,
in which case you could probably use the BDE.
There is an ADO driver for mySQL
Hi All,
Sorry about the typo. "MySQL4.0.2a" should be "MySql4.0.2a-Max" instead.
Thank you.
Regards,
Michael
-Original Message-
From: Tam, Michael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 10:54 AM
To: [EMAIL PROTECTED]
Subject: RE: Problem downloading MySQL4.0.2a for wi
I have an existing mysql user that I wish to add the INDEX privilege. Is
there a
command that I can use to add a privilege without first deleting the user
and then recreating with the GRANT command?
Thank You
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: We
Bhavin
I'm doing queries to one table with 4 other smaller tables.
The large table is 12-14 million records. With an index,
the table select is 13-15 seconds. With a compound index,
the delay is sub one second. Use explain to verify which
index is being used. Read the manual to tune your index's.
Hi,
When I try to execute scripts/mysql_install_db, I get
some errors about some libraries missing:
exec(): 0509-036 Cannot load program
./bin/my_print_defaults because of the following
errors:
0509-150 Dependent module libz.a(shr.o) could not be
loaded.
0509-022 Cannot load module libz.a(shr.
I have an existing mysql user that I wish to add the INDEX privilege. Is
there a command that I can use to add a privilege without first deleting the
user and then recreating with the GRANT command?
Thank You
-
Before posting,
Hello there
Mysql documentation says the following:
"values are stored using only as many characters as are needed, plus one
byte to record the length. Values are not padded; instead, trailing spaces
are removed when values are stored."
So, then would there be anything wrong with making all
Hi,
Does anyone know how to separate values in a text area field, to enter
the separated values into a database?
For instance if enter these values into a text area field
Dogs
Cats
Fish
I want to be able to take Dogs, Cats and Fish and put them in different
rows in a database. I guess the bi
Pada Wed, 24 Jul 2002 18:43:43 +0200
Daniel Brockhaus <[EMAIL PROTECTED]> menulis :
> At 16:53 24.07.02 +0700, you wrote:
> >Pada Wed, 24 Jul 2002 11:01:24 +0200
> >Daniel Brockhaus <[EMAIL PROTECTED]> menulis :
> >
> > > well, the subject says it all. I'm using version 3.23.41-log, and I got
>
Hello there
Mysql documentation says the following:
"values are stored using only as many characters as are needed, plus one
byte to record the length. Values are not padded; instead, trailing spaces
are removed when values are stored."
So, then would there be anything wrong with making all
I'm assuming you have AUTO_INCREMENT columns in each table?
Try this:
INSERT INTO TABLE1(...) VALUES(...);
SELECT @t1id := LAST_INSERT_ID();
INSERT INTO TABLE1A(table1_id, ...) VALUES(@t1id, );
INSERT INTO TABLE1B(table1_id, ...) VALUES(@t1id, );
...
-JF
> -Original Message-
>
In the last episode (Jul 24), Dave Dutcher said:
> I was wondering if somebody could give me any suggestions on how to optimize
> a query I am working on.
>
> This is my table:
>
> CREATE TABLE testdata (
> Begin char(9) NOT NULL default '',
> End char(9) NOT NULL default '',
> UNIQUE KEY
hi guys,
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
characters of language such as hebrew/arabic?
thanks for help
sql
--
Hytham Shehab
-
Before posting, please check:
http://www.mysql.com/
On Wed, 24 Jul 2002, Dermot Paikkos wrote:
> Date: Wed, 24 Jul 2002 17:46:00 +0100
> From: Dermot Paikkos <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: how to update time field with current time?
>
> Hi
> Probably a silly question but how can I set a time field to the current
> time wi
>Description:
Make reports this:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1325: too few arguments to function `gethostbyname_r'
libmysql.c:1325: warning: assignment makes pointer from integ
On 2002-07-24 08:46, "Dermot Paikkos" <[EMAIL PROTECTED]> wrote:
> Hi
> Probably a silly question but how can I set a time field to the current
> time with update in mysql?
>
> I have 4 time fields per record. Should I have used set them up as
> timestamp?
Now() will update to the current time
You gave the answer. Using left join it will work and give you NULL values
for not found records.
I had a similar problem here and left join worked ok.
Bye,
Anderson Ataides
=
Em Quarta 24 Julho 2002 03:51, you wrote:
> Hi
>
> I'm de
It would be a lot easier for you to have just used a timestamp, it automatically
updates itself when a record is modified.
Otherwise you would just update the time field in question when you do your other
updates
SET timefield = NOW() should work
Though using a TIME datatype is not very inform
Hello,
I am working on MySQL database. I have come across a 'problem' but don't know
how to get around that. The problem is the following:
I have a table, say TABLE1, with primary key being called as table1_id.
Now there are other tables, like TABLE1A, TABLE1B, TABLE1C etc.. where I want to
us
Hello,
I am running mysql in our production environment, which have a few reporting
tables with millions of rows. Certain queries cascade 2 such tables that
have millions of rows and there by, there are extremely slow, sometimes
taking over 10 minutes.
However, we are ok with that since the size o
Hi, I did some more research on my problem. (Sorry for not doing it before
I posted the other message), and I think perhaps my question could be
summarized into the following.
Can I use an index to speed up a select max() or select min()?
I read what the manual has to say about a query like thi
Hi,
I uploaded the table under
ftp://support.mysql.com/pub/mysql/secret/config.tar.gz
To reproduce the bug :
SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+(tes*) +test' IN
BOOLEAN MODE);
SELECT pseudo FROM config WHERE MATCH (config) AGAINST ('+tes* +test' IN
BOOLEAN MODE);
mysql>
I was wondering if somebody could give me any suggestions on how to optimize
a query I am working on.
This is my table:
CREATE TABLE testdata (
Begin char(9) NOT NULL default '',
End char(9) NOT NULL default '',
UNIQUE KEY BeginEndIndex (Begin,End)
) TYPE=MyISAM;
It is a table of ranges.
Hi All,
Do anyone knows when the MySQL4.0.2a for windows is available for
download? Thanks.
Regards,
Michael
-Original Message-
From: Tam, Michael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:38 AM
To: 'Victoria Reznichenko'; [EMAIL PROTECTED]
Subject: RE: Problem down
Hi,
You must reconfigure "httpd.conf" , because i suppose that you don't change
the
path to your new location of the CGI scriptor...you not have right to
execute "POST/GET" method on your serverand this mean that your CGI
script can not run.
This error is specific about what i aforemention
Hi,
I'm in the same situation (installing mysql on a raq4).
The package master site's most recent version (that I noticed) of mysql is
MySQL 3.23.37
Does anyone have suggestions for a more recent version in .pkg?
Thanks,
Brian
Description:
The problem is affected in combination with 'order by' and
'rand()'.
Please check the report under:
http://bugs.php.net/bug.php?id=13287&edit=1
How-To-Repeat:
You can compare my results with the method which is reported in
php
bug report number
Question is, can you connect via the mysql client. This looks like an
authentication issue as opposed to something specific to PHP.
Bhavin.
- Original Message -
From: "Ingrid Kast Fuller" <[EMAIL PROTECTED]>
To: "chuck amadi" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, Ju
Hi!
> "Minjie" == Minjie Qiu <[EMAIL PROTECTED]> writes:
Minjie> Hello,
Minjie> I'm working on a purge utility to purge 3 tables: call_record,
Minjie> modem_call_rec and makrup. Those 3 tables are related with foreign key
Minjie> recid, so I used the following sql to purge data that is ol
Hi
Probably a silly question but how can I set a time field to the current
time with update in mysql?
I have 4 time fields per record. Should I have used set them up as
timestamp?
Thanx.
Dp.
~~
Dermot Paikkos * [EMAIL PROTECTED]
Network Administrator @ Science Photo Library
Phone: 0207 432 11
At 16:53 24.07.02 +0700, you wrote:
>Pada Wed, 24 Jul 2002 11:01:24 +0200
>Daniel Brockhaus <[EMAIL PROTECTED]> menulis :
>
> > well, the subject says it all. I'm using version 3.23.41-log, and I got
> the
> > following error message when trying to update a row:
> >
> > Got error 127 from table h
Hi.
On Wed 2002-07-24 at 09:46:03 +0100, [EMAIL PROTECTED] wrote:
> As I understand it an ANSI92 join is written as;
>
> SELECT b.columnA
> FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id
Ah. Okay. Was not aware that this was new in ANSI92.
> Whereas the 'old' style would be;
>
> SELECT
My MySQL server 3.23.51 died in an hour after
I created a table containing "longtext" field.
I am not sure that this was the reason but
suspect so since it was running for few weeks
w/out problems.
It stopped accepting answering TCP & UNIX socket
connections, although was still listening on TCP.
Hi,
You must reconfigure "httpd.conf" , because i suppose you don't change the
path to your new location of the CGI scriptor...you not have right to
execute "POST/GET" method on your serverand this mean that your CGI
script can not run.
This error is specific about what i aforementioned.
I am currently using MySQL version 3.23.39-max-nt, MS Access 2000 as my
gui, and MyODBC 2.50.39-nt
I am able to run reports, queries and use the SQL pass through in access
to retrieve data from the MySQL database through MyODBC. The
problem is that I can not create a table in MySQL from Acces
I have come across a problem compiling MySQL 3.23.51 on a SuSE 8.0
computer. I have tried compiling the same source code on a SuSE 7.3
computer with no apparent problems. Note that I have not actually used
the version compiled on the 7.3 machine - I simply wanted to make sure it
would compile.
Check you users table under 'mysql' database. This is what controls access.
Here, check the 'hosts' column. Update the old IP/DSN to the new ones and
then do a 'flush privileges' and you should be fine.
If you don't want to update but add a new record that should be fine to.
Do a GRANT . for
Hi!
On Jul 24, Jocelyn Fournier wrote:
> Hi,
>
> I've encountered a similar bug on my own table.
> If you want, I can upload a tar.gz of my table (5 MB), with the associated
> query needed to reproduce the problem ?
>
> Regards,
> Jocelyn
sure, thank you.
upload it to ftp://support.mysql.co
I'm having problems installing MySQL Server 3.23.51. When trying, I'm using
all standard options during installation. Quite late in the installation --
it seems like after all files have been unpacked and copied to their proper
locations -- I get an error message titled "InstallShield Engine".
De
In the last episode (Jul 23), Steve Dickey said:
> Can anyone tell me how to get an RPM that provides the
> libmysqlclient.so.10? I am trying to install the
> php-mysql-4.1.2-7.i386.rpm and it says that this is a requirement. It
> comes in an older version of the mysql database rpm but I have
On Wednesday 24 July 2002 17:23, Sinisa Milivojevic wrote:
> Sergey S. Kostyliov writes:
> > At first I want to thank you for a fast answer,
> >
> > On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
> > > On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
> > > > >Description:
> > > >
> >
Pete French wrote:
>>We are discussing the 'mysql' client which is often used to write
>>scripts that run under the
>>UNIX shell.
>>
>...
>
>>If you write a script that has two semi-colons in a row, the second one
>>is ignored and no error message is given.
>>
>
>Err, not true (in amysql scr
Hi!
Do anybody can help me?
Every time a program has an error and did his backout, all other
programs get an "Lock wait timeout" if they do an update.
Allways I have to restart the database to get back the access for the
programs.
The programm with the error did his backout completely!
We use
Sergey S. Kostyliov writes:
> At first I want to thank you for a fast answer,
>
> On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
> > On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
> > > >Description:
> > >
> > > ERROR 2013: Lost connection to MySQL server during query.
>
> > >
Let us say I have two tables tab1 and tab2.
tab1:
col1
col2
tab2:
col3
col4
For my search, a user can enter space delimited words to search, e.g.,
microsoft windows xp
i have to search for EACH of these words, and join the 2 tables too, so
my sql query looks somewhat like thi
Well I have FreeBSD 4.2 and MySQL 3.23.33 running on localhost.
I use PhpMyAdmin to do any modifications. I did make the nameserver changes
in:
Database ShoppingCart - table stores
Database mysql - table db
Database mysql - table host
Database mysql - table user
I reset mysql and apache and stil
Network access or remote access is handled by the OS such as Linux.
All you need to do is make sure you have a user setup that is allowed to
access the database from those locations. Example:
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
-> IDENTIFI
Thanks, that was simple enough...guess I just couldnt think of that.
Thanks again!
-Nick
Gordon said:
> Try round(value*4,0)/4
> Worked on the samples I tried
>
>> -Original Message-
>> From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, July 23, 2002 1:47 PM
>> To: [EMAIL
Hi all,
I have a table with a field full of urls.. what I need to do is to append
to those urls with a new url, so for example, if the field had
http://www.yahoo.com i want to make it
http://www.myserver.com/login?url=http://www.yahoo.com ..
I have tried the following which I thought should wor
I just moved my servers and have new DNS names and IP addresses.
I need to update my MySQL databases because our Ecommerce sites are giving
"Internal Server Errors" in Apache, see this link:
http://www.toyotaworld.com/cart/toyotaecommerce.cgi?store=toyotaecommerce&ac
tion=file&file=home.tmpl
I
[EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text
Hello,
I've been using MySQL for over 2 years in my Bacula
GPL project (network backup program). To simplify
installation for users, I would like to offer them
the possibility of using the embedded MySQL server.
However, I'm having a few problems, and maybe you
can help me:
1. There seems to be
>Description:
Strange NULL in reply.
>How-To-Repeat:
mysql> CREATE TABLE S (ID1 int, ID2 int, ID int NOT NULL
AUTO_INCREMENT,PRIMARY KEY(ID));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into S values
(1,244,NULL),(2,243,NULL),(134,223,NULL),(185,186,NULL);
Query OK, 4 rows affected (0.00
Hi Guys
Sorry this is quite off topic.
Any idea hows IT doing in Brazil...
-Arul
sql , query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
On Tue, 2002-07-23 at 21:04, Bill Bernat wrote:
> Hey, thanks *so* much for checking into this.
>
> Your message did help. In case you're curious. First, I had the admin
> create a 777 dump directory from root. Still couldn't write out. Then,
> though, I just tried going to /tmp as you had do
Hi,
I've encountered a similar bug on my own table.
If you want, I can upload a tar.gz of my table (5 MB), with the associated
query needed to reproduce the problem ?
Regards,
Jocelyn
- Original Message -
From: "Artem V. Ryabov" <[EMAIL PROTECTED]>
To: "Sergei Golubchik" <[EMAIL PROTE
By coincidence, we had this yesterday for the first time
in our experience. It is a corrupt table, and we fixed
is with isamchk. We are running an older version, you might
have to use myisamchk.
_justin
=
Daniel Brockhaus wrote:
>
> Hi,
>
> well, the subject says it all.
Pada Wed, 24 Jul 2002 11:01:24 +0200
Daniel Brockhaus <[EMAIL PROTECTED]> menulis :
> Hi,
>
> well, the subject says it all. I'm using version 3.23.41-log, and I got the
> following error message when trying to update a row:
>
> Got error 127 from table handler (1030)
>
> It's a normal query
Use:
tabProds LEFT JOIN tabUsers ON tabProds.usr_ID = tabUsers.usr_ID
from the manual:
If there is no matching record for the right table in the |ON| or
|USING| part in a |LEFT JOIN|, a row with all columns set to |NULL| is
used for the right table.
Jorge Garza wrote:
>Hi
>
>I'm designing 2
Hi,
Yes, I'm using it actually, but I ask te author if MySQL features will be
extended to stored procedures, when will he come out with the new version.
He told me that he finished the development of the component set and gave
it to sourcesorge.net to continue it. Anyway, the newest version of
hi all,
is there any command in mysql prompt for set page size and set line size
like SQL*Plus?
TIA
ivan paul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
> We are discussing the 'mysql' client which is often used to write
> scripts that run under the
> UNIX shell.
...
> If you write a script that has two semi-colons in a row, the second one
> is ignored and no error message is given.
Err, not true (in amysql script anyway)
I think you are tryi
Sergio,
Wednesday, July 24, 2002, 6:15:57 AM, you wrote:
SB> Im getting in trouble trying to restore a .sql dump generated with
SB> mysqldump for a database with lots of foreign keys because of the
SB> order of tables in the .sql. the first table already declares a
SB> FOREIGN KEY referencing a t
Bill,
Tuesday, July 23, 2002, 11:04:27 PM, you wrote:
BB> Also, do you happen to know how old is 3.23.21-beta-log? Our MYSQL is
BB> old, but I can't find out how old, is there a version history online
BB> anywhere?
Check MySQL manual:
http://www.mysql.com/doc/index.html
--
For techn
James,
Tuesday, July 23, 2002, 8:32:10 PM, you wrote:
JC> There didn't seem to be any responses to this question last time I posted.
JC> So I'll try again. Does anyone know where to locate mysqlimport logs, if
JC> there are any?
No, mysqlimport doesn't write logs and you can't see warnings.
mys
Daniel,
Monday, July 22, 2002, 11:47:17 AM, you wrote:
DK> Nikolaos and Victoria,
DK> Victoria! Just like Nikolaos, I also don't know what you mean send new
DK> character sets as seen with the explanations.
DK> The first thing I have to mention that I'm not sure how MySQL string
DK> compariso
Publici-Textes,
Tuesday, July 23, 2002, 10:40:40 PM, you wrote:
PT> In MSAccess, I am able to use a query as a (partial) source for another query.
PT> LSelect Names, Department from qrySelectedEmployees, tblDepartment
PT> where qrySelectedEmployees.EmplId = tblDepartment.EmplId
PT> Is this pos
Yamin,
Monday, July 22, 2002, 11:15:30 AM, you wrote:
YP> I had a auto increment column
YP> let say the auto increment would look like this
YP> 100,1001,1003,1101,1103,10005,10006
YP> yes I had delete several column in tha past
YP> now I would like to sort it again so it would be an order from
Steve,
Monday, July 22, 2002, 3:39:52 AM, you wrote:
SD> I am a MySQL newbie and can not seem to find the documentation that
SD> explains how to allow network or remote access to a running MySQL
SD> server. It does not seem to be in the my.cnf file or in the manual???
SD> I am sure this is a
Daniel,
Wednesday, July 24, 2002, 11:23:05 AM, you wrote:
DK> Can someone tell me what is the best MySQL native component set for Delphi?
DK> It does not matter if it is commercial, but I need one urgently.
I'm not a professional with Delphi+MySQL, but Zeos Library looks fine
for me:
http://
Hello.
Is there a tool that i can use to convert mysql tables
(structure) to dbf tables?
Most of the tools i encounter converts dbf to mysql. I want to
do it the other way around.
tia
Get your own "800" number
Voicemail, fax, email, and a lo
>Description:
Strange NULL in reply.
>How-To-Repeat:
mysql> CREATE TABLE S (ID1 int, ID2 int, ID int NOT NULL
AUTO_INCREMENT,PRIMARY KEY(ID));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into S values
(1,244,NULL),(2,243,NULL),(134,223,NULL),(185,186,NULL);
Query OK, 4 rows affected (0.00
Hi,
well, the subject says it all. I'm using version 3.23.41-log, and I got the
following error message when trying to update a row:
Got error 127 from table handler (1030)
It's a normal query which has succeeded several thousand times already.
Any ideas what might be wrong?
Thanks,
Daniel
Hi,
As I understand it an ANSI92 join is written as;
SELECT b.columnA
FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id
Whereas the 'old' style would be;
SELECT b.columnA
FROM tableB AS b, tableC AS c
WHERE b.id = c.id
Personally I find the former much easier to read though not sure about
t
Hello Sergei,
Tuesday, July 23, 2002, 10:17:06 PM, you wrote:
SG> Hi!
SG> On Jul 23, Artem V. Ryabov wrote:
>> Hello mysql,
>>
>> see this 2 queries:
>> why they not equal?
>> why first skip many records?
>>
>> mysql> select left(ftText,20) from Txt_index where match(ftText)
>against('+(wùd2
Hi again . I have a project whereby the client has a legacy M$ Access (
as far as im concerned ) and i'm to design.build and construct a MySql
v4 Back-end and more than likely pursue a front-end with MS Access due
to easability and conversant of it's user's nevertheless are there any
field da
Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any
issues that should be addressed ie uninstall v3 prior to installing v4
or can i just install over v3.
Any suggested sites' ,FAQ regarding my question.
--
Regards
Chuck Amadi
ICT Dept Systems Programmer
Rhaglenydd System
Hi,
Can someone tell me what is the best MySQL native component set for Delphi?
It does not matter if it is commercial, but I need one urgently.
Thanks,
Daniel
-
Before posting, please check:
http://www.mysql.com/ma
92 matches
Mail list logo