Hi,
can you count the number of characters in a field with MySQL?
The length(str) function seemed like a choice tool but can it be used to
get the length of data in a field or is there some other way?
Jari Mäkelä
-
Before po
Dear all,
I've been trying benchmark MySQL, SQL Server 7, and M$ Access 97.
But, SQL Server 7 and M$ Access is won when connected and opening
recordset using ADO, Even i'm using MyODBC with TCP/IP connections.
If i'm use cursorlocation=serverside with adOpenDynamic, and adLockOptimistic,
still M
Mysql placed the libmysqlclient.so.10 in /usr/local/lib/mysql
and thus out of my search path. A quick and dirty fix was to
create a symlink from /usr/local/lib
Ovanes
On Sun, 18 Nov 2001, Dan Nelson wrote:
> In the last episode (Nov 18), Ovanes Manucharyan said:
> > Thanks, I tried it again and
Hi,
> -Original Message-
> From: berndt [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 18, 2001 8:49 PM
> To: [EMAIL PROTECTED]
> Subject: mysql+myodbc+coldfusion
>
>
> Hi
>
> I am currently trying to get coldfusion, mysql, and myodbc to live happily
> together on a windows 2000 m
In the last episode (Nov 18), Ovanes Manucharyan said:
> Thanks, I tried it again and it worked. (at least it seemst to have
> created some seemingly working binaries.) (I had tried 5 times to no
> avail before I sent a message to the list.. so go figger.)
>
> Now to my real problem. I'm trying
On Thu, Nov 08, 2001 at 03:26:55PM +1300, Quentin Bennett wrote:
> Excuse the poor formatting
Please use '\G' next time.
> Any comments on the 'Time' column for Connection 115 anyone?
It's a bit insane.
> The queries are running fine, just wondered why the value is screwed.
> 3.23.40 Solaris
Hi
I am currently trying to get coldfusion, mysql, and myodbc to live happily
together on a windows 2000 machine. However i keep getting a
"[TCX][Myodbc]Transactions are not enabled" error. In the setup for the
system dsn I have NOT disabled transactions. So whats up? any help would
be really a
Thanks, I tried it again and it worked. (at least it seemst to have
created some seemingly working binaries.) (I had tried 5 times to no
avail before I sent a message to the list.. so go figger.)
Now to my real problem. I'm trying to make udmsearch work
and it needs libmysqlclient.so.10. I tho
Hi Boris,
Try this:
Select ifnull(position1,0)+ifnull(position2,0) As slno, title from book
where ifnull(position1,0)+ifnull(position2,0) <= 200 order by slno
Anvar.
At 09:49 PM 17/11/2001 +0100, you wrote:
>hi fellow mysql users :)
>
>i'm programming a little application, and i do the follow
This is a followup to my previous messages indicating database slow down.
After noticing the queries start to slow down earlier i decided to try and
get some debug info. a show table status had one interesting thing.
| raw| InnoDB | Fixed | 169681 | 1030 |
174817280 |
In the last episode (Nov 18), Ovanes Manucharyan said:
> Hi,
>
> I have a problem compiling MySQL on FreeBSD 4.0-RELEASE.
>
> ./configure --with-libwrap --enable-shared
>
> gcc -DHAVE_CONFIG_H -I. -I../.././innobase/pars -I.. -I../.././innobase/pars/../
> include -I../.././innobase/pars/../../i
Hi,
I have a problem compiling MySQL on FreeBSD 4.0-RELEASE.
./configure --with-libwrap --enable-shared
and this is what I get.
{...}
gcc -DHAVE_CONFIG_H -I. -I../.././innobase/pars -I.. -I../.././innobase/pars/../
include -I../.././innobase/pars/../../include -I../../include-DDBUG_OFF
If you open a table using HANDLER,
e.g, HANDLER MYTABLE OPEN;
then during the course of your application truncate that table,
e.g, TRUNCATE TABLE MYTABLE;
then you get some really wierd behaviour (my wierd behaviour was the
application rolling on a free in a completely different part of t
hi everybody,
i have a simple problem, but somehow i couldn't solve it
i hope someone overthere can help me.
i have a select query as below:
select no,subject,ndate from cat1 where news like '%"+search+"%' limit
"+page_no+",5"
i also want to find out how many rows are there in the result set.
what
On Mon, Nov 19, 2001 at 03:19:41PM +1300, James Robertson - Composite Design wrote:
> Hello
>
> Is there a way to include table column names as headers using 'SELECT * INTO
> OUTFILE...'?
>
> Cheers
> James A Robertson
No. SELECT selects data from the table. The column names are not table
dat
Hello
Is there a way to include table column names as headers using 'SELECT * INTO
OUTFILE...'?
Cheers
James A Robertson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
The current Reference Manual does not explain certain types of JOIN.
Specifically:
table_reference [CROSS] JOIN table_reference
is nowhere explained.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [The Script safe_mysqld terminates with an errcode: 13]
>Description:
Todd,
The "arrow" is like the PS2 prompt from your shell in Unix. That is,
the first line of your command says
Mysql>
and every line thereafter is just a "greater-than". This is because
the mysql client is waiting for more commands. You can enter more than
one command at a time this way, and
Hi,
I just installed MYSQL verion 3.23.44-max version. I verified the default
database tables under tool WinMySQLAdmin and I could see all tables and
fields of default databases.
As per security advice, I removed the default user with command
"DELETE FROM USER WHERE HOST="localhost" an
mysql> create database colors;
Query OK, 1 row affected (0.01 sec)
mysql> use colors
Database changed
mysql> CREATE TABLE Colors(
->
-> cid INT UNSIGNED NOT NULL,
-> data VARCHAR(10) NOT NULL
-> );
Query OK, 0 rows affected (0.06 sec)
mysql> insert into C
Hi Bennett,
- Original Message -
From: "Bennett Haselton" <[EMAIL PROTECTED]>
> In a database that enforced referential integrity, if you say that a field
> in one table is a foreign key referencing another table, then any value in
> the foreign key field in the first table must referenc
Hi Bennett,
- Original Message -
From: "Bennett Haselton" <[EMAIL PROTECTED]>
> Just wondering if anyone who knew the answer to this might have missed it
> before -- sorry to keep nagging but I really need to find out how, or
> whether, you can determine which fields in a table are fore
Hi Michael,
- Original Message -
From: "Michael A. Peters" <[EMAIL PROTECTED]>
> I'm looking for the pdf and the html-split manuals for MySQL-3.23.44
> The one page manual is included in the source distribution, but all I can
> find on the website for split and pdf versions are for MySQL
Richard Clarke wrote:
>
> I thought truncates were supposed to be really fast. I don't really notice
> any difference in speed between a truncate query and a delete query. What is
> actually involved in a truncate. The docs says its faster because a drop and
> recreate occurs but how is this actu
I thought truncates were supposed to be really fast. I don't really notice
any difference in speed between a truncate query and a delete query. What is
actually involved in a truncate. The docs says its faster because a drop and
recreate occurs but how is this actually faster.
Ric
-
hello
I'm running a server mysql 3.23.44 on a debian potato
I start my server with :
mysqld -u mysql
mysqld: ready for connections
I configure my pass for root.
when I connect to it with mysql -p it works but
mysql -h p204.mde.emn.fr -p
Enter password:
ERROR 2013: Lost connection to MySQL s
When will MySql support the UPDATE statement with more then one table.
E.g. UPDATE table1, table2 SET table1.col1=table2.col1 WHERE ...
Or ist there a work around?
Many regards,
Michael
-
Before posting, please check:
http
I'm looking for the pdf and the html-split manuals for MySQL-3.23.44
The one page manual is included in the source distribution, but all I can
find on the website for split and pdf versions are for MySQL-4.0 alpha,
which I'm not ready to run yet (not that I don't trust them, just that
3.23 stable
I need to setup a system for advisory locking within mysql. (Local client
locking is not sufficient as clients are on multiple machines).
The documentation mentions the GET_LOCK call which sounds perfect, except
that the previous lock is released when GET_LOCK is called again (i.e, a
thread can
Hi,
I found that if I set it as user1@localhost, other
than @"%", it worked.
Anyone knows how to create users who can access MySql
from anywhere under windows OS?
Thanks!
--- wei song <[EMAIL PROTECTED]> wrote:
> Hi,
>
> It still failed. But if I tried to use GRANT to
> create
> a new user w
Hi,
> -Original Message-
> From: Prasad Valmeti [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 18, 2001 12:42 AM
> To: [EMAIL PROTECTED]; Nguyen Trong Phuc; [EMAIL PROTECTED]
> Subject: RE: java.sql.SQLException: Cannot connect to MySQL server
> onlocalhost:3306.
>
>
> Hi Venu,
>
Have you tried checking the permissions on the .frm files?
--Russell
- Original Message -
From: "Barbara Ferrell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 18, 2001 9:08 AM
Subject: "read only" message
> i am using linux redhat 7.2. on my home computer.. i am
BH> After converting the data in my project from text files to MySQL
BH> tables, things are certainly working more smoothly than they were
BH> before, but since I use objects (in Perl, which barely supports
BH> objects, but that's another story) I have to write a lot of annoyingly
BH> repetitive
On Monday 19 November 2001 01:25, Todd Williamsen wrote:
> I looked all through the documentation for this and I cannot find the
> command for listing tables in mysql in telnet.
>
> I get this:
> Mysql> show tables
> ->
>
> I have no idea what the arrow does and what I am suppose to do with
> it
I am trying to display a hierarchically related list of folders via a
recursive SQL statement (each row in a table represents a folder).
What is needed is a select that will sort the folders and associate
the parent folder with their child, sub-folders. The kicker is that
the items in the fold
-> is a continuatin line for your sql stamement. Remember yo conclude your
statement with a semi=colon...
Denis
Todd Williamsen wrote:
> I looked all through the documentation for this and I cannot find the
> command for listing tables in mysql in telnet.
>
> I get this:
> Mysql> show tables
>
The message means that the databse files themselves have incorrect
permissions for the user mysql is running as.
ps -ef | grep mysql will show who mysqld is running as. Then check the
owership/permissions of the files to see if they are owned by that
user. I think you'll find they are not owne
I looked all through the documentation for this and I cannot find the
command for listing tables in mysql in telnet.
I get this:
Mysql> show tables
->
I have no idea what the arrow does and what I am suppose to do with it.
I type in commands and it just does another -> What is that?
Thank you,
Hi!
On Nov 18, johnlucas-Arluna wrote:
> Hi
>
> Having a few weird things with the FULL text Match, it's bringing back
> records where there is definitely no match but the score is above 1.
>
> Using the following SQL:
>
> SELECT tblText.ID, tblText.Title, MATCH (pagetext) AGAINST ('thornham
>
i am using linux redhat 7.2. on my home computer.. i am logged on as
root@localhost. i get a message that my table is "read only". i thought
the root user had all privileges and i cannot figure out how to give myself
the privilege to change and alter my database and tables after i just
created
Hi,
It still failed. But if I tried to use GRANT to create
a new user without password, then this new user can
access MySql;
Why? How can I fix it?
Please help! Thanks!
wei
--- Riccardi Moreno <[EMAIL PROTECTED]> wrote:
> Before login with new account you must reload server
> with this comman
Bill,
Actually, there *is* a digest -- send mail to
[EMAIL PROTECTED]
the information about this and all other listserver commands is in the
"welcome" message that you should have received as your first
mysql@lists email. I have been using the digest.
BUT... All of Bernie's comments are righ
(me looking down, ashamed...)
Of course Usual RH style. I know it and use it for many other
services, but for God knows which reason I just did not think about it
this time. Maybe because I only wanted to experiment, not use it as a
regular daemon to start at boot time every time..
Now it s
You should install MyODBC.
Peter
http://www.mysql.com
http://www.unixodbc.org
On Saturday 17 November 2001 23:34, Chaudhary, Prem Shankar wrote:
> Hi all,
>
> I want to connect through ODBC Driver Manager(libiodbc-3.0.5) to MySql
> Server.
>
> Can you tell me the MySql driver's Name & pat
Hi,
I've had the same problem, and after i remembered i used a symbolic link to
solve this problem.
Try this
cd /tmp
ln -s /var/lib/mysql mysql.sock
Then try again to start Mysql.
Regards
Tuffy
<--->
http://www.tuffy.dk
<--->
-Oprindelig meddelelse-
Fra: mweb [mailto:[EMAIL P
Hello Kurt!
Just to expand a little on the 'whys' of ryan's post...
On 17 Nov 2001 [EMAIL PROTECTED] wrote:
> I'm creating a table, and because i'm a fan of single-table databases,
> its turning out to have many colums. (It will have over 1100). Will
> this be possible? Will this cause proble
Hi
Having a few weird things with the FULL text Match, it's bringing back
records where there is definitely no match but the score is above 1.
Using the following SQL:
SELECT tblText.ID, tblText.Title, MATCH (pagetext) AGAINST ('thornham
manga') AS score FROM tblText WHERE MATCH (pagetext) AGAI
Hi Venu !
First, u should try use :
Connection con = DriverManager.getConnection(HOST + DB, ACCOUNT,
PASSWORD);
intead of Properties. I writer java servlet, so i placed mm.driver in lib
dir of each context, what's version of yr mm.driver, i'm using 2.0.4. u can
know what's port running by "n
Hello,
I have the following Mysql installed on a RH 7.1 PC:
mysql-server-3.23.36-1
mysql-3.23.36-1
mysql-devel-3.23.36-1
php-mysql-4.0.4pl1-9
mysqlclient9-3.23.22-4
unixODBC-mysql-2.0.7-1
If I try to start Mysql as root, as explained in:
http://www.mysql.com/doc/S/t/Starting_server.html
I get
Hi Venu,
Thanks for ur response.
Ur first guess is correct ... mysqld server is not running.
But whenever i tried to run it, it is showing this error:
08 13:59:01 Can't start server : Bind on unix socket: Address
already in use
08 13:59:01 Do you
At 10:16 AM 11/17/2001 -0700, Tom Bradford wrote:
>Bennett Haselton wrote:
> > Row sizes in MySQL tables can't exceed 65535 bytes (BLOB and,
> presumably,
> > TEXT fields are not counted towards this total). That means you can't
> > defined a table where the *possible* size of a row might be lar
52 matches
Mail list logo
