Hey,
libmysqld is for a long time already part of the MySQL 4.x Source-Distribution.
Bernhard
- Original Message -
From: "Derick Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 19, 2003 11:35 PM
Subject: libmysqld.lib
> Hi!
>
> I want
You can see your max table size at the row "Max datafile length:
4294967294". This means that your UsedData table's max size is 4G. If
you want to change it you have to use alter table command with the
option max_rows. For example "ALTER TABLE UsedData MAX_ROWS = 100".
[EMAIL PROTECTED]
Dear sir
I am using mysql for my project.I am finding
problems of using FOREIGN KEY and STORED procedures in
version 4.0.please help me and send the details as
earlier as possible
by
Saravanan
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculat
On Thu, Feb 20, 2003 at 08:00:32AM +0100, Rafal Jank wrote:
> Is this a way to do it? I've just upgraded mysql to vesion 4.0.10 and found
> out that there are these new files on the slave. How can I rotate them?
They should automatically vanish. MySQL removes them when they're no
longer needed.
-
Is this a way to do it? I've just upgraded mysql to vesion 4.0.10 and found
out that there are these new files on the slave. How can I rotate them?
sql and so on...
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http:/
Hi,
I have installed the 4.0.10-gamma with support from the openssl v. 0.9.7
on the Debian Woody:
mysql>status
...
SSL:Cipher in use is DHE-RSA-AES256-SHA
...
mysql>show variables like '%openssl%';
+---+---+
| Variable_name | Value |
+---+---+
Hi
My host used mysql v3.23.28 and I use ASP for data access on my
genealogical database
I have created a fulltext index on 3 fields, surname,groomsurname and
bride surname
And I retrieve an exact name using the following:
SQL = "SELECT * FROM global WHERE MATCH (SURNAME, GROOMSURNAME,
BRIDESU
I'm need to create a database for the first time in 10 years and the wizard
aspect of Access 2002 doesn't work for me - it's too much "help" and slows
me down! I'm used to creating databases and reports almost from scratch with
dBase IV and Paradox, and easily learn software by reading manuals, so
If you are using Windows, a GUI client like SQLyog
would be of great help. It is free, and has neat
interface to display / manage relationships.
--- Jeff Epstein <[EMAIL PROTECTED]> wrote:
> Hello all.
>
> I've only been using MySQL for a few days, but I'm
> experienced with
> Oracle. So consi
Well, I thought I could figure it out but I guess I couldn't.
This is exactly what I want to do...
//Using Access now, but when I use MySQL, I can just get the last insert
id.
$itemID = $_POST['item_id'];
$itemQty = $_POST['item_qty'];
$itemPrice = $_POST['price'];
$orderID = Will be a value take
Hi,
I am not fimilar with jdbc. But as a general prinple, you should quote your
string expl. and it is nearly a must for all language to handle SQL query.
May be you should try str="'id'" instead of str="id". In some language, you
must use str = "\'id\'".
Please check jdbc docs.
Regards,
>
I and using mysql-jdbc to do some program.
I can insert record to my db by following code:
-
stmt.executeUpdate("insert into apidbusers values('id',
'jp','zhu','em1','jian180')");
---
but
if
>Yes. You can use INSERT INTO select from ..
>> If this matters, I will be doing this in 2 different applications. 1
>> database is MySQL, and the other is MS Access.
Not if the two tables are on different database servers. But maybe I'm
reading that wrong and the application is just being de
Dear Jeff,
There are many ways to lookup MySQL metadata. I was used to familiar with
them. Unluckily, I am 'spoiled' by phpMyAdmin recently.
I strongly recommend you to have a try with phpMyAdmin.
Regards,
> Hello all.
>
> I've only been using MySQL for a few days, but I'm experienced with
Yes. You can use INSERT INTO select from ..
Regards,
> All,
>
> Is this query possible to do:
>
> I am going to select an id from a table
>
> SELECT order_id FROM orders WHERE order_start = 1324
>
> I will then use the order_id from this query and insert it as well as
> some others valu
Hello all.
I've only been using MySQL for a few days, but I'm experienced with
Oracle. So consider this a sort-of-newbie question.
Is there any way to determine what foreign keys exist on a table? I
have tried "myisamchk", "describe", "show index", "show create table",
all to no avail.
Is th
Hi, this is my first post here, I hope it's easily answered
I've got Mandrake Linux 9, with the ext3 file system
What is the absolute maximum table size I can have?
And what do I need to change to achive that?
I've spent half the night googling, and couldn't find a real answer
so now I th
All,
Is this query possible to do:
I am going to select an id from a table
SELECT order_id FROM orders WHERE order_start = 1324
I will then use the order_id from this query and insert it as well as
some others values I have into another table.
So in summary, I want to perform a SELECT and IN
You should use LEFT JOIN.
Regards,
> I am perplexed trying to retrieve all the rows I need in the query
> I'm doing.
>
> I have a table with keeping track of people using ID numbers as the primary
> key and another table with coupon numbers and a reference to the
> first table. But not all th
Assume the ip address of your remote machine is 192.168.0.88
You should perform a
nslookup 192.168.0.88
on your LOCAL machine that hold the mysqld
If it cannot resolve into a symbolic name then you will get into trouble.
Add an entry to /etc/hosts or your DNS will solve the problem.
Regards,
Hi,
And fixed.
Sorry for the waste of time. Only 4 days before I was set to replace the
disk the database was on, and it is going bad. :(
-steve-
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php
Stefan and Gerald--
Thanks for the input. Here's how I solved it ... I used a textfile that
had worked for me the very first time I did such an exercise weeks ago.
This particular textfile came on a CD with the book I was using. And by
copying and pasting, so that all the spacing and line break
Jeff Mao <[EMAIL PROTECTED]> writes:
> Greetings all,
>
> Not sure if this is the right place to ask this,...I use the following
> script on an OS X server to backup my mysql databases:
>
> #!/bin/sh
> DATE=`/bin/date +%Y%m%d"_"%H%M%S`;
> cd /Users/usernmae/Documents;
> /usr/bin/mysqldump -hho
Hi,
Is there a mySQL field type that returns True or False after a
SQL Statement executed by MyODBC driver (ADO)?
Thank's a lot
Alisson
-
Before posting, please check:
http://www.mysql.com/m
I need to move the MySQL database from it's existing server to a newer server. Is
there anything I need to be aware of and can it be copied from it's present location
to the new server, with changes to config file?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty
Hi,
mysqlbinlog -j | mysql
works fine. I used -o instead of -j before. So I answered my last
question. When doing this:
mysqlbinlog -j | more
I see that it had advanced to the query after the one with the problem
in the trace file. In fact, the query succeeded and was there after a
REPAIR T
I have one master and two slaves all running 3.23.55-max on RedHat 7.3. I've
had replication up and running smoothly for several days. Today, I decided
to try out LOAD DATA INFILE on the master. After successfully loading on the
master, I checked both slaves and neither one had the new data. There
Rick,
I am able to restore from logs that had binary data (even though the
output looked real strange and messed up the terminal window). I did
have a problem once when I tried filtering data between mysqlbinlog and
mysql. Be careful if you do that.
What version of mysql are you using?
I have no
Hi!
I want to emebed libmysqld.lib into a DLL I am making for Visual Basic. I
need to make the DLL in C because it is going to perform other functions
(i.e I do not want to use the "Public Declare" in VB to access the DLL).
I need the libmysqld.lib library.
I could use LoadLibrary to load it d
Quick question: Are the binlog and relaylog files the same format?
Initial tests seem to indicate that they are the same. Can I use
mysqlbinlog -o | mysql
to get the slave more up to date (without having the slave SQL thread
running)? I tried the above but the from 'show slave
status' seemed w
Hi,
I want to be able to use the MySQL binary logs and mysqlbinlog to restore
data if needed.
This works fine, except when the log contains sql that is written when I
save a binary stream to a BLOB column in a table. I will get one of those
messages like 'there is an error in your SQL at ...'
Well then you are looking to do a left join.
SELECT table1.id, table2.coupon FROM table1 LEFT JOIN table2 ON
table1.id=table2.person_id;
In your example, the WHERE is not only a join condition, but also a
filter. It gives you exactly what you asked for, only those records
whose id's match. A le
Hi All
I just installed a RedHat Linux 8.0 box with
mysql-server-3.23.52-3
mysql-3.23.52-3
mysql-devel-3.23.52-3
Changed the password for root using mysqladmin
logged in using a mysql client (locally)
and
mysql> GRANT ALL ON *.* TO araheja@'%' IDENTIFIED BY 'amanraheja';
I DID THE SAME STEPS ON A
I am perplexed trying to retrieve all the rows I need in the query I'm
doing.
I have a table with keeping track of people using ID numbers as the primary
key and another table with coupon numbers and a reference to the first
table. But not all the second table is going to have correlating matches
Alejandro,
> I had a problem inserting a date...which format do I need to use?...I'm
> using -mm-dd, but when I throw a query, the records display -00-00.
You can insert a date as a string or as a number. Examples:
20030219 --> today, as a number
'2003-02-19' --&
Nikola,
> When I start my mysqld deamon, I get this message: "Can't initialize InnoDB
> as 'innodb_data_file_path' is not set". I've been reading through Reference
> Manual and I realise that I have to configure my.cnf file if I want to use
> InnoDB, and the problem would dissapear, but the proble
Richard,
set-variable = max_allowed_packet=16M
> Yikes!!! I knew that running "default configuration" gave you SOME
> values, but I didn't know they were so small. I've placed the
> my-medium.cnf as "my.cnf" in /etc on the Sparc 20, and also in C:\ on
> the W2K machine. Database access is m
I have the same db on master and slave and I want to use
replicate-rewrite-db to change the replicating name of this db on the
slave.
Slave my.cnf:
---
[mysqld]
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
master-host=master.company.com
master-user=repl
master-pass
How do you determine whether or not it is faster/more efficient to run a
complicated query or to run multiple simple queries and join / manipulate
the results with PHP?
sql
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-
Greetings:
If you're responsible for developing or maintaining data-driven Web
sites powered by MySQL, you may be interested in the recent release
of the Lasso Resource Guide. This free guide contains a listing of
various resources that aid building and serving data-driven Web
sites. And of co
Multiple table update is only supported from 4.04 or above. If you are using
3.x, I think you should put the result into another table, delete MSI_List
and rename the table to MSI_List.
I would also very interested to know whether there exist a more elegant
solution for 3.x.
Best regards,
> s
I *really* don't want to have a pair of indexes on 60-character varchars
that cover forty million records. That would increase the size of each
index from 280MB to 4.8GB. Just for the indexes. I don't think so.
Also, I don't see how it would address the issue of updates. The
problem is that f
>Description:
>How-To-Repeat:
>Fix:
'bool' type and configure CXXFLAGS errors
Setup:
% uname -a
SunOS hurricane 5.6 Generic_105181-29 sun4u sparc SUNW,Ultra-60
% gcc --version
2.95.3
% setenv CFLAGS -O3
% setenv CXX gcc
% setenv CC gcc
% setenv CXXFLAGS "-O3 -felide-constructors -fno-exceptions
Hello,
I am running MySQL version 3.23.39 on a Mac running OS X 10.2.4
This query works without error:
Drop table if exists temp;
create temporary table temp select @canread := "false", @canread := if(Institution_Id
= "8","true","false"), @canread AS canread from persons;
select * from temp;
Hello,
I'm a newbie with MySQL, so it's possible my qustions are answered
somewhere, but I haven't found those answers yet...
When I start my mysqld deamon, I get this message: "Can't initialize InnoDB
as 'innodb_data_file_path' is not set". I've been reading through Reference
Manual and I realis
sql
I have a zip code db named "MSI_Zipcodes that contains
city
state
zipcode (index)
I also have a db named "MSI_List" that contains
ID (index)
email
city(empty)
state(empty)
zip
My problem is:
How can i bring the proper info from "MSI_Zipcodes"(city and state)
and enter it (city and state)
Thank you KH
I think that statistics information might
become important part of our system, so it is safer to
buy license or have a look on others RDBMS.
> As far as I know, if you only require MySQL as an
> option or just an added
> features, your company do not need to purchase a
> license.
>
I had a problem inserting a date...which format do I need to use?...I'm
using -mm-dd, but when I throw a query, the records display -00-00.
Thx in advance
-
Before posting, please check:
http://www.mysql.com/manual.ph
Hi,
On Wed, 2003-02-19 at 15:56, Michael Katzmann wrote:
> I have a database with tables representing data from various years
> 1997, 1998, 1999, 2000 etc. In the tables I have data representing
> widget sales, zip codes, types of widgets, for example.
> Not all widget types were sold in every yea
At 11:13 -0600 2/19/03, Paul DuBois wrote:
At 10:57 -0600 2/19/03, William R. Mattil wrote:
Hello,
I am having some cockpit trouble with the following
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char
*wild);
and it is like lack of understanding on my part. Syntax is:
i
thanks a lot, I managed it now.
was just a little misconfigured my.cnf-file
> -Ursprüngliche Nachricht-
> Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 19. Februar 2003 14:34
> An: [EMAIL PROTECTED]
> Betreff: re: InnoDB
>
>
> On Wednesday 19 February 2003 13
You could just ftp them wherever you want for storage.
I made a simple script where I took the provided "mysqlhotcopy" script,
added it and used it every day as a cron to make a copy of all my databases,
then run through a check of each one then tar them all up and ftp them to a
remote server.
It
Sefan,
Stefan Hinz wrote:
Richard,
H. On the solaris machines (both), there is currently NO "my.cnf"
file anywhere, yet MySQL has been working "just fine". I imagine default
values are being used for everything. I'll have to select one of the
.cnf files from "support-files". I'll let y
At 10:57 -0600 2/19/03, William R. Mattil wrote:
Hello,
I am having some cockpit trouble with the following
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char
*wild);
and it is like lack of understanding on my part. Syntax is:
if (mysql_list_fields( &mysql, "some table na
Richard,
> H. On the solaris machines (both), there is currently NO "my.cnf"
> file anywhere, yet MySQL has been working "just fine". I imagine default
> values are being used for everything. I'll have to select one of the
> .cnf files from "support-files". I'll let you know how it works.
>
If you have ssh installed on your target machine couldn't you do the
following?
mysqldump | scp @:.
KH Chiu wrote:
It will then be a networking problem. As far as I know, you may need a
networking file system like NFS or Samba. You should mount your remote
machine as a network drive. Then
As far as I know, if you only require MySQL as an option or just an added
features, your company do not need to purchase a license.
KH
> > Otherwise, you may ask whether MySQL is an option or
> > not. It means that if
> > your logs and related information can go to other
> > mean such as a text
Hello,
I am having some cockpit trouble with the following
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char
*wild);
and it is like lack of understanding on my part. Syntax is:
if (mysql_list_fields( &mysql, "some table name", "some field name"))
mysql_store_result and m
Hello,
Earlier I asked Mark about XA and Connector/J. He said that it was
dropped from the 3.0 releases because MySQL doesn't natively support XA,
but when it does he will add it back in. Mark suggested that I ask for
XA on these lists if I wish to expedite it in the pipeline.
I am raising the
Hi there,
this problem was asked in this list before and i thought i solved
it but i was wrong. Heres the description:
I am running mysql 3.23.54 on Debian Linux with 2.4.20 Final
System has 2 GB Ram.
I compiled from source.
Here are relevant passages from my.cnf
port= 3306
socket
> Otherwise, you may ask whether MySQL is an option or
> not. It means that if
> your logs and related information can go to other
> mean such as a text file
> then you are no need to buy license.
In theory we can find option for any db appliance,
let say, we can store data in regular files.
>
> Otherwise, you may ask whether MySQL is an option or
> not. It means that if
> your logs and related information can go to other
> mean such as a text file
> then you are no need to buy license.
In theory we can find option for any db appliance,
let say, we can store data in regular files.
>
I have a database with tables representing data from various years
1997, 1998, 1999, 2000 etc. In the tables I have data representing
widget sales, zip codes, types of widgets, for example.
Not all widget types were sold in every year, so there are entries
in some tables that dont occur in others.
Hi all.
In my application I use generators generated manually. I have a table named
_POID with contains the last generator used for the table .
With table type MYISAM I use the follow secuence to obtain the next
generator:
LOCK TABLE _POID;
SELECT instanceNo FROM _POID;
UPDATE _POID SET instan
Hi List,
I'm using 4.0.10-max-nt of mysql.
I update to this version from 4.0.5. With this version I have no trouble
with load data local infile.
But now if i try to use it from the mysql-Command-line tool i get
an errror 1148, This command is not allowed with this mysql version.
On my server th
Stefan,
H. On the solaris machines (both), there is currently NO "my.cnf"
file anywhere, yet MySQL has been working "just fine". I imagine default
values are being used for everything. I'll have to select one of the
.cnf files from "support-files". I'll let you know how it works.
-Richard
Hi!
What to choose - InterBase/FireBird or MySQL - depends on the tasks you are
going to solve with your SQL server. InterBase/FireBird is intended for
managing a quite large and complicate databases, where a lot of business
rules should be realized and stored in common database instead of being
r
Yeah, we are gettign a single row each time.
The file is
hocatID (auto-increm) primary key
Hocat (varchar - index)
description (varchar)
...plus many other numeric/varchar fields.
We are looking to display a single record on a page at one time with an
option for the user to step through the file
I have a database that I've worked hard to set up, and while
many of my queries are working well, I have a few that are
proving to be extremely slow, despite my best efforts to
properly index them. I'd be grateful for any advice on how to
speed these up, or an explanation of how there's no way to
You are right. "read previous" simply not exist. I think this is due to both
historical reason and 'client/server model'.
In fact, 'read next' is available by reading next row in a query. However,
the record cursor is one direction only and cannot be read back.
In my experience, I will store th
I thought this was PHP
Andrew
>-Original Message-
>From: Bernhard Döbler [mailto:[EMAIL PROTECTED]]
>Sent: 19 February 2003 14:53
>To: [EMAIL PROTECTED]
>Subject: Hash-Functions
>
>
>Hi,
>
> there's a Password()-Function in MySQL. Can somebody tell my on what
>standard is based (MD5 etc.)
Bernhard Döbler wrote:
there's a Password()-Function in MySQL. Can somebody tell my on what standard is based (MD5 etc.) and if there's something similar in a DBMS that also supports triggers? InterBase does not support many functions...
Its deprecated; use MD5() or SHA1() ...
--
Michael T.
Use and id column, like an auto increment one and use that in the html you
are writing out +1 or -1 to get the next.
i.e.
"select id, X, X, X from table where id=1"
returns 1, value of X, value of X, value of X etc etc etc
then in the html use the id .
id+1
Next
need some error checking for le
Mark,
I read in the release notes that there is an implementation of XADataSource
(MySQLXADataSource), which does exist in the 2.0.14 release. I've looked in
the 3.x releases and do not see it. Am I just not seeing it? Is this also
planned for the 3.x releases?
Thanks,
Frank
---
Hi,
there's a Password()-Function in MySQL. Can somebody tell my on what standard is
based (MD5 etc.) and if there's something similar in a DBMS that also supports
triggers? InterBase does not support many functions...
Thanks
Bernhard
--
Hi,
Newbie here so please bear with me.
I am running MySQL 3.23.22 with PHP4.01 on WinNT client / Linux host,
everything is working okay and I'm just getting to grips with some basic
database handling.
Although I can use mysql_query to get a list of records using "Select * from
`mydata`" - for wha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Duncan Maitland wrote:
Hello,
I just tried compiling and using MySQL-4.0.11 (from the BitKeeper
repository) on RedHat 8.0, and this problem seems to have gone
away:
Unfortunately the problem is still occurring even after retrieving the
latest so
Looks to my like skuagent should be using the varchar fields instead of
the int fields.
Then you could just insert ignore each line from your test file.
Paul Chvostek wrote:
Hi all.
I need some help figuring out how to update a many-to-many relationship
from a text file.
For the fun of it, let
I am trying to install DBD-mysql-2.1025 on a RH8 machine. When I do a "make"
I get an error saying that it can't find libz.a or libz.so etc
I tried modifying the "perl Makefile.PL" using --libs= and the path to my
libz.so file.
As a fix, it did say that I could fix this by installing libz-dev
Greetings all,
Not sure if this is the right place to ask this,...I use the
following script on an OS X server to backup my mysql databases:
#!/bin/sh
DATE=`/bin/date +%Y%m%d"_"%H%M%S`;
cd /Users/usernmae/Documents;
/usr/bin/mysqldump -hhost -uusername -ppassword --all-databases >
full_dump_$D
On Wednesday 19 February 2003 12:51, Reto Baudenbacher wrote:
> newbie-question, sorry...
>
> is it possible to write this (working) query in a shorter form:
>
> SELECT * FROM $table WHERE (col1 LIKE '%$term%') OR (col2 LIKE '%$term%')
> OR (col3 LIKE '%$term%')
The short answer - yes, you can wr
On Wednesday 19 February 2003 13:21, Rusch (ext) Reiner wrote:
> I have one question about InnoDB-tables especial the filesize of all
> tables. In the past I took MyISAM but found out, some things in InnoDB make
> the system more stable.
> But I want to get more free space. In MyISAM the space gro
On Wednesday 19 February 2003 11:24, kk wrote:
> I just installed mysql4.x into the home/username directory of a remote
> machine. It is running good and I created a new user tester with all
> privileges.
> But how can i connect to the remote server running on a home directory
> using a front en
On Wednesday 19 February 2003 10:46, [EMAIL PROTECTED] wrote:
> I have problems with foreign key creation.
> I have installed mysql server cersion 3.23.53 on red hat linux 7.3.
> Then I have created innodb datebase to be able to use FOREIGN KEY
> Constarints.
> This is concerning piece of my my.cn
On Wednesday 19 February 2003 13:58, Prabu Subroto wrote:
> > I did something very stupid in my development. I
> > created a database with a couple of tables...but I
> > forgot to defining the foreign key and the primary
> > key
> > So if my user updated a record of one table than the
> > correspo
Jedi,
> "The behavior of the auto-increment mechanism is not defined if a user gives
> a negative value to the column or if the value becomes bigger than the
> maximum integer that can be stored in the specified integer type."
> Does it mean that MySQL databases will definitely stop working at
Thank you very much. That information is very helpful as I am just starting
to use/learn MySQL.
Raju Ganapathiraju
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
CC: "Ayyaparaju Ganapathiraju" <[EMAIL PROTECTED]>
Subject: Re: How to create a schema
Date: Wed, 19 Feb 2003 13
Thank you my friend..
--- Jerry <[EMAIL PROTECTED]> wrote:
> http://www.mysql.com/doc/en/ALTER_TABLE.html
>
> - Original Message -
> From: "Prabu Subroto" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, February 19, 2003 11:58 AM
> Subject: MySQL
>
>
> >
> > --- [EMAIL P
Prabu,
>> Is it possible to define Foreign Key and Primary Key
>> of my database after the tables have been created ?
>> If yes, how?
Yes. Use the ALTER TABLE command for this. Here's how it works generally:
ALTER TABLE yourtablename
ADD [CONSTRAINT symbol] FOREIGN KEY (...) REFERENCES anotherta
http://www.mysql.com/doc/en/ALTER_TABLE.html
- Original Message -
From: "Prabu Subroto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 19, 2003 11:58 AM
Subject: MySQL
>
> --- [EMAIL PROTECTED] wrote:
> > Your message cannot be posted because it appears to
> > be e
* Ayyaparaju Ganapathiraju
> 1). Is there an equivalent to creating a schema in MySQL. I would like to
> create tables in multiple schemas within the same database. Some of the
> tables will have foregign keys across schemas.
No, there is no consept of 'schema' in mysql, other than the implicit
's
MySQL
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
--- [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,queries,smallint
>
> If you just reply to this message, and
Hi!
Is it a bug?
C:\mysql>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29 to server version: 3.23.55-max-nt
mysql> create database R;
Query OK, 1 row affected (0.06 sec)
mysql> grant all privileges on `R%`.* to b;
Query OK, 0 rows affected
We try to evaluate MySQL on Linux for IBM S390 but
the binary distribution fails with a cannont execute in my_print_defaults
and the source distribution errror is below:
>How-To-Repeat:
make reports the folling:
../innobase/row/librow.a(row0sel.o): In function
`row_search_for_mysq
Hi,
I have one question about InnoDB-tables especial the filesize of all tables.
In the past I took MyISAM but found out, some things in InnoDB make the
system more stable.
But I want to get more free space. In MyISAM the space grows automatically,
but not in InnoDB by default.
In my /etc/my.cnf
newbie-question, sorry...
is it possible to write this (working) query in a shorter form:
SELECT * FROM $table WHERE (col1 LIKE '%$term%') OR (col2 LIKE '%$term%') OR
(col3 LIKE '%$term%')
thanks for your help!
Reto Baudenbacher
-
Hello.
I'm using replication both master and slave are MySQL 4.0.10.
But, When I insert many record( ten thousands of record) at a once,
I got follow error message.
###
030219 18:03:20 Error reading packet from server: binlog truncated in the
middle of event (server_errno=1236)
030219 18:03:20
Using the hostname or IP adders of the machine it is on.
(B
(BJerry
(B
(B- Original Message -
(BFrom: "kk" <[EMAIL PROTECTED]>
(BTo: "list mysql" <[EMAIL PROTECTED]>
(BSent: Wednesday, February 19, 2003 9:24 AM
(BSubject: Connecting to remote server
(B
(B
(B> Hello folks
(B> I
This one is still biting us.. any suggestions on where to troubleshoot
would be appreciated.
Mac OS X Server, 10.2.1 - MySQL 3.23.51
Heavy usage, but no more than 50 open connections at a time
Occasionally, MySQL just quits serving databases. The first indication
is a forum or something comes
1 - 100 of 113 matches
Mail list logo
