>
>http://www.mysql.com/doc/C/r/Creating_tables.html
>
>Look over
>
>http://www.mysql.com/doc/index.html
Also have a look at www.devshed.com for some tutorials..
mysql, query
Bye,
B.
-
Before posting, please check:
http:
Hi Shu,
At 20:08 19/08/2001 -0700, Shu Xiao wrote:
>John,
>
>I got problem using this new release. When I opened the connection
>dialog, I typed in the host name, database name and user name * password.
>I specified a database other than mysql. But I always got the error saying
>"Access denied
On 19 Aug 2001 19:44:40 +0200, Greennet wrote:
> /usr/local/mysql-3.23.41/lib/libmysqlclient.a(my_compress.o): In function
> 'my_uncompress': my_compress.o(text+0x9a): undefined reference to
> 'uncompress'
>
> /usr/local/mysql-3.23.41/lib/libmysqlclient.a(my_compress.o): In function
> 'my_comp
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
Straight from
http://www.mysql.com/doc/C/r/Creating_tables.html
Look over
http://www.mysql.com/doc/index.html
Enjoy
M;)
-Original Message-
From: louie mira
John,
I got problem using this new release. When I opened the connection
dialog, I typed in the host name, database name and user name * password.
I specified a database other than mysql. But I always got the error saying
"Access denied for user 'xx' to database 'mysql'". I think mysql is
t
Is there a way to have MySQL label columns returned
from a select query with the complete column name, in
table.column format?
So if a column name is id, which is in the main table,
can MySQL return main.id instead of just id.
Sure I could alias each column, but if there is 30
columns, that's
i know this is easy for some of you guys,
im just starting making some tables and column..
and can't figure out how, ive read the manual and can't seem
to understand it yet fully.
just want to try this but can't seem to work..
i tried creating a table and a column..
like..
mysql> CREATE TABL
On Sun, Aug 19, 2001 at 07:44:40PM +0200, Greennet wrote:
> Greetings!
>
> I'm trying to install Apache 1.3.20 and MySql 3.23.41.
>
> During the make of Apache I get the following errors then make exits with
> Errors 1 and 2.
>
>
>
> /usr/local/mysql-3.23.41/lib/li
At 0:17 Uhr +0200 20.8.2001, David Tonhofer wrote:
>4) Make sure user 'fred' has an account on machine 'foo'. Unfortunately
>this must be an account with a shell :-(
You could probably write a pseudo-shell and put that into /etc/passwd (i.e.
#!/usr/bin/perl
while(){exit if /^exit$/m; print "T
Hi,
I notice a problem with Win32 MySQLGUI 1.7.5. When I get the
result for the query. I see the escape character \ was not removed
in the result table window. Anybody notice the same problem?
Thanks,
Shu
-
Before posting, p
>Description:
Text that may or may not be added to the MySQL manual
>How-To-Repeat:
>Fix:
Hello,
As there is a description about using an SSH tunnel with Windows
in the MySQL doc, I thought a text about using an SSH tunnel with
UNIX might be in order. If you think the text below might wa
The data wouldn't need to be stored for any longer than two to three months,
so that shouldn't be a problem...what about my query to get all members that
have not read the mailing, is that possible (assuming I don't use the
reverted logic you were talking about).
Daren Cotter
CEO, InboxDollars.
Hi
I'd like to know if it is possible to scp the database files to a
backup server while mysql is still running on both machines?
Alternatively, is there any replication mechanism to keep the backup
server up to date without shuting down mysql?
--
Best regards
Michael Großegesse
---
>I setup a slave on my database by placeing the correct lines in
/etc/my.cnf.
>
>I have since removed those lines and restarted the server but I still get
>this line error in my .err file.
>
>
>010819 14:31:13 Slave thread: error connecting to master:Access denied for
>user: '[EMAIL PROTECTED]'
MySQL version 3.23.39.
I'd like to distribute MySQL user administration by database using the
WITH GRANT OPTION feature. I gave user "joe" all privileges on his own
database with grant privilege.
joe can grant privileges on his own database to other users, but cannot assign
them passwords. Exa
Hi,
On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote:
> At the moment, what I am doing is:
>
> execute "LOCK TABLES foo READ"
> select info from foo
> //next lock implictly unlocks previous one
> //as it's done by the same thread/process
> //chances of conf
Hi !!
)-Original Message-
)From: qball cow [mailto:[EMAIL PROTECTED]]
)Sent: Sunday, August 19, 2001 10:50 AM
)To: [EMAIL PROTECTED]
)Subject: Fw: need help
)
)
)I have made a mysql server on my linux box. and via Myobdc I
)access it from a C++ programm I made.. I can see the records.. bu
Greetings!
I'm trying to install Apache 1.3.20 and MySql 3.23.41.
During the make of Apache I get the following errors then make exits with
Errors 1 and 2.
/usr/local/mysql-3.23.41/lib/libmysqlclient.a(my_compress.o): In function
'my_uncompress': my_compress.o(tex
I have made a mysql server on my linux box. and via Myobdc I access it from a C++
programm I made.. I can see the records.. but If I change one.. I get the error:
"No Cursor name availible"
I dont know whats wrong.. so I hope anybody can help me.
Thanks
ur friend,
Qb@ll
On Sun, Aug 19, 2001 at 10:52:00AM +0100, Mike Clemson wrote:
>
> gcc
> filename.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient
>
> and get the error:
>
> /usr/local/mysql/lib/libmysqlclient.a (my_compress.o): In function
> 'my_compress':
> my_compress.o (.text+0x9a): undefin
I solved the problem. Add a few more columns in the database table, one
column per higher level, and add a few more mysql query coding, tracing who
recruited who. Then everything becomes simple and fast mysql selects, and no
nested queries or subselects are necessary.
I have made a mysql server on my linux box. and via Myobdc I access it from a C++
programm I made.. I can see the records.. but If I change one.. I get the error:
"No Cursor name availible"
I dont know if it is in my program or some premission I set wrong in mysql.. If
anybody can help me
>Description:
When a field contains multiple lines (delimited by \n)
SELECT ... WHERE xxx like "%xxx%" is no longer case
insensitive.
>How-To-Repeat:
create table test (
text blob
);
insert into test values ("Hello\nWorld\nTest");
# This returns nothing
selec
Or just a string "Main2/Child2-1/Child2-2-1"...
Any ideas? Are they just rumours that this cannot be made with MySQL without
any accessories, PHP etc?
The problem I had with trying to implement this type of solution for a
threaded discussion app was in 'most recent' sorting. I want the Parent
Hi Daren,
How long do you need to store this information? The normalized table
that you describe is simple and easy to index. Having several million
rows in the table won't bother MySQL. So is it sufficient to keep the
data around for a month and then prune it out of the database? Long
term
Philip:
Look at your server's startup directives (/etc/my.cnf) and see if the
following line appears:
set-variable = lower_case_table_names=1
This variable forces the server to use lower case.
We grappled with this issue, and solved it by:
- Running an ALTER script to use lower case names f
Hi Jerry,
The load figure on a machine is the average number of processes needing
to use the CPU on the machine. Since all of the MySQL activity is in
threads under a single process, it only counts as one towards the load
average, so a load of 1.3-1.5 with a maxed out CPU is valid. (Yes, I
kno
On Sun, 19 Aug 2001, Sinisa Milivojevic wrote:
> If this is happening on Windows, we truly can not do anything about
> it.
>
> You could help there by forcing all table names to be lower-case by
> starting mysql service with a corresponding option.
No, it's happening on Linux. Here's a transcrip
I'm trying to create a mysql statment (in a php page) that says:
my header http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsu
Philip Mak writes:
> On Sun, 19 Aug 2001, Lars Bruun Hansen wrote:
>
> > mysql> show tables from test;
> > ++
> > | Tables_in_test |
> > ++
> > | MyTable|
> > ++
> >
> > mysql> alter table MyTable add (y char(1));
> > mysql> show tables from
Carsten H. Pedersen writes:
>
> ...
>
> > Having 27 indexes and using queries with LIKE "%...%" is a nice
> > recepee for slowness.
>
> Why should having 27 indexes slow down a SELECT?
>
> / Carsten
> --
> Carsten H. Pedersen
> keeper and maintainer of the bitbybit.dk MySQL FAQ
> http://www.b
Anyone,
I am recently new to mysql, although a have a few years experience in c
programming. I am attempting to build a simple 'connect to database' c-api
prog
on mandrake 7.2.
Using:
gcc
filename.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient
and get the error:
/usr/local
I don't know, I would have to check with my progammer on that one to be
sure... does this help
mysql -V
Ver 11.15 Distrib 3.23.40, for unknown-freebsdelf4.2 (i386)
[EMAIL PROTECTED] writes:
>Jerry,
>
>Thats a reasonably serious hardware platform, you should not encounter 30
>second delays, did
33 matches
Mail list logo
