Hi,
I am about to start the planning process in moving my FileMaker/Lasso/PHP
site over to MySQL/PHP.
Before I get too far down the road, should I be using InnoDB or MyISAM
tables? The service is initially going to be hosted on WinNT but may move
over to Linux later.
My main database has about 2
Hi all,
I want to give the user of a client app
the possibility of aborting a query, that
was wrong or took too much time etc.
mySQL doc says the only way to do this,
is to kill the whole connection from another
thread (Win32).
When I do this, the killing thread crashes
before returning from mys
Hello
Can mysql have different tables for different users ? Say user 'TEST1'
creates a table called 'XYZ' and also user 'TEST2' creates the same table
name 'XYZ'
Is it allowed ? If it is, can this two tables can be accesed by a third user
say 'Superuser' provided the priveleges are given by 'TEST
Thank you Daniel,
You remided me that I once had a page with the following instead mysql_error()
and that gave me the verbosity that I needed to get things working. Looks like my
wife changed some fields in the database without thinking how they might affect the
script. Can't believe I didn't c
Why not change your error message display so it's more informative?
Instead of
die("Error in input query");
try this:
or die ("Error in input query: " . mysql_error() . "($query)");
That way, you can see exactly what MySQL says the error was, and exactly
how the query came out. It's really
On Tuesday 03 December 2002 12:21 am, daniel wrote:
> INSERT INTO (comment_lines)
> VALUES('02075030009219','09','20','35','N','','3','');
>
> maybe even that
>
> >= Original Message From daniel <[EMAIL PROTECTED]> =
> >INSERT INTO comment_lines VALUES('02075030009219','09','20'
INSERT INTO (comment_lines)
VALUES('02075030009219','09','20','35','N','','3','');
maybe even that
>= Original Message From daniel <[EMAIL PROTECTED]> =
>INSERT INTO comment_lines VALUES('02075030009219','09','20','35','N','
>','3','');
>
>try that u didnt seem to have quo
Error in input query
start of php database code *
$connection = mysql_connect("localhost", "hostbyk1_admin",
"") or
die("Invalid
server or user");
mysql_select_db("hostbyk1_order",$connection);
/ ***
Make sure you repla
INSERT INTO comment_lines VALUES('02075030009219','09','20','35','N','
','3','');
try that u didnt seem to have quortation around the 3
>= Original Message From Freedom Advocate <[EMAIL PROTECTED]> =
>This is the command I am having problems with and the error that I am
getti
this is a vague one , would be good to copy and paste the php debug message
>= Original Message From Jerry M. Howell II <[EMAIL PROTECTED]> =
>Hello all,
>
> We are leasing a dedicated server and seem to pe having problems getting
our
>php script working with mysql. The script was workin
Hello all,
We are leasing a dedicated server and seem to pe having problems getting our
php script working with mysql. The script was working fine with the last server
we were on so I'm wondering if you all have any sugestions. We are hosting on a
redhat 7.3 server with MySQL-3.23.53a-1.i386.rp
>From: <[EMAIL PROTECTED]>
>
>I'm writing to inform you that ATAF version 6.0 is released today, and is ready to be
>downloaded...
Since many folks on this list are using various UNIX versions, you should mention
prominently that this is a Windows-centric product -- a fact that is rather deeply
This is the command I am having problems with and the error that I am getting.
What follows is some things I did to troubleshoot this problem. I can't see
any problems with the SQL and as I note below, the line works fine when I
apply it to the DB after getting the error. Help!
[root@Casey root
Hi all:
Using script files is convenient because it allows storage of
frequently used queries, and facilitates editing long queries without
having to retype the whole thing.
Something that would make script files more convenient is to change
the directory from which SOURCE reads them.
My d
I developed a PHP application where users can update a mySQL table using
LOAD DATA. Recently I installed this application on another web server where
the File Permissions have been set such that this method of uploading data
is no longer valid. Since phpMyAdmin is not an option I am trying to find
I developed a PHP application where users can update a mySQL table using
LOAD DATA. Recently I installed this application on another web server where
the File Permissions have been set such that this method of uploading data
is no longer valid. Since phpMyAdmin is not an option I am trying to find
Hi All,
I'm after a little help/advice with indexing...
I have a table for measuring hits on each page within a site:
year month page hits
basically, my php script looks for a row matching this year (2002), this
month (12) and this page (something.php). if it finds it, increment by 1,
otherwis
From: Peter Abilla <[EMAIL PROTECTED]>
> In this example, I have the table 'bar' and the column 'fooID'.
It sounds to me like you've actually got two tables. If this is the case, you can do
something like:
SELECT bar.foo
FROM bar, baz
WHERE baz.fooID in (baz.fooID)
Which would give yo
MySQL Document Says.
Maximum key length is 500 bytes by default (can be changed by
recompiling). In cases of keys longer than 250 bytes, a bigger key block
size than the default of 1024 bytes is used for this key.
how can i recompile to enlarge maximum key length???
i want to create table like
I see mysqld has options to only use unix domain
socket and not bind to tcpip port. Is there a way to
do it the other way around? don't use unix socket,
only use tcpip?
Also, can I disable the unix sockets during the build
time, so that mysql will only use tcpip? Is there a
way to tell mysql to ac
I have just installed the mysql binary on solaris 8.
I would like have the data go to a different directory than /local/mysql/data.
How do I get it to do that?
I tried starting it with the --datadir set, but that didn't work.
I tried setting datadir in the /etc/my.cnf file, but that didn't work.
I
RD,
> How can I set auto-increment in mysql to start counting at say 5
rather
> than 1
The manual is your friend.
Enter auto_increment into the search facility. Read 6.5.3 CREATE TABLE
Syntax - which illustrates the answer, or move on to the better description
in the next 'hit' 6.5.4 ALTER
I have successfully inserted and retrieved binary image files within
MySQL. No big deal.
However, for quite some time I was perplexed because only about half my
image was going through.
It seems that MySQL accepts insertion of a string into a BLOB field that
is longer than the maximum length
Isn't this sort of impossible?
You are asking for something like "a set which contains as an element
the set itself"
WHERE fooId IN (fooId)
Adolfo
> -Original Message-
> From: Peter Abilla [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 02, 2002 1:43 PM
> To: [EMAIL PROTECTE
The other difference is that it works (BTW, a huge benefit)
Adolfo
> -Original Message-
> From: Beauford.2003 [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 02, 2002 11:24 AM
> To: DL Neil; [EMAIL PROTECTED]
> Subject: Re: Table setup question
>
>
> DL,
>
> OK, I get it now. I th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
H. Steuer wrote:
Hello MySQL users,
I have a weired issue using the MySQL C API and InnoDB tables.
An application polls a database every 30 seconds. When the application
starts everything seems to be fine.
During the running of the application i chan
Dear Heri,
> I tracked down the problem and saw that its only happening if I set
> autocommit=0.
> If I run a second mysql shell I can see all changes immediately. Just the
> application itself doesnt.
Does the second shell actually perform those changes? In this case, I assume
it's got something
Dear Curtis,
> might be 0 vs 1, T vs F, or Y vs N, or any combination of these.
> Is there a MySQL logical field type that will handle any/all of these at
> one time?
AFAIK you can accomplish this only on the application side. In MySQL, you
can work with ENUM('0','1')) or even CHAR(0) NOT NULL (w
Dear Jing,
> Does any one of you know how to work around this problem and access
"mysql"
> database?
1. Kill the server (kill -9 mysqld, you will probably need to log in as OS
user 'root').
2. Start the server with the option skip-grant-tables, e. g.
mysqld --skip-grant-tables.
3. Connect to th
How can I set auto-increment in mysql to start counting at say 5 rather
than 1
--
Best regards,
rdkurthmailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/man
> Select * from employees left outer join dept on employees.emp_DepId =
> dept.dep_id where dept.dep_id is null
>
> (Subselect would be easier if MySQL supported it!)
Likely easier to write, but equally likely to be more expensive to run
(on any tbl of realistic size)
NB Comment only pertinent a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter, et al --
...and then Peter Brawley said...
%
% > I can't find a my.cnf file anywhere on this
% > FreeBSD 4.5 system!
% >
% > I know [also from your other reply :-] that I can set various options in
% > my personal .my.cnf file... Does that i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bernd, et al --
...and then Bernd Prager said...
%
% Well, IMHO there's only one way to make it almost secure:
% Don't store the cc numbers unencrypted.
Agreed there; it seems to me that they would have to be encrypted at
least somewhat.
% The use
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jing --
...and then Jannie Qu said...
%
% Hi, all,
Hello!
%
% sql, query.
Yeah, that :-)
%
% I started working on an old MySQL 3.23.47 database server on SunOS 5.7, but
% I only have a regular user account. I cannot access "mysql" database.
Hi all.
Hi spam filter. SQL. Query.
MySQL versions 4.0.3, 4.0.4 and 4.0.5 all have the following problem...
When I use 'mysqladmin shutdown', 2 processes are left running and can
only be killed with a 'kill -9 '.
At midnight I run a script which backs up each database and then
restarts mysql (to
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 02, 2002 6:54 PM
Subject: Re: LEGAL information about MySQL.
> 2) Connecting to MySQL is _not_ the same as linking against it or
>modifying it in some way. Storing data a
Hello MySQL users,
I have a weired issue using the MySQL C API and InnoDB tables.
An application polls a database every 30 seconds. When the application
starts everything seems to be fine.
During the running of the application i change some rows, but the
application itself doesnt see the changes a
Well, IMHO there's only one way to make it almost secure:
Don't store the cc numbers unencrypted.
The user should log-in with a password. Don't store the password, just
a hash-value to proof the password valid.
Encode and store the sensitive data with that password.
Use a second password (don't s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William --
...and then William R. Mussatto said...
%
% On Sun, 1 Dec 2002, David T-G wrote:
%
% > Date: Sun, 1 Dec 2002 18:42:03 -0500
% > From: David T-G <[EMAIL PROTECTED]>
% > To: mysql users <[EMAIL PROTECTED]>
% > Subject: protecting ccard numb
Hi, all,
sql, query.
I started working on an old MySQL 3.23.47 database server on SunOS 5.7, but
I only have a regular user account. I cannot access "mysql" database.
I tried to use OS user "root" and "mysql" to login without password, but it
failed. No one at my company knows other username a
Hi
Verify that connections from other hosts are allowed in your GRANTS
Table(s). You need info in the Host, DB and User table the corresponding
to the person connecting from the outside.
As for it crashing. I can't tell you what's causing that.
Bruce Lewis wrote:
You may want to check the ad
I am working with data that the field values coming into the database
might be 0 vs 1, T vs F, or Y vs N, or any combination of these.
Is there a MySQL logical field type that will handle any/all of these at
one time?
Example:
I would like the following data
+---+---+---+---+
| F
Select * from employees left outer join dept on employees.emp_DepId =
dept.dep_id where dept.dep_id is null
(Subselect would be easier if MySQL supported it!)
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Silmara [mailto:[EMAIL PROTECTED]]
Hello,
I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM Indices.
I have noticed that the
myisam_block_size is set to 1K.
What does it happen if I am going to change to 8K ?
The reason for that is because the Solaris pagesize is set to 8K, so I was
thinking that
maybe I coul
On Sun, 1 Dec 2002, David T-G wrote:
> Date: Sun, 1 Dec 2002 18:42:03 -0500
> From: David T-G <[EMAIL PROTECTED]>
> To: mysql users <[EMAIL PROTECTED]>
> Subject: protecting ccard numbers
>
One way would be to encode the credit card number field using data from
an external file for the key and t
Question about SQL "WHERE IN" syntax:
I know that something like this is fine to do:
(1)
SELECT foo
FROM bar
WHERE fooID in ('1','2')
In the example above, the parenthesis includes the itemized fooID's. But, I
want to do a similar thing where instead of the actual fooID's in the WHERE
IN cl
Hiya,
Have you got a rough timescale as to when 4.1 will come out?
If not then is there a way to simulate Unicode in MySQL?
THanks,
Steve
XX
-
Before posting, please check:
http://www.mysql.com/manual.php
You may want to check the advanced features of your Linksys router. There
may be an IP imposed limit for the MYSQL server to the outside world.
It is part of a configuration that you can alter. Check the IP filtering
area.
Bruce Lewis
- Original Message -
From: "Egor Egorov" <[EMAIL
How can I query all records that not matching in another table?
Ex.
Select * from employees
where emp_DepId not in (select dep_id from dept)
Silmara
MySQL
-
Before posting, please check:
http://www.mysql.com/manual.php
DL,
OK, I get it now. I thought there would need to be duplication in the
AlbumSonglist DB. Just one other question though. What is the
difference/benefits of doing it this way, than the way I have it. Currently
I use two tables - the songlist table includes 2 id fields (one that
corresponds with
I'm trying to update mysql 3.23.49 up to 4.0.5 on a RedHat 7.3 system,
and I'm having some problems. I may be able to solve those problems by
my own, but I'm running out of time and any tip or advice would be
appreciated. I have to solve this today or I will forget updating mysql
at this time.
Fir
On Fri, Nov 29, 2002 at 10:30:58PM -0600, Mark Matthews wrote:
> If you are not sure exactly how the GPL works, and you have read the
> license terms that I've referenced above, and still want to distribute
> your software that uses and/or links to software licensed under the GPL,
> I suggest yo
Not sure if this is the problem, but in your INSERT statement, right at the
end you have this:
'" & "sStatus" & "')"
So you aren't treating this as a variable but as a string. Could this be the
bug?
Cheers
George in Oxford
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL
I've bene trying to find info on how efficient queries are for the SET
datatype, specifically, how does
MySQL use indexes for SET column types.
I have looked in the O'Reilly MySQL Reference Manual, and at mysql.com and
have found effectively nothing on this subject.
For example, if i have a table :
ali,
Monday, December 02, 2002, 2:09:19 PM, you wrote:
af> i want to know does mysql support unicode encoding ?
af> if yes ( i wish ) how can i set this ? are this support automatic or i must
af> do something ?
Unicode support will come in 4.1
--
For technical support contracts, goto https:/
Heo,
Monday, September 30, 2002, 6:20:53 AM, you wrote:
HJ> I have a following table.
HJ> mysql> SELECT * FROM group_test ;
HJ> +--+--+--+
HJ> | a| b| c|
HJ> +--+--+--+
HJ> |1 |1 |1 |
HJ> |1 |1 |1 |
HJ> |1 |1 |1 |
HJ> |2
Dyego,
Monday, December 02, 2002, 2:54:16 PM, you wrote:
DSdC> Starting from 4.0.6 mysql is declared as gamma ?
Yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/
Mir,
Sunday, December 01, 2002, 5:24:41 AM, you wrote:
MSI> Hi, apologies upfront since this is not directly a mysql question. I
MSI> have a mysql host sitting behind a linksys router/wireless ap. The mysql
MSI> host is configured as a DMZ host in the router. All web/ftp other
MSI> connections a
Has anyone else experienced this problem? To me, it looks like a bug since
according to the MySQL manual, the batch mode should work just as if the
statements where entered directly from the mysql prompt, but it appears not
to be true.
-Joacim
-Original Message-
From: Joacim Larsson [mail
aah i think i got it ...thanx..
cheers
David Ziggy Lubowa
-Original Message-
From: Danny Haworth [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 6:50 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Query
David Lubowa wrote:
>hey guys ..i got a question here i n
Hi all,
Sorry about the rain of emails I am having at this list today :-)
I have a missing quotation marks in the following which I can't see.
sCheckSQL = "SELECT * From LearnerDetails WHERE Title='" & sTitle & "' AND FName='" &
sFName & "' AND LName='" & sLName & "' AND Add1='" & sAdd1 & "' A
if i have to choose a specific realm within the query , the rest of the
results depend on the realm . how can i do that!!
cheers
David Ziggy Lubowa
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 6:40 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTE
I sent a previous question about having problems with SQL statements
using parameters not working in MySQL when they worked in Access. I am
using the ODBC driver and ADO and have had no problems at all to date.
Upon some further research the problem seems limited to SELECT
statements. Updates
David Lubowa wrote:
hey guys ..i got a question here i need to do a query which will let me pull
3 fields from a table; below is the table
now what i need from this table in one query that will give me all these: "
Realm, AcctStartTime, AcctStopTime"
SELECT Realm, AccStarTime, AcctStopTime FRO
Hi all,,
I have the following SQL statements...one of them has an error saying :Microsoft OLE
DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near ' AND Town='.
Statement 1**
sCheckSQL = "SELECT * From LearnerDetails WHERE Title='" & sTitle & "'
Beauford,
[please reply to the list - there are always others 'lurking' who will learn
from the discussion (and use of the archives is a wonderful dream...)]
You are correct, there will be duplication in the AlbumSong table - but not
within one field, only within one column. Album will consist of
Hello.
On Mon 2002-12-02 at 11:45:00 -0200, [EMAIL PROTECTED] wrote:
[...]
> In this case, does my client, the web-server or I need to pay a license to
> MySQL AB?
>
> Please, just wellfounded answers, not personal opinions.
For the authorative answer, just contact [EMAIL PROTECTED]
Regards,
select Realm, AcctStartTime, AcctStopTime from radacct;
??? Did I miss something here?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: David Lubowa [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:29 AM
To: [EMAIL PROTECTED]
Subject:
Paolo Pasetti wrote:
Do you usually use a cron job to start and stop slave or just leave it always on?
Always leave it on.
Basically, check how big your binary logs are for a day by rotating them
at midnight two days in a row and that's approximately the network
traffic for the day.
SQL,
hey guys ..i got a question here i need to do a query which will let me pull
3 fields from a table; below is the table
[snip]
mysql> desc radacct;
++-+--+-+-+-
---+
| Field | Type| Null | Key | Default
I see two problems.
1. You seem to be missing a left parentheses (, or you could just get rid of
the right paren.
2. You need to change "CurrentlyEmployed= AND". The lack of a value will
cause problems.
Duncan
---
Duncan Salada
Titan Systems Corpora
Please note...the values that don't have ' ' are int type.
Here is the error bellow:
SELECT * From LearnerDetails WHERE Title='Mr' AND FName='Natasha' AND
LName='Burkenshaw' AND Add1='17 Cromer Road' AND Town='Hornchurch' AND County='Essex'
AND PostCode='RM11 1EY' AND CurrentlyEmployed= AND Tel
See Notes
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 14:01
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Error in SELECT
Hi,
I have the following statement that is causing a syntax error:
sLearnerSQL = "
SELECT *
>From LearnerDetai
> -Original Message-
> From: Pae Choi [mailto:[EMAIL PROTECTED]]
> Seems like all against I see are coming from MySQL team.
> I know MySQL is stealing a lot of code from the public
> domain, inclduing the SSL part. How funny!
By definition you can't "steal" anything from the public doma
> -Original Message-
> From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
> Can anyone recommend a software app. I could buy to be able
> to dump data and
> table structures to a text file. Ideally as mentioned before
> I need to run
> this on a hourly basis.
Backing up the entire data
Hi,
I have the following statement that is causing a syntax error:
sLearnerSQL = "SELECT * From LearnerDetails WHERE Title='" & sTitle & "' AND FName='"
& sFName & "' AND LName='" & sLName & "' AND Add1='" & sAdd1 & "' AND Add2='" & sAdd2
& "' AND Town='" & sTown & "' AND County='" & sCounty &"
Sorry continue this subject ... I´m the author original question, "LEGAL
information about MySQL".
But I Think that my question is simple and the other answers do not make
sense to me.
I never said that I change original MySQL source code, and I just want know
if I can use MySQL database on
my
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dyego --
...and then Dyego Souza do Carmo said...
%
% Starting from 4.0.6 mysql is declared as gamma ?
That's what the manual and the release announcement say.
[15 lines of obnoxious signature and 8 lines of ridiculous mail list
footer deleted.]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joao --
...and then João Borsoi said...
%
% I working in a project to be released 6 months from now. We are
% currently using mysql 3.23.49 with Innodb. I'm thinking about upgrading
% it to mysql 4.0.5a because of some deadlock bugs. What is the risk
The original version that the data would've been built on was MySQL
3.23.52 under Linux x86 (Debian Sarge to be more specific).
I'm currently rebuilding the database under MySQL 3.23.53 under WinXP.
--
Scott Balmos
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Dear mySQL list members
I'm writing to inform you that ATAF version 6.0 is released today, and is ready to be
downloaded under Http://www.ataf.dk
ATAF's amazingly easy way to convert your MS-Access or ODBC database to an Internet
web application is now drastically improved compared to the old 5
Starting from 4.0.6 mysql is declared as gamma ?
sql,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C
hi all
i want to know does mysql support unicode encoding ?
if yes ( i wish ) how can i set this ? are this support automatic or i must
do something ?
thax in advance
ali
http://www.freewebz.com/alphautils
-
Before posting, ple
Try something like
CREATE TABLE album( ida int primary key , title varchar(n) not null ) ;
CREATE TABLE songs( ids intprimary key, song varchar(m) not null ) ;
CREATE TABLE albumsongs(
ida int not null,
ids int not null,
primary key(ida,ids),
foreign key(ida) referen
João Borsoi wrote:
I working in a project to be released 6 months from now. We are
currently using mysql 3.23.49 with Innodb. I'm thinking about upgrading
it to mysql 4.0.5a because of some deadlock bugs. What is the risk of
going to a development version? Is it stable?
I've been living on th
I'm working with Delphi and MySQL, and I would like to do a backup through
my application executing a .bat like
c:\mysql\bin\mysqldump -h%1 -u%2 -p%3 DATABASE>%4, but when I run bat
through of the following statement
" if ExecuteFile('bkdata.bat ',192.128.0.6+ ' USER' + ' PASSWORD'+'
C:\'+FormataD
SELECT @myvar := 1 ;
> -Original Message-
> From: Gerald Norman [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 01, 2002 10:37 PM
> To: [EMAIL PROTECTED]
> Subject: Converting Access to MySQL
>
>
> I have an application that currently is using an Access
> database and am
> in the
ajitdixit,
Wednesday, November 27, 2002, 7:44:55 PM, you wrote:
aasdcdi> I had earlier downloaded mysql-4.1.1 development branch source code and had
aasdcdi> noticed that This bug is also present in 4.1.1 development tree source code
Merge of 4.0.6 changes into 4.1 was made several days ago.
aas
Scott,
Monday, December 02, 2002, 5:46:18 AM, you wrote:
SB> I'm in the process of rebuilding a table in MyISAM format. I can see the
SB> plaintext data in the .MYD file just fine. But after running myisamchk
SB> -i table, which reports fine and repairs the index to the correct 388
SB> rows... I g
Kittiphum,
Saturday, November 30, 2002, 2:09:00 AM, you wrote:
KW> Why merge table have been done with table that have column char type
KW> not varchar type.
KW> Have anyone succesfully with varchar type merge table and how to do
KW> that.
KW> And how to use union query if merge table not work
David,
Saturday, November 30, 2002, 4:57:58 AM, you wrote:
DHM> I'm running mysql 3.23.53 on Red hat linux 7.1.
DHM> When i do mysqladmin version, it does not list a port and
Because you connect to a Unix socket, not to a TCP/IP port.
DHM> when I do mysqladmin -h 'hostname' version, it says tha
I working in a project to be released 6 months from now. We are
currently using mysql 3.23.49 with Innodb. I'm thinking about upgrading
it to mysql 4.0.5a because of some deadlock bugs. What is the risk of
going to a development version? Is it stable?
Thanks,
Joao.
---
MySQL Reference Manual for version 3.23.7-alpha. - ...:ÄúºÃ!
ÆÕ¹âÍøÂç ÐֵܽãÃÃÃÇÈ¥Õâ¸öÍøÕ¾ÇÆһϣ¬Èç¹û¾õµÄ¿ÉÒԵĻ°¾Í×¢²á°É¡£Ç®ÊÇÉÙÒ»µã²»¹ý¶¼
ÊÇʵÔڵģ¬ÎÒÒѵõ½ÁË30¶àÔªÁË¡£
http://www.nu18.com/hz/?mid=extraterres´ó¼ÒֻҪͨ¹ýÏÂÏß¾ãÀÖÁªÃË×¢²á³ÉΪÆÕͨ»áÔ±(ÊÇÃâ·ÑµÄѽ)£¬Íê³ÉÿÌìµÄ10¸öµã»÷Á´½Ó£¬ºÃºÃµØ
maps filter fodder: MySQL
> Hi Terence,
>
> > Is there a way to sort records based on a particular column, varchar(3),
> > which contains days of the week, mon, tue, wed, thu, fri, sat, sun
> >
> > I need the order to be mon, tue, wed, thu etc.
> >
> > Select day_of_week from my_timetable
> > ord
Alex,
This is a specialised question! Unfortunately, in my experience, it comes
down to the phrase YMMV (your mileage might vary) and thus requires you to
experiment with your data/machine combinations/etc - good job MySQL makes
this quite easy!
Can I assume that you have done your (manual) homew
Hi Beauford,
You are on the right track. Yes you should remove the songs to a separate
table. If you merely duplicate the first example (below) in two tables you
have created a "one-to-many" relationship between the Album table and the
Songs table - one album has many songs on it. Your query code
Hi Kath,
Are the MySQL machine, the Linux machine, and the client you are using all
the same machine?
Which timezone is Linux set to?
Which timezone is your local/client machine in, and/or set to?
Please advise,
=dn
> hi, which date does mysql use to calculate CURDATE()? I have a master
> databas
Haksun,
Confirming that my system-combination (below) works as expected and does NOT
exhibit the XP 'bug' you are experiencing.
My system's output is 1 2 1 2 + 1 4 1 2 + 1 2 1 4 + 1 4 1 4.
Regards,
=dn
> DL,
>
> Thanks for the reply.
> Can you give more details please?
>
> If I understand you cor
Hi all,
Is there a way to sort records based on a particular column, varchar(3),
which contains days of the week, mon, tue, wed, thu, fri, sat, sun
I need the order to be mon, tue, wed, thu etc.
Select day_of_week from my_timetable
order by day_of_week
Gives
>fri
>mon
>sat
>sun
>thu
>tue
>wed
Hello,
I'd like to know how much traffic the slave generates to retrieve sql data on master
server in a database replication configuration.
I'm interested in knowing this: does the slave generate traffic even if no updates are
done on the master (traffic for waiting data?) ?
Do you usually use
100 matches
Mail list logo
