Ok, here's the
scoop. After 3 days of research, noone has been able to give me an answer ...hopefully
someone here can..yay! Anyway, I've got several tables all with 350+ records.
The db itself has about 15 tables. When I run this query: "select field1
from table1;" it just sits there. When
I thought \. was a shorcut for "source". Yes?
This works:
mysql> source /var/lib/mysql/create.txt;
This does NOT work:
mysql> \. /var/lib/mysql/create.txt;
Is there some config setting that I've screwed up?
tia
-
Before pos
Dear [EMAIL PROTECTED],
This WILL CREATE MORE MILLIONAIRES in a SHORTER PERIOD
of Time than ANY MLM - PERIOD!!
Take it from Ed my upline - His an MLM LEGEND that walked Away from
a 1.5 + MILLION Downline in 200 Plus Countries in 19 Short Months
(World's Record) to join the NEXT Tidal Wave!!
Please forgive me if this is the wrong area to solicit this question,
but I'm gonna ask anyways:
Job offer:
Looking for a person in the Orlando, Florida area that would feel
comfortable converting data from Oracle into mysql and working with a
team of PHP programmers. Must have strong SQL backgr
Hi,
There are two ways to administer your hosted DB:
- You can telnet (if your provider offers telnet accounts) and execute command-line
instructions in mySQL. Obviously you will need some SQL skills and a look at the
manual will be required to get yourself acquainted with the system
- There i
Hello,
is there a way to limit the connection which the mysql user can do??
I have a server with 12 database users, and sometimes, one of the users
makes large number of connections because of a bulletin board he is using,
is there a way to limit the number of connections that he can do?
Regar
I know this is possible a silly question but my head is spinning now due to trying top
get my head round unix, perl and MySQL at the same time to get my database up and
working.
I am trying to put a search together but am stuck at the correct
where forenames like 'char%' and year = '1967'
Hello all,
I have a few databases running on a Win2k MySQL server right now, and I need
to transfer them to Linux. I have found that simply copying the files will
not do the trick, any ideas?
-John
-
Before posting, please ch
Hi.
Please check the manual, it list some good book recommendations:
http://www.mysql.com/doc/M/y/MySQL-Books.html
And there are also recommendations for SQL tutorials
http://www.mysql.com/doc/G/e/General-SQL.html
Bye,
Benjamin.
On Sat, Jan 13, 2001 at 03:43:02PM -0800, [EMAIL PROTEC
I am a new user to MySQL.
I am having a hard time understanding relational databases.
Can anyone recommended any resources which helps explain
relational databases?
-
Before posting, please check:
http://www.mysql.com/manua
Nick Gianakas wrote:
> Hi all,
>
> I just started learning mySQL yesterday. I'm using it for a web application
> (simple CGI stuff).
>
> To begin, I wrote a simple program that just initializes a mySQL connection
> and then closes it.
>
> Here's my problem:
> I'm getting compile errors when I li
Hi all,
Sorry if the list receives this twice--I posted before confirming my
subscription.
I just started learning mySQL yesterday. I'm using it for a web application
(simple CGI stuff).
To begin, I wrote a simple program that just initializes a mySQL connection
and then closes it.
Here's my p
Hi all,
I just started learning mySQL yesterday. I'm using it for a web application
(simple CGI stuff).
To begin, I wrote a simple program that just initializes a mySQL connection
and then closes it.
Here's my problem:
I'm getting compile errors when I link the libmysqlclient.a archive to my
p
>Hello,
>
>Is there a way to have a field of type DATE get the current date as its
>default?
No. Default values in MySQL must be constants.
>
>Something like ...
>
>mydatefield DATE DEFAULT curdate()
>
>...which does not work. But that's the idea.
--
Paul DuBois, [EMAIL PROTECTED]
---
David Hodgkinson wrote:
>
> marko milovanovic <[EMAIL PROTECTED]> writes:
> > how would it be possible to set a limitation in the size of the
> > databases at the creation time so that a user couldn-t build any
> > databases greater than, say, 20 MB?
> Smells like using quotas at the OS level t
Tõnu Samuel wrote:
>
> marko milovanovic wrote:
> >
> > uh! i already posted this message a while ago!
> > could anyone please help me?
> >
> > i could find some informations about increasing the size of the
> > databases, but not about limitations to their size.
> >
> > how would it be possible
Hello,
Is there a way to have a field of type DATE get the current date as its
default?
Something like ...
mydatefield DATE DEFAULT curdate()
...which does not work. But that's the idea.
Best,
Nick Didkovsky
-
Before
marko milovanovic wrote:
>
> uh! i already posted this message a while ago!
> could anyone please help me?
>
> i could find some informations about increasing the size of the
> databases, but not about limitations to their size.
>
> how would it be possible to set a limitation in the size of th
Marco Bizzarri wrote:
>
> Hi all.
>
> We're using mysql 3.22, on a Red Hat Linux 6.2 system. We're also
> accessing the data through MyODBC, from Windows. The mysqld is started
> with the skip-locking feature activated
>
> The problem is that we are experiencing index corruption when we access
lbraga wrote:
> Hi, my name is Lucio and i am with a
> problem in the definition of field
> type for a field that store IP address.
>
> I try varchar(15),varchar(32),
> char(15), bigint, but i don't have sucess.
> Can anyone help me?
> Thanks ... Lucio.
You should give us mysqlbug output, comm
"Ralf R. Kotowski" wrote:
>
> Ok I get a table is full error...
>
> So how/where do I set the tmp_table_size ? or the BIG_TABLES
> option so that its started that way at system start-up?
>
> from what I gather the Big_Tables option writes ALL tmp tables to
> disk, is that correct? so I should u
Robyn Renwick wrote:
> I use a MySQL database for the back end of our e-commerce site. We take
> credit as one method of payment and the last 8 digits of the card number
> are stored in the database. There is a web interface to the database from
> which I can get order information, but not the
How can I do Prepared Statements or Editable Cursors in MySQL? Using only
conact SQL strings is error prone...
I'm not getting any reply in the Java list...
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Hi, my name is Lucio and i am with a
problem in the definition of field
type for a field that store IP address.
I try varchar(15),varchar(32),
char(15), bigint, but i don't have sucess.
Can anyone help me?
Thanks ... Lucio.
__
marko milovanovic <[EMAIL PROTECTED]> writes:
> uh! i already posted this message a while ago!
> could anyone please help me?
>
> i could find some informations about increasing the size of the
> databases, but not about limitations to their size.
>
> how would it be possible to set a limitatio
Danny <[EMAIL PROTECTED]> wrote:
> There are mnay free RDBMS around besides MySQL
> This includes:
>
> Postgresql
> mSQL (mini SQL)
> Oracle 8i is free for Linux
I don't think the remark about Oracle being free for Linux is correct.
Certainly you can download it
uh! i already posted this message a while ago!
could anyone please help me?
i could find some informations about increasing the size of the
databases, but not about limitations to their size.
how would it be possible to set a limitation in the size of the
databases at the creation time so that a
Sir, try
GROUP BY test_name.name, build.name
Bob Hall
>I'm simplifying slightly, here's the basic tables:
>
>build
>---
>idxint
>name char(16)
>
>test_name
>
>idxint
>name char(64)
>
>main_table
>
>idxint unsigned
>test_name_idx medint
>status
Sir, SELECT statements aren't intended to work this way. Their
purpose is to link rows from different tables that match on one or
more columns. What you are trying to do is count unrelated rows that
happen to have same value in the View column. There's a way to do it,
but with 15 tables it inv
> Please help me with charset adding. I have some strange trouble.
> I use FreeBSD 4.2 STABLE and MySQL 3.23.28-gamma (compiled from FreeBSD
> ports) and PHP 4.04.
> As I understood Latin1 is a default charset. So, I wanted to add cp1251 or
> koi8_ru.
PHP4 has its own mysql client built in - it d
Sinisa Milivojevic a écrit :
>
> Joseph Bueno writes:
> > Hello,
> >
> > I posted message below a few hours ago.
> > Since then, I have tried to find how fast indexes become corrupt.
> > I have run a CHECK TABLE QUICK
> > on different tables in my database and run a
> > REPAIR TABLE whe
Hi,
I can make mysql well in simple configure after modifying widec.h following
the guide .
the steps I did were :
modify widec.h
./configure
make .
but if I added the option "--with-charset=big5" followed configure, I would
get a error msg when doing "make".
The steps I did were
./configu
I would like to know If there are webhosters that accept connections
to hosted MySQL databases
from other domains than localhost (via php) ?
I want to manage MySQL database directly from anywhere with home-made tools.
Thanks
--
--
Stéphane Pinel
39, Rue du Docte
William W. Chan writes:
>
>
> Hello all,
>
>I am trying to build a mysql 3.23.30 with bdb 3.1.17 on Win2000.
> I have put in the HAVE_BERKELEY_DB macro flag in sql\mysqld.mak
> directory and
> include db.h and libdb31d.lib into compilation flag. However, I still
> get error like t
Joseph Bueno writes:
> Hello,
>
> I posted message below a few hours ago.
> Since then, I have tried to find how fast indexes become corrupt.
> I have run a CHECK TABLE QUICK
> on different tables in my database and run a
> REPAIR TABLE when an error is reported followed
> by a CHECK T
"Apolinaras \"Apollo\" Sinkevicius" writes:
> I wonder, is there a performance gain if compression is turned on the
> client side?
> My set-up:
> Front end: M$Access97 via latest MyODBC
> Back end: MySQL 3.23.30 on RH7 with PIII300 128Ram
>
> LAN is 100BaseT Full Duplex switched.
>
> T
Thierry Coopman writes:
> Hi,
> I have a Sun R220 single CPU with 512MB RAM.
>
> I start mysql using
> $bindir/safe_mysqld \
> --datadir=$datadir --pid-file=$pid_file \
> -O wait_timeout=180 -O key_buffer=256M -O
> max_connections=250 -O table_cache=512 -O sort_buffer=
alex writes:
>
>
>
> By the way it seems to me that in 3.23.XX series mysql_init() returns address not
> of the starting point of the allocated memory pool but a point somewhere further
> (like to provide hidden data not included in "official" MYSQL structure). Hence
> when trying to use
Hi all.
We're using mysql 3.22, on a Red Hat Linux 6.2 system. We're also
accessing the data through MyODBC, from Windows. The mysqld is started
with the skip-locking feature activated
The problem is that we are experiencing index corruption when we access
both with the clients and with myODBC.
Hi there
I have MySQL 3.21.29a-gamma., PHP 3 and PHP 4 (both installed), Apache 1.3.9,
and win98
Of lately, When I run PHP files, the MSQL server shuts down with error 10038.
Sometimes I get a funny Windows Message Box titled 'DBUG' that has the text
'Test Signal'. Then Mysql crashes. Sometimes No
40 matches
Mail list logo
