Hello ,all
I am developing an online store for a small or medium business. This is my
degree project and I hope to turn it into something larger. A question came
up. How can I organize this with MySQL/PHP/Apache for high availability? We
had thoughts about a mirrored database. But then, how
Just a noob question... (I suppose)
When I try just putting php code in my insert query, it goes like this:
insert into mytable values('?php echo some string; ?')
select * from mytable, returns:
?php echo some string; ?Some string
Any help would be greatly appreciated!
Just a noob question... (I suppose)
When I try just putting php code in my insert query, it goes like this:
insert into mytable values('?php echo some string; ?')
select * from mytable, returns:
?php echo some string; ?Some string
Any help would be greatly appreciated!
I think if you
Description:
source compiling with configure option --with-libwrap, will cause
make fail about:
mysqld.cc:2395: at this point in file
/usr/include/tcpd.h:73: too many arguments to function `int
hosts_access ()'
mysqld.cc:2396: at this point in file
/usr/include/tcpd.h:128: too
At 21:22 11/04/02 -0500, John D Armstrong wrote:
Hi!
On my computer both old 'stable' releases and new alpha downloads of
MySQL report this error:
020411 21:21:31 Can't find messagefile
'c:\mysqin\share\english\errmsg.sys'
020411 21:21:31 Aborting
Although I have checked several times for the
Hi,
I would like to dump some tables, and also some fields of a given table but
not all of them, from my database. I understand that mysqldump creates a dump
of the whole database and not a part of it. How can I do that ?
Do I have to use the BACK UP command or should I use the SELECT INTO
Jesper,
Saturday, April 06, 2002, 2:24:37 PM, you wrote:
JH I have a standard installation of Mysql on a red hat 7.1 box. I am confused
JH as to where I can disable the SKIP_LOCKING feature.
JH There is no skip_locking-option in /etc/my.cnf. I removed the string
JH --skip_locking from
balteo,
Monday, April 08, 2002, 7:53:01 PM, you wrote:
b Victoria,
b Thanks for replying. How does one know what parameter to pass on as
b position, in other words how do I know from what point to start the
b roll-forward from the binlog? What's more what format is this parameter?
b
I'm curious about how MySQL deals with time zones.
Our machines are located in the GMT time zone, and recently rolled over to
British Standard Time (local daylight savings time). The MySQL installation
has started returning NOW() values in local time, not GMT.
Is this the way the database is
Hi all,
I recently upgraded to Perl 5.6.1 and ever since I keep getting these errors
in my log files on my Linux machine every time the pages that get the data
from mysql are accessed:
Argument O_RDONLY isn't numeric in subroutine entry at
/usr/local/lib/perl5/5.6.1/i686-linux/DB_File.pm line
Raphael,
Friday, April 12, 2002, 12:02:16 PM, you wrote:
RDC I would like to dump some tables, and also some fields of a given table but
RDC not all of them, from my database. I understand that mysqldump creates a dump
RDC of the whole database and not a part of it. How can I do that ?
RDC Do
Zengfa,
Thursday, April 11, 2002, 7:49:36 PM, you wrote:
ZG I am looking for MySQL package on HPUX, REDHAT and
ZG Windows. Can anyone tell me where I should look for
ZG standard package for MySQL?
ZG For HPUX, I found one at:
ZG
Hello,
in my work we updated mysql from 3.22.23 to 3.23.49. But there are
some problems:
mysql describe uzivatele;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
Jeffrey Flowers wrote:
What I would like to hear is how other people are putting MySQL to work in
their home environment.
Like you said yourself the most obvious application is cataloging music
CD's.
What I'm doing is using it to keep a track of magazine cover disks. I got
really
annoyed with
Hi all,
I seem to have difficulties efficiently using multiple column unique
indexes. I notice major performance differences in the following example.
Is this a known problem, or am I not doing the right thing?
The following scenario takes for me 0.76 seconds:
CREATE TABLE test(d_id INT,
Description:
A cron job runs a shell script (update_adrs) that gets lynx to download and
save a web page (adr.htm). It then runs a perl script (adr.pl) to parse the web page
into an import file (adr.txt). Finally it executes a mysql command to import that file
into a table called
Hi All,
SciBit is proud to announce the release of the first version of MyLook, the
personal/groupware information manager using any MySQL server as message store. This
release is also the launch of a new free open database structure standard for MySQL
for use as a message store.
MyLook is
OK, so I'm not allowed to attach stuff (I'm new to this bug reporting
lark! Bear with me...)
So, scripts mentioned in previous email can be found at
http://www.biran.com/mysql/
--
Alec Harkness Systems
On Thu, 11 Apr 2002 20:10:15 -0400 (EDT)
Shivam K Shah [EMAIL PROTECTED] wrote:
Hi,
I'm using the mysqlclient_r library to access the database.
I have written some code as an interface to access the MYSQL databse and
have written the following test code to test the library.
I'm using Linux
Hi.
When I use mysqladmin process I see the SQL sentence that is executed at
that moment in the column Info.
But I only see one part of the sentence if it is big. How could I see the
complete SQL sentence being executed.
I need it for see the queries.
Iago.
Hi
I have a problem with this code. I want to compare the result of the
query that should return the count number of the records in
orderitemdetail. But its not working. What could be the problem?
Thx a lot
function AddItem($OrderID,$ProductID,$Qty)
{
$Datasource = new Datasource;
if
Hi there,
please check below
my table:
CREATE TABLE `news` (
`news_id` int(11) NOT NULL auto_increment,
`provider_id` int(11) NOT NULL default '0',
`provider_news_id` char(50) default NULL,
`category` char(50) NOT NULL default '',
`heading` char(50) NOT NULL default '',
Hi again
I'm getting this message now:
Supplied argument is not a valid MySQL result resource ..at the 4th line.
What could be the problem now?
Thx again
function AddItem($OrderID,$ProductID,$Qty)
{
$Datasource = new Datasource;
$result = mysql_query(Select Count(*) FROM orderitemdetail WHERE
Simon,
Monday, April 08, 2002, 7:05:34 PM, you wrote:
SG have got a backup script that locks the MySQL tables then use cp to copy
SG the tables.
SG It then tar, then zips them up.
SG So my queston is what is the minimum privileges that this MySQL back user
SG needs just to lock tables?
Since
chris,
Friday, April 12, 2002, 11:09:06 AM, you wrote:
ñ Description:
c source compiling with configure option --with-libwrap, will cause
c make fail about:
c mysqld.cc:2395: at this point in file
c /usr/include/tcpd.h:73: too many arguments to function `int
c hosts_access ()'
c
Richard,
Friday, April 05, 2002, 12:29:44 AM, you wrote:
RC Hi,
RC ---
RC In MySQL Version 3.23, in-memory temporary tables will automatically be
RC converted to a disk-based MyISAM table after the table size gets bigger than
RC tmp_table_size.
RC ---
RC It also says this though. I'm using
Michal,
Friday, April 12, 2002, 1:01:28 PM, you wrote:
MD in my work we updated mysql from 3.22.23 to 3.23.49. But there are
MD some problems:
MD mysql describe uzivatele;
MD +-+--+--+-+-++
MD | Field | Type
I install mysql-max 3.23.50 in my test box and start testing innodb
tables
I found two questionsfirst of all I used autoextend feature (it's really
great) but I cannot now add another file to the tablespace
The second question is if I am configuring something wrong, the same query
this means that the select-statement did not return a row.
try printing out the select-statement and execute it on the
command-line.
and add a if ($result) {... before using the result set.
and: try finding a php-list. :-)
-Original Message-
From: Alia Mikati [mailto:[EMAIL
I would like to second this notion if I may.
I was up until midnight (EST) last night trying to come up with the very same answers.
I found no answers from either the online mailing list searches nor from the O'Reilly
Mysql book... nor from the DBI book.
This also makes it difficult when porting
Scott
O.K. dumb question. A bigger string can't be contained in a smaller one.
But how can I make it so someone searching "dogs" can pull up an item that
contains dog?
My first instinct was to tell you to use perl and a dictionary of common
terms.
But I remembered there is the LIKE function
Hi to all of you guys,
I am new to the list and to Mysql. I have been observing the list for
about a week and I feel it is definitely the place to go to share
knowledge about MySQL (although right now I don't have any knowledge to
share in this matter, beeing new to Linux and MySQL).
My
Hi,
consider this select statement as an example:
SELECT d_person.dispname, d_title.title
FROM d_person, d_title, s_first, s_last, t_person, l_first, l_last
WHERE
t_person.dperson_id = d_person.dperson_id AND
t_person.dtitle_id = d_title.dtitle_id AND
l_first.fname_id =
Installed MySQL and about the first thing I tried to create was a stored
procedure - failed.
Found out fairly quickly with a text search in the manual that stored
procedures is not to be introduced until version 4.1.
Checked my own version and found it to be Ver 11.16 Distrib 3.23.49.
He,
Hello Everyone,
I've only just started trying to use MySQL so please forgive my
ignorance if this sounds like a really basic question!
I am trying to search a text field within a table that contains
several keywords; for example the column might be called
computer_description
Hello Everyone,
I've only just started trying to use MySQL so please forgive my
ignorance if this sounds like a really basic question!
I am trying to search a text field within a table that contains
several keywords; for example the column might be called
computer_description
Check this out. Sometimes I need to display dates to users.
DATE_FORMAT is neato way to process DATE columns into
more readable output (2002-03-12 for example, doesn't cut it
for me), but it prints out the date in English.
On a site that is presented in 5 different languages, this is
much less
I understand that at some point, a sql table that has been locked by
someone
will automatically be unlocked, but I'm a little unclear as to the
circumstances. Say at the beginning of a function I open a connection,
lock a table, and then close the connection. Then, perhaps a few lines
down in
[EMAIL PROTECTED] wrote:
I am trying to search a text field within a table that contains
several keywords; for example the column might be called
computer_description and contain the values i-mac blue 256MB
500MHz Is there any way of putting together a query that says
SELECT * FROM table1 WHERE computer_description LIKE '%blue%'
HTH
Greg
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 11:10 AM
To: [EMAIL PROTECTED]
Subject: is there a MySQL 'field contains' function
Hello Everyone,
Is there a fast way to update a column in one table with the column value
in another table? Here's the catch. I need to do this for up to 10,000 rows.
I would like to do this with one sql statement rather than writing a PHP
loop to do it.
I have 2 tables, Dept and Employee. I want to count the
A small SQL query problem concerning articles and article_comments :) You
experts will have no problem with this :)
In brief:
-
I have no problems displaying the title, date, author, summary of the
articles or anything. Its just doing an sql query that gets my 3 latest
articles AND
In the last episode (Apr 12), Iago Sineiro said:
Hi.
When I use mysqladmin process I see the SQL sentence that is executed at
that moment in the column Info.
mysqladmin -v process will display the entire commandline.
--
Dan Nelson
[EMAIL PROTECTED]
At 10:09 AM 4/12/2002, you wrote:
Hello Everyone,
I've only just started trying to use MySQL so please forgive my
ignorance if this sounds like a really basic question!
I am trying to search a text field within a table that contains
several keywords; for example the column
Description:
Access denied errores, for the replication user, are not reported in:
SHOW SLAVE STATUS;
They show all relevant information, and queries like:
CHANGE MASTER TO
report no error.
Subsequent LOAD TABLE % FROM MASTER queries, hang indefinetely.
Hello Fellow Mysql Users
Is Mysql Max Data Base Server even possible to do loadblancing
to spread its load between 2 or more machines. I'm having tough time getting
my mysql to work under heavy site load on Dual Cpu FreeBSD 4.5 machine
running Mysql max. Any insight would help me at this point.
I am using PHP to run the following command:
passthru(mysqldump -q -u$userName -p$password -h$hostName $databaseName);
The problem is that it puts EVERYTHING on one line and, of course, and
wraps it. I want to be able to dump the dump(schema) of a database onto a
web page so that they can
* Bill
Hello Everyone,
I've only just started trying to use MySQL so please forgive my
ignorance if this sounds like a really basic question!
I am trying to search a text field within a table that contains
several keywords; for example the column might be called
On Fri, 2002-04-12 at 10:56, Steve Buehler wrote:
I am using PHP to run the following command:
passthru(mysqldump -q -u$userName -p$password -h$hostName $databaseName);
The problem is that it puts EVERYTHING on one line and, of course, and
wraps it. I want to be able to dump the
* Torkil Johnsen
[...]
I have no problems displaying the title, date, author, summary of the
articles or anything. Its just doing an sql query that gets my 3 latest
articles AND counts how many comments each article has, and doing
it in ONE query instead of two separate ones... :(
[...]
One
There is plenty of space. In excess of 5 gigs.
Ric
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 2:02 PM
Subject: Re: Re: unkown table is full
Richard,
Friday, April 05, 2002, 12:29:44 AM, you wrote:
RC Hi,
RC
sql
Hello
I need a ENUM to default to a value when it gets a NULL.
Can this be done. Right now is I set the column to
FIELD ENUM('NO','YES') NOT NULL
It fails to insert when a NULL is entered.
I want it to default to NO
Can I set it to do this?
Ruben
--
Hiya,
I'm writing some code for a web site I'm working on at the moment, and I'm
wondering if I can simplify a task:
I've got a series of tables: items, books, video, data music (it's a
simply library web site).
Every book, dvd, etc has an entry in it's selected table, and a record for
If your database is read-only, you can use Linux Virtual Server to load
balance traffic to MySQL servers.
-RG
On Fri, 12 Apr 2002, Frankie Gravato wrote:
Date: Fri, 12 Apr 2002 10:54:56 -0400
From: Frankie Gravato [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Load Blancing Mysql Max Db
ENUM can handle your needs. you should be able to just change your syntax
to: FIELD ENUM('NO','YES') NULL
under that syntax your default value will be NULL.
this is from the documentation directly: If an ENUM is declared NULL, NULL
is also a legal value for the column, and the default value
On Fri, 2002-04-12 at 16:39, Steve Buehler wrote:
Not a bad Idea. I guess I will have to hit the php mailing list to find
out about this because I tried the following in PHP and it still did the
same thing.
?
require(../globals.inc);
$test=passthru(mysqldump -q -u$userName -p$password
ENUM can handle your needs. you should be able to just change your syntax
to: FIELD ENUM('NO','YES') NULL
under that syntax your default value will be NULL.
We need it to default to 'NO' not NULL
sql
Ruben
-
Before
Thanks for the suggestion! I modified your query to something that works for
me (I was inaccurate with the column names before, sorry... :)
SELECT a.article_id,a.title,a.date,a.summary,COUNT(c.id) as comments
FROM articles as a,article_comments as c
WHERE a.article_id = c.article_id
GROUP BY
Richard Clarke writes:
There is plenty of space. In excess of 5 gigs.
Ric
Hi!
The error message that you get is quite unlikely for temporary tables.
Which release of MySQL 3.23 have you used ??
If not recent, then try the latest and see if problem reccurs.
If this happens with last
Steve,
Thanks for help.
To unpack the test/benchmarks RPM files:
rpm -i MySQL-bench-3.23.49a.-1.i386-rpm
Error: failed dependences: MySQL-DBI-perl-bin is need by
MySQL-bench-3.23.49a-1.i386.
If I'm not wrong, I need DBI-perl-bin-0.93-1.i386.rpm as well? Do you know
where I can get the copy?
Hi,
I think I may have spotted a bug in connection with the LEFT JOIN statement.
The following SQL
select name, sum(repurchasedunits)
from t_fund left join t_boxdaily on t_fund.fundid = t_boxdaily.fundid
where t_fund.fundid = 'BB01'
group by name
produces the output as below:
name
[EMAIL PROTECTED] wrote:
Thanks for the suggestion! I modified your query to something that works for
me (I was inaccurate with the column names before, sorry... :)
SELECT a.article_id,a.title,a.date,a.summary,COUNT(c.id) as comments
FROM articles as a,article_comments as c
WHERE
* Torkil Johnsen
This works PERFECTLY
Except:
If an article has NO comments, it is not returned!
Use a LEFT JOIN:
SELECT a.title,a.date,a.author,a.summary,COUNT(c.id) as comments
FROM articles as a
LEFT JOIN article_comments as c ON
a.id = c.article_id
GROUP BY
sql
ENUM can handle your needs. you should be able to just change your syntax
to: FIELD ENUM('NO','YES') NULL
under that syntax your default value will be NULL.
I need it to default to 'NO' not NULL
-
Before
http://www.mysql.com/downloads/api-dbi.html
-Original Message-
From: Jane Tsai [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 9:12 AM
To: Steven Hajducko
Cc: [EMAIL PROTECTED]
Subject: Re: Access Denied
Steve,
Thanks for help.
To unpack the test/benchmarks RPM files:
rpm -i
Ruben,
If you leave it as NOT NULL it should default to NO. If an ENUM is
declared NOT NULL, the default value is the first element of the list of
allowed values.
SIDE QUESTION:
Are you doing something like: select * from table where enum_colum=NO
If you are running that type of query it
Is the date read the same with or without the dashes?
-Original Message-
From: Steve Briant [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 9:17 AM
To: [EMAIL PROTECTED]
Subject: BUG using left join.
Hi,
I think I may have spotted a bug in connection with the LEFT JOIN
Sorry, I guess I answered too quickly. You have a problem, if you have to
use a
literal SQL statement, and the various DBMS's use different escape syntax.
However, in Java, you can just use a prepared statement
String sql = INSERT INTO files (filepath) VALUES (?));
PreparedStatement
Is it possible to turn off Innodb in MySQL 4.0 via
the my.cnf file? Or command line params or
something?
I would like to be able to do this to since the
device that MySQL is running on does not have
the space available for the minimal 10Mb Innodb
file.
I realize I can probably do this be
You are passing a string to compare to a date. If you do this, pass it
in the string format.
Other wise and t_boxdaily.boxdate 19990101
Steve Briant wrote:
Hi,
I think I may have spotted a bug in connection with the LEFT JOIN statement.
The following SQL
select name,
I know this is more of an php question, but I think that some of the mysql
people that use PHP might want to know about this in case they need it
since it is for accessing a dump of a mysql database.
I found two ways of doing this:
1. (using the exec() method)
exec(mysqldump -q -u$userName
On Fri, 2002-04-12 at 11:47, Russell E Glaue wrote:
If your database is read-only, you can use Linux Virtual Server to load
balance traffic to MySQL servers.
-RG
LVS as you said it is only good for read-only. Are there any solutions
for non read-only load balancing, using replication
Yes this is good subject problem is the site
this is being used on had data being written to the db
so read only system really isn't going to help me.
wonder if mysql developers can shed some light on this subject.
- Original Message -
From: Jason Yates [EMAIL PROTECTED]
To: Russell E
Hi,
Not yet found anything to cover this on the online-docs so I'm aiming at
you :)
I need to sort the result afterwards e.g.:
SELECT name, date, importance FROM 'mytable' WHERE date'myTime' ORDER
BY date DESC, name LIMIT 0,20;
...then I need to sort *only* the result by the 'importance', can
When I send a NULL it's rejected as bad data, which sort of makes sense
On 2002.04.12 12:33 Steve Katen wrote:
Ruben,
If you leave it as NOT NULL it should default to NO. If an ENUM is
declared NOT NULL, the default value is the first element of the list of
allowed values.
The
Hello bugs,
min return not value from table.
mysql select min(ord) from cSectText where SectID=932;
+-+
| min(ord)|
+-+
| -20020412051744 |
+-+
1 row in set (0.00 sec)
mysql select ord from cSectText where SectID=932
Sorry about the mutli post of this, but I got some mail daemon errors, so
I'm sending again to make sure. The question is below.
Carl
-- Forwarded message --
Date: Fri, 12 Apr 2002 10:20:37 -0400
From: Carl Schmidt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Locking tables
Steve Katen wrote:
Ruben,
If you leave it as NOT NULL it should default to NO. If an ENUM is
declared NOT NULL, the default value is the first element of the list
of allowed values.
SIDE QUESTION:
Are you doing something like: select * from table where enum_colum=NO
If you are
skip-innodb
- Original Message -
From: Scott Olson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 1:46 PM
Subject: Turning off innodb
Is it possible to turn off Innodb in MySQL 4.0 via
the my.cnf file? Or command line params or
something?
I would like to be
In the last episode (Apr 12), Scott Olson said:
Is it possible to turn off Innodb in MySQL 4.0 via
the my.cnf file? Or command line params or
something?
Put the following line in your my.cnf:
skip-innodb
--
Dan Nelson
[EMAIL PROTECTED]
Ruben,
If you insert an invalid value into an ENUM (that is, a string not present
in the list of allowed values), the empty string is inserted instead as a
special error value.
it is inserting the value as the first value in the table which is the
error value or the index of 0.
i would
Yes have to turn it off in my.conf
-Original Message-
From: Scott Olson [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 12:47 PM
To: [EMAIL PROTECTED]
Subject: Turning off innodb
Is it possible to turn off Innodb in MySQL 4.0 via
the my.cnf file? Or command line params or
I think he is saying varchar with support for unicode (that's how it is
labeled in sqlserver).
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 1:07 AM
To: saraswathy saras
Cc: [EMAIL PROTECTED]
Subject: Re: nvarchar
On Thu, Apr 11, 2002
Instead of inserting NULL, leave the column out.
INSERT mytable (2nd_col_name) VALUES (NULL);
If you don't mention the enum column, it gets the default.
Michael
On Fri, 12 Apr 2002, Ruben I Safir wrote:
When I send a NULL it's rejected as bad data, which sort of makes sense
On
Thanks for the reply!
Do you mean like .. ORDER BY date DESC, name, importance LIMIT 0,20; ?
If so, I get the result ordered first by date, and if two dates are
equal then the importance takes in. However, I want to get the result
and then sort the result by importance e.g.:
result (date,
Hi everyone,
I am trying to find any project regarding the integration of GRID tools
(i.e. Globus) with MySQL.
For those who are not familiar with the GRID, what I basically want to do is
to manage a collection of MySQL DBs (we deal with large amount of data) over
a series of MySQL servers. I
On Fri, 12 Apr 2002, Steve Katen wrote:
Ruben,
If you leave it as NOT NULL it should default to NO. If an ENUM is
declared NOT NULL, the default value is the first element of the list of
allowed values.
SIDE QUESTION:
Are you doing something like: select * from table where
This is mysql 4.0.1-alpha.
Ric
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 5:08 PM
Subject: Re: Re: unkown table is full
Richard Clarke writes:
There is plenty of space. In excess of 5
Does the same scenario apply to MySQL database on a Linux server?
Yvon
Bill Easton wrote:
On the grounds that someone else may have this problem, and in response to
John's post, below, I am providing a cookbook of how to do what I asked.
The problem: I have a bunch of users, all with
Richard Clarke writes:
This is mysql 4.0.1-alpha.
Ric
Please submit to us a full repeatable test case at
[EMAIL PROTECTED]
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime
Checked my own version and found it to be Ver 11.16 Distrib 3.23.49.
He, version 11??? Quit confused, but after a sanity check with reality
I realized I must be using version 3.23. Anyhow, check the status of
next version and found out that version 4.0 is in alpha mode...
The Ver 11.16
On 12 Apr 2002, at 17:54, SED wrote:
However, I want to get the result
and then sort the result by importance e.g.:
result (date, name, impoartance):
20020102, John, 3;
20020101, Smith, 5;
20010101, Sigmund, 1;
2101, Sigmund, 8;
now I want to sort the result by importance
Rodrigo,
from the manual:
If the disk becomes full you may want to add another data file to another
disk, for example. Then you have to look the size of ibdata1, round the size
downward to the closest multiple of 1024 * 1024 bytes (= 1 MB), and specify
the rounded size of ibdata1 explicitly in
would there be any issues if
I am replicating an empty database, we have a development serer, I wish to
dump from it to the live server ( the empty database being replicated)
I want to msqldump database | mysql database
would that replicate fine on the slave?
Luc Foisy
mysql, query
Your example is not the same, it sends only one value
to a 2 value table. It definetely does not work if you send NULL
INSERT VALUES(NULL)
Ruben
On 2002.04.12 14:10 Michael Stassen wrote:
On Fri, 12 Apr 2002, Steve Katen wrote:
Ruben,
If you leave it as NOT NULL it should default
I'm relatively new to the construction of complex queries,
and I'm trying to figure one out that I'm sure is common;
I wasn't able to find anything especially helpful in the docs.
Suppose I have the canonical database of CDs, with one table,
which includes fields for title, cost, and
thanks a lot, it helps
Kathy
-Original Message-
From: Bill Easton [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 9:44 AM
To: [EMAIL PROTECTED]
Cc: Kathy Sung
Subject: RE: About escape character '\'
Sorry, I guess I answered too quickly. You have a problem, if you have
to
use
Ruben,
I think youare referring to my earlier message, but no matter.
You cannot insert NULL into a column you've defined as NOT NULL, with some
special exceptions (auto_increment and timestamp, for example).
As I said before, if you want a column to get its default value, you leave
it out of
You are right, I didnot see this section so well
BTW: I am really interested in InnoDB features, do you have an answer for
the second question about queries taking so long time?
Regards,
Rodrigo Gonzalez.
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL
Hello, verybody,
currently i got one question.
i create a table in mysql database to store questions
which have following column fields: questionnumber,
questionbody, answers and etc.
My problem is if i delete one row(question) how can i
update the questionnumber in the easiest way which
means
1 - 100 of 132 matches
Mail list logo