hi guyz
(pardon me fo this loong mail)
my mysql s runnin finally
accepting my user login n all thank heavens
now i m havin a bit of a prob with php myadmin
i found a backup of my last configuartion n i ve copied it on (since the new
one just wouldn work with me)
im gettin all these errors
whe
Sorry, I missed PARENT's COLUMNs.
Corrects.
ALTER TABLE CONS_CHILD ADD FOREIGN KEY CONS_CHILD_FK ( A , B ) REFERENCES
CONS_PARENT(A, B ) on delete cascade ;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> SHOW CRE
Hello.
I have a problem on "ALTER TABLE ... ADD FOREIGN KEY".
I'm using InnoDBs, and I wanna create Foreign Key after table has been created.
But, 'ALTER TABLE .. ADD FOREIGN KEY" does not work.
Manual says :
The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything
And in my
Hello, Freinds!
I'm new to MySQL.
Anyway...
My O/S is FreeBSD 4.6.
In /etc/hosts there are only two line.
127.0.0.1localhostlocalhost.paldal.com
192.168.0.88unix.paldal.comunix
And in /etc/host.conf,
first seek : /etc/hosts
second seek : bind
And some PHP cod
Hi Users,
I have some problems with my database and not being quite profficient in SQL,
I did myisamcheck and posted the data on the site below:
http://ns2.wananchi.com/~wash/RT2/myisamcheck.txt
I am wondering if someone can take a look and possibly tell me if they notice
a problem and what I c
Dear mysql ,
MRS ELIZABETH OBED
C/O. SAM BELLO
BARRISTER SAM BELLO & CO.
LEGAL PRACTITIONAL 2,
FALOHUN STREET,
AGUDA S/L LAGOS,
NIGERIA.
FAX: 234-1-7594260
I am Mrs. Elziabeth Obed, widow of the late Lt. Col. M. Obed, the former military
Administrator of Kaduna state of Nigeria. my late husban
Hello,
I am running MySql on a Windows 2000 PIII-1Ghz PC with 256MB of RAM. I
have three table that need to get updates when a new record gets
created. I have minimized the number of indexes on the tables and the
insert process goes like this:
(All three tables have a primary key to prevent du
at work I run mysql 3.23.45. on a windows2000 machine with apache 1.3.23
and php4.06. at home it's Linux SuSe *.0, mysql 4.03 apache 1.3.26 and
php4.2.3. the problem is I'm having problems inserting data into
temporary tables. the results are different running the same script.
here is the script (
On Fri, 2002-09-27 at 19:27, DeNewbie wrote:
>
> I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to
>use PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to
>install these RPM files.
>
> MySQL-3.23.52-1.i386.rpm
> MySQL-client-3.23
Thanks for your reply.
Just out of curiousity, is it possible to use it by "echoing" back the
password somehow?
I think that "echoing" back the reply would work great if I ever needed
any unattended process using scripts.
Thanks.
Peter
On Fri, 27 Sep 2002, [ISO-8859-1] Iikka Meriläinen wrote:
Oops correction:
"If you run you system at a different run level like 3 then go to /rc3.d/
directory and change the file name there."
-Original Message-
From: Duke, Brian
Sent: Friday, September 27, 2002 3:45 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Mysql and RedHat 7.3
Did you install from the SuSE CD? If so then you have to tell YaST to start
MySQL. You can start it from /etc/rc.d/mysql. If you want to use PHP you
will need to tell YaST to install PHP for apache as well. SuSE has made
running MySQL and PHP so easy by using YaST. Also run YaST to update PHP
ther
Hi all. I'm trying to load a file into mysql using "load data infile" and
got a ton of warnings. Is there any way to see what the warnings are?
Thanks.
David
-
Before posting, please check:
http://www.mysql.com/manual.php
-- Forwarded message --
Date: Fri, 27 Sep 2002 19:27:22 -0400
From: DeNewbie <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Basic RPM Installation
>
> I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to
>use PHP and MySQL and I am reading the M
On Thursday 26 September 2002 11:16 pm, Jeremy Zawodny scribbled something
about:
> On Thu, Sep 26, 2002 at 11:24:14AM -0700, Gary Traffanstedt wrote:
> > sql,query
> >
> > I have a table that has approximately 40 colums and all but 1 of
> > them I have been able to make fixed width. The sole hol
I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to use
PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to
install these RPM files.
MySQL-3.23.52-1.i386.rpm
MySQL-client-3.23.52-1.i386.rpm
MySQL-devel-3.23.52-1.i386.rpm
They all
On Friday, September 27, 2002, at 12:56 PM, hans schneidhofer wrote:
> hi list,
> have a simple newbie-question
> was looking for a possibility to go back one step after do a "use
> sample_db"
> but cannot find anything in the doc-files.
>
> what I mean is this :
> logging into mysql with using
Hello Luc,
At 03:13 PM 9/27/2002 -0400, Luc Foisy wrote:
>When I installed Mysql ( whatever the current 3.x series is on RedHat 7.3,
>the service did not start when I restarted. If you have gnome installed,
>you can acess Service Configuration and set MySQL to start when system
>boots. Just
Redhat...Linux systems:
running Xwindows login at runlevel5
cd /etc/rc.d/init.d/rc5.d/
search for "mysqld"
mv ./K74mysqld ./S78mysqld
The K denotes "Kill"
The S denotes "Start"
If you run you system at a different run level like 3 then go to /rc5.d/
directory and change the file name there. T
Hi Cristiana,
I am another FreeBSD user and I can tell you that FreeBSD 4.1.1
does have problems with threads. I would very much recommend that you
update as there are also many security problems with that version if
you are running a server that is remotely available. There were many
thread
Don't have a fix but look at the swap file size. May need to increase that.
A further note MS Access on NT run 100%,...100% of the time.
-Original Message-
From: John R. Diehl, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 1:05 PM
To: Peter Zuidema; [EMAIL PROTECTED]
Su
Hi there
Just type in: "show databases;", which will list all databases,
then type in: "use mysql;" or whichever database you require
Simple
Clive
hans schneidhofer wrote:
> hi list,
> have a simple newbie-question
> was looking for a possibility to go back one step after do a "use sample_db"
Steven Kreuzer wrote:
>http://www.stunnel.org/examples/mysql.html
>
>SK
>
>mysql, sql, query
>
>On Thursday, September 26, 2002, at 12:40 PM, John Holmes wrote:
>
>
>
>>>I am connecting to a mysql server on a remote machine, and opened up
>>>
>>>
>>port
>>
>>
>>>3306 for this purpose
I'm using FreeBSD 4.6 and MySQL 3.23.36
I keep trying to grant file privileges to a user, but no matter what I do,
it seems that the customer keeps getting access denied errors.
They are trying to execute the following:
select * into outfile '/tmp/list.txt' fields terminated by "|" lines termina
On Friday, September 27, 2002, at 12:28 PM, root wrote:
>
> I tried to start it with safe-mysqld --u=mysql &when I ran the
> mysqltest I get cannot connect to local mysql server through socket
> '/var/lib/mysql/mysql.sock'>
> [A
> Any idea ...
Try:
safe_mysqld -u=mysql &
or
saf
Hi there
Try This:
SELECT products.product_name, products.fg_number, images.image_name,
images.thumbnail, images.image_path, images.color_depth,
images.width_inches, images.height_inches, images.resolution,
images.filesize, images.filetype, images.notes
FROM products LEFT JOIN images ON produc
Then try:
select somefields,fieldname + 0 as orderfield order by orderfield
John Almberg wrote:
>Nope. I've tried every combination I can think of of these ideas. They all
>give syntax errors. I don't think arithmatic is allowed in an ORDER BY
>clause. Doesn't even work on an INT field.
>
>--
Yes, that worked. Thanks to all who contributed similar solutions!
Now I'm going to mention MySQL in my message so that my message isn't
rejected as spam by the list manager! (What's that all about???)
Thanks again (mentioning MySQL again (just to be safe))
-- John
> -Original Message-
Yes, that works! Thanks very much to all who suggested similar solutions!
-- John
> -Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 1:33 PM
> To: John Almberg
> Cc: Mysql
> Subject: Re: FW: SQL question
>
>
> John Almberg wrote:
>
hi list,
have a simple newbie-question
was looking for a possibility to go back one step after do a "use sample_db"
but cannot find anything in the doc-files.
what I mean is this :
logging into mysql with using :
mysql -u root -p
then I get :
mysql >
now I'm using "use sample_db"
and can do some
We're having a problem with a huge merge table and BETWEEN. The same query
in MySQL 3, using an identical (binary) copy of the database, takes a
fraction of a second, in MySQL 4.03 it runs without stopping.
The query is a simple "Select * from my_merge_table where my_code BETWEEN
'2026676653' AN
I tried to start it with safe-mysqld --u=mysql &when I ran the mysqltest I get
cannot connect to local mysql server through socket '/var/lib/mysql/mysql.sock'>
[A
Any idea ...
-
Before posting, please check:
http
I have two tables:
products
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra
|
+-+--+--+-+-++
| id | int(6) |
Is there anyway within a mysql batch script to make individual statements silent?
For example, if I have a script like:
select @t1:=desc from decode_table where id=42;
select @t2:=desc from decode_table where id=64;
select concat('the msg is ',ifnull(@t1,42),' part two is ',ifnull(@t2,64));
I jus
When I installed Mysql ( whatever the current 3.x series is on RedHat 7.3, the service
did not start when I restarted.
If you have gnome installed, you can acess Service Configuration and set MySQL to
start when system boots.
Just information for those that may experience this.
Luc Foisy
If you find an answer, I would really like to hear about it. I have
been working on this for months. No one seems to have a clear answer,
although several people have reported curing it by either adding your
server to c:\WINNT\system32\drivers\etc\hosts or setting the mysql
service up to run
>From what I heard, yes.
If you stop MySQL, then rename the
dir/database.
It may work. Worked for me (did it
about 3 months ago).
HTH,
Ricardo.
- Original Message -
From: "Jorge Martinez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 11:57 AM
Subject: renam
Yes, that works! Thank you very much!
-- John
> -Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 1:33 PM
> To: John Almberg
> Cc: Mysql
> Subject: Re: FW: SQL question
>
>
> John Almberg wrote:
>
> >Nope. I've tried every combinati
http://www.stunnel.org/examples/mysql.html
SK
mysql, sql, query
On Thursday, September 26, 2002, at 12:40 PM, John Holmes wrote:
>> I am connecting to a mysql server on a remote machine, and opened up
> port
>> 3306 for this purpose. But, I am concerned about sending a clear text
>> password,
Hi,
I've got two tables, links and categories.
links ...
id int(11) NOT NULL auto_increment,
name text,
note text,
link text,
category1 int(11) NOT NULL default '0',
category2 int(11) NOT NULL default '0',
category3 int(11) NOT NULL default '0',
date_added timestamp(14) NOT NUL
Dears,
I'm running a postfix box with a mysql virtual users database on a
FreeBSD 4.6.2 machine. It is a dual Xeon 800, 2GB RAM, 140GB Raid5 SCSI.
This postfix holds about 11.000 virtual accounts and I'm running on a
big problem.
Whem mysql approaches 240 simultaneous conections I get this err
I'm new at SQL so I may be off base, but in traditional programming practice
when you want that kind of sort (right justified) you would fill the field
with preceding zeros and that would cause the sort that you are seeking.
I'm sure that you could suppress the zeros on print with some sort of mas
Hi,
use this: mysql -u root -ppassword
It's important NOT to put a space between -p and the real password. Having a
password in a script is unsafe at its best, though. I'm not sure if you have
any other options than to put it that way or enter it manually each time you
run the script.
Regards,
Dawn Friedland wrote:
>Prior to my client requesting that I add Japanese content to the content
>tool & database, I had zero experience with characters sets other than
>Latin. I always used notepad to filter out any weird MS Word formattings
>and left the default as ANSI.
>
I had that problem a
On Friday, September 27, 2002, at 07:57 AM, Jorge Martinez wrote:
> Exists any way to rename a database ?
>
> Thanks Jorge
>
> sql
You can create a new database and then:
Rename Table old_database.table_name to new_database.table_name.
You would have to do this for every table. You could t
>Description:
hi mysql team,
i am a mysql newbie (my first time i install it)
i give up, i can't solve the problem without help.
all the time i try to start the mysqld, it ends up instantly with a shutdown
of mysqld, i cant run the prog: i edited the mysqld.log and tried to figure
out the problem,
A couple things off the top of my head:
- Have you looked into MySQL's 'SET' type?
- What about something like SELECT 0+fieldname as zerofield FROM table ORDER
BY zerofield;
- Would using grouping help?
- Have you considered creating a custom character set? (This may be too
extreme. Can be d
Hi,
I changed my hostname(The DNS change was taken care of elseware) in FreeBSD
4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it
failed to start the slave. In the new error log I saw:
020927 10:15:58 mysqld started
020927 10:15:59 InnoDB: Started
020927 10:15:59 Cou
John Almberg wrote:
>Nope. I've tried every combination I can think of of these ideas. They all
>give syntax errors. I don't think arithmatic is allowed in an ORDER BY
>clause. Doesn't even work on an INT field.
>
>-- John
>
>
Have you tried a computed column, i.e,
SELECT BLAH, 0 + BLAH as ord
On Thursday, September 26, 2002, at 10:46 AM, Darrell A. Sullivan, II
wrote:
> I am sure I am going to feel ignorant when I get the answer to this
> question
> because it will be something simple that I have overlooked, but here
> goes
> anyhow.
>
> I am using MySQL Version 3.23.51-max.
>
> I
I just tried it and it works fine. It doesn't solve my similar problem,
which is related to letters coming *before* numbers, but the parser doesn't
reject it.
Wish I could offer a solution, but I'm not very knowledgable about MySQL
internals & config.
-Derek
> -Original Message-
> From:
Hi Carl,
Thanks for your reply.
I have created a shell script but I get stuck on the part where it asks to
input password.
How do I get the script to input the password that I put in?
So far my script looks like this:
./mysql -u 'root' -p
echo "abc"
The script executes, but it just waits for
It is supported in MySQL 4.0.x if you use the InnoDb table handler. I'm
not sure about 4.1.
>>> Remco Barendse <[EMAIL PROTECTED]> 09/27/02 09:29AM >>>
Hi!
According to the website MySQL 4.0.x supports "foreign key
constraints".
For version 4.1 "foreign key integrity rules" are planned.
What
At 17:29 +0200 9/27/02, Remco Barendse wrote:
>Hi!
>
>According to the website MySQL 4.0.x supports "foreign key constraints".
>
>For version 4.1 "foreign key integrity rules" are planned.
>
>What is the difference between these 2? On previous versions of MySQL it
>was possible to create foreign k
Remco,
Friday, September 27, 2002, 6:29:28 PM, you wrote:
RB> According to the website MySQL 4.0.x supports "foreign key constraints".
RB> For version 4.1 "foreign key integrity rules" are planned.
RB> What is the difference between these 2? On previous versions of MySQL it
RB> was possible to
Here is a small example I have just run :
mysql> create table test (f char(20));
Query OK, 0 rows affected (0.90 sec)
mysql> insert into test values ('11xbc');
Query OK, 1 row affected (0.01 sec)
mysql> insert into test values ('2bcv');
Query OK, 1 row affected (0.00 sec)
mysql> insert into te
How about
SELECT fieldname FROM table ORDER BY CAST(fieldname as SIGNED)
UNSIGNED could replace SIGNED, depending on your needs.
this works for me on Mysql 4.02 alpha on solaris
regards,
sean peters
[EMAIL PROTECTED]
- Original Message -
From: "John Almberg" <[EMAIL PROTECTED]>
To: "
Cyril,
Friday, September 27, 2002, 4:19:25 PM, you wrote:
CZ> if I build mysql with
CZ> ./configure --with-charset=koi8_ru
CZ> then check (make; make check; make test) failed!
Because MySQL by default uses latin1 character set and you have compiled only
with koi8_ru.
CZ> But if I build mysql wi
On Thursday, September 26, 2002, at 06:30 AM, Egor Egorov wrote:
> Clayburn,
> Thursday, September 26, 2002, 3:58:13 AM, you wrote:
>
> CWJI> I create a table with a VarChar field set to not null. When I
> do an
> CWJI> insert into this table with no value for this field it goes
> thr
Hi,
I have a table used for generating stats (In fact it is phpTracker)
What I am trying to do is to generate the 1st page visited and the last
paged visited, per session, but grouped together.
i.e.
request_timeSession referer_uri
21/09/2002 12:51:08
Hi,
I have a table used for generating stats (In fact it is phpTracker)
What I am trying to do is to generate the 1st page visited and the last
paged visited, per session, but grouped together.
i.e.
request_timeSession referer_uri
21/09/2002 12:51:08
Hi all.
I execute the query SELECT NOW() in Delphi 5.0 against MySQL 3.22.30 and
Delphi understand that the column of the query is of type ftString (String)
when it should be ftDateTime (datetime).
Any query I execute that contains a datetime column returns the datetime
type.
In MySQL 4.0.3 I d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 26 September 2002 15:11, Klaus Friis Østergaard wrote:
> Is it possible to run the new MySQL 4.0.3 on a system that uses glibc-2.1.3,
> especially the MySQL-shared?
Not using the precompiled binaries from the download pages (they have be
try corereader at http://ww.corereader.com/
it's certainly not designed to create reports with
much of eye candy.
however, it queries mysql and access (and any other
data source), lets you create queries with point and
click, stores queries and connections, and gives you
a few report header
Vaso,
Thursday, September 26, 2002, 11:48:03 PM, you wrote:
VK> Hello Victoria,
VK> I have installed mysql 3.23.49 for Sorlaris and I have installed it
VK> from the source distribution.
I checked it on 3.23.52 installed from binary and it worked well.
VK> Do you have any idea about my problem
Hi!
According to the website MySQL 4.0.x supports "foreign key constraints".
For version 4.1 "foreign key integrity rules" are planned.
What is the difference between these 2? On previous versions of MySQL it
was possible to create foreign keys but changed data was not replicated to
other tab
Nope. I've tried every combination I can think of of these ideas. They all
give syntax errors. I don't think arithmatic is allowed in an ORDER BY
clause. Doesn't even work on an INT field.
-- John
> -Original Message-
> From: gerald_clark [mailto:[EMAIL PROTECTED]]
> Sent: Friday, Septe
Hello Ozette,
At 05:36 AM 9/27/2002 -0400, Ozette Brown wrote:
>To stop a running query, you'll need to do a 'myqsladmin processlist'
> and once you find the PID for the query, issues a "mysqladmin kill PID".
>This should do the trick.
Is there not a more elegant solution? Would not the above
Exists any way to rename a database ?
Thanks Jorge
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
I don't know that there is knowing the way sorts usually work I'd say no.
This is my first posting to this group and I am just in the initial phases
of supporting MySQL as a backend for out application.
If the numbers always precede the letters I would split them off into two
separate columns and
I am new to InnoDb and was wondering what steps I would have to do to
restore a table. Lets assume I am backing up the data by backing up the
tablespaces.
Thanks in advance
(MySQL, query)
-
Before posting, please check:
htt
I've installed the windows version of mysql. I configured nothing.
This is the code I'm trying to use to access mysql from an asp web service
(in vb):
-
Public Function dbConnect() As String
Dim connString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
Joel Rees wrote:
>Shift-JIS is a real pain in the neck to parse. When you look at a byte,
>it's often impossible to tell whether you're looking at the first byte
>or the second byte of the character.
>
Can I make a minor recommendation that doesn't help your current
situation at all?
Use UTF-8.
ORDER BY 0 + fieldname
if this is not quit right try
ORDER BY 0 + fieldname , fieldname
John Almberg wrote:
>That gives a syntax error, unfortunately.
>
>-- JOhn
>
>
>
>>-Original Message-
>>From: Mihail Manolov [mailto:[EMAIL PROTECTED]]
>>Sent: Thursday, September 26, 2002 9:51
This is documented behavior.
Indexes are not used with DESC.
Ver 4.X does, however support DESC with an index.
Grigoriy Vinogradov wrote:
>Bug Report:
>
>Version: 3.23.51-max
>OS: Windows ME
>
>Problem:
>Synopsis: Does not use index when ordering records on datetime field in
>the descending orde
Hi Jay,
see http://www.mysql.com/press/release_2002_10.html for an overview.
HTH,
Michael
Jay Fields wrote:
>
> I'm building an asp.net app and I want to connect to mysql, but I dont what
> which DataAdapter to use, and I don't know what Provider to specify in my
> connection string. Anyone
mysqladmin is in the clients rpm.
Niko Itajarvi wrote:
>I installed the MySQL-3.23.52-1.i386.rpm packet on my RedHat 7.3 server
>machine.
>Installation went OK, then it told me to change my root password by typeing:
>
>/usr/bin/mysqladmin -u root password newpasswd
>
>But i cant find mysqladmi
Try:
SELECT fieldname FROM table ORDER BY 0+fieldname;
Regards
John Almberg wrote:
> That gives a syntax error, unfortunately.
>
> -- JOhn
>
>
>>-Original Message-
>>From: Mihail Manolov [mailto:[EMAIL PROTECTED]]
>>Sent: Thursday, September 26, 2002 9:51 PM
>>To: Mysql
>>Subject: Re
Victoria Reznichenko wrote:
> Cyril,
> Thursday, September 26, 2002, 11:30:39 PM, you wrote:
>
> CZ> ---cut---
> mysql> DROP TABLE IF EXISTS COUNTRIES;
> CZ> Query OK, 0 rows affected (0.02 sec)
>
> mysql> CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
> CZ> -> PRIMARY KEY
While the subject sounds counter-intuitive, I think I'm trying to do something simple
and I can't figure it out.
I have a simple table, "lookup", with two columns, id and decode. I want to write a
simple query that retrieves the decode if there, and the id if the row is missing for
a given lit
Hello CP,
Friday, September 27, 2002, 3:11:14 AM, you wrote:
C> hi Victoria, thanks for the reply. I have set server id in the very
C> beginning, but its still not working. I don't understand why the MySQL would
C> not let me change its server id accordingly. The server id was set to 1.
You must
Michael,
Friday, September 27, 2002, 3:16:49 PM, you wrote:
MJF> I seem to be running into a very strange problem.
MJF> In the mySQL command line interface I issue SELECT COUNT (*) FROM
MJF> test; and get --> ERROR 1064: You have an error in your SQL syntax
MJF> near '(*) from test' at line 1.
On Fri, 27 Sep 2002, Michael J. Fuhrman wrote:
> Hello All,
>
> I seem to be running into a very strange problem.
>
> In the mySQL command line interface I issue SELECT COUNT (*) FROM
The correct syntax is SELCT COUNT(*) ie, there's no space between SELECT
and the (*).
Andy
--
I'm building an asp.net app and I want to connect to mysql, but I dont what
which DataAdapter to use, and I don't know what Provider to specify in my
connection string. Anyone have any advice?
-
Before posting, please check:
That gives a syntax error, unfortunately.
-- JOhn
> -Original Message-
> From: Mihail Manolov [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 26, 2002 9:51 PM
> To: Mysql
> Subject: Re: SQL question
>
>
> Try:
>
> SELECT fieldname FROM table ORDER 0+fieldname;
>
>
> Hope it helps.
Michael J. Fuhrman wrote:
> Hello All,
>
> I seem to be running into a very strange problem.
>
> In the mySQL command line interface I issue SELECT COUNT (*) FROM
> test; and get --> ERROR 1064: You have an error in your SQL syntax
> near '(*) from test' at line 1.
>
> Below is the test table:
Try without the blank
count(*) instead of count (*)
Easy mistake to make i guess, but remember that count() is a function and
should have brackets.
Regards
Torbjørn
On Fri, 27 Sep 2002, Michael J. Fuhrman wrote:
> Hello All,
>
> I seem to be running into a very strange problem.
>
> In the myS
On Fri, 27 Sep 2002 08:16:49 -0400
"Michael J. Fuhrman" <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I seem to be running into a very strange problem.
>
> In the mySQL command line interface I issue SELECT COUNT (*) FROM
> test; and get --> ERROR 1064: You have an error in your SQL syntax
> near
Hello All,
When passing a connection object between DLL's it appears that myODBC
driver is not able to create Editable RecordSets objects from it. However,
I
can create Static RecordSet objects. A work around that I have found is to
have the 2nd DLL open a new connection object.
Code samples f
Hello All,
I seem to be running into a very strange problem.
In the mySQL command line interface I issue SELECT COUNT (*) FROM
test; and get --> ERROR 1064: You have an error in your SQL syntax
near '(*) from test' at line 1.
Below is the test table:
CREATE TABLE test
(
ID INTEGER AUTO_INCR
Adam,
Friday, September 27, 2002, 8:03:14 AM, you wrote:
AE> I am indeed in a very strange situation, to me at least. We've got a
AE> good-sized database (about 60gb) over 4k tables. We average about 300
AE> queries per second. We've recently noticed some strange behavior at around
AE> 430 con
Hi,
openssl for Windows is available at:
http://gnuwin32.sourceforge.net/packages/openssl.htm
How to I now setup the MySQL-server that I can connect using SSL with
mysql_real_connect(., CLIENT_SSL);
Regards
Bernhard
-
Bef
Cyril,
Thursday, September 26, 2002, 11:30:39 PM, you wrote:
CZ> ---cut---
mysql> DROP TABLE IF EXISTS COUNTRIES;
CZ> Query OK, 0 rows affected (0.02 sec)
mysql> CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
CZ> -> PRIMARY KEY (Name) );
CZ> Query OK, 0 rows affected (0.00
Darren,
Friday, September 27, 2002, 2:41:26 AM, you wrote:
DH> After installing MySQL-3.23.52-1.i386.rpm the following is displayed:
DH> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
DH> This is done with:
DH> /usr/bin/mysqladmin -u root password 'new-password'
DH> /usr/bin/mysqla
A short summary about what the Webpage from www.openoffice.org says:
You definitly can use OpenOffice as MySQL-Frontend.
They are connected via ODBC or JDBC.
Openoffice prefers MySQL 4 because of the advanced features
When MySQL gets out of alpha-state, there might be a more native connection
the
Paco wrote:
> I'm having probles with the c++ api of mysql... could somebody help me
> plesae?
Could be, maybe you should post your specific problem.
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
I'm having probles with the c++ api of mysql... could somebody help me
plesae?
--
--Paco
"Open Source, Open Mind"
"Slackware, sending kiddies to /dev/null, since 1993"
-
Before posting, please check:
http://www.mysql.co
I tried to import an .sql file from MySQL table (str+data) to interbase
and I encountered many errors . Is there any utility to convert this .sql
from MySQL to .sql suitable to feed SQL servers like interbase ecc?
(these errors are : no quots to field names, no 'binary' , no int(3) but int
n
How can I use such a statement with MySQL:
rsAuthors.Open sShape, "Provider=MSDataShape;Data
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Data
Shaping.mdb", adOpenStatic, adLockReadOnly
Thanks
Emery
-
Be
hi iikka
pal im really gratefull ... n egor to u too ...
now i CAN get into mysql thru
mysql -u root
so root s workin n one of my other two users too
i ve made 2 databases ... n they r connected 2
but ... its rather weired
1 with password n the other without
i gave them both
1 - 100 of 112 matches
Mail list logo
