Hi,
a few weeks ago I spotted part "6.8 MySQL Full-text Search" of the
manual the first time. Reading through the lines gave me the impression
it's nice but lacking some features I need - unless I misunderstand the
manual.
a.) no relevance in boolean mode (?)
Is there any chance to sort the
Hi there,
I will shortly be installing a MySQL server at my place of work, the box I
will be installing it on currently has MS SQL server running as well. (I
believe its a "wintel" box).
Anyway, I am wondering if there are any known problems having MS SQL and
MySQL running on the same machine.
My
Hello,
I am setting up a mysql database and have a questions about users.
I would like everybody to have the possibility to consult the database
without having to introduce a user and /or password (even not showing the
screen for user and password).
Only a few people will have to possibility to i
Hi ..
When you use the grant command the user if not existing in the user table then
the user is added in the table along with the privileges mentioned..The user
need not be a unix user..by this you are adding a user to access the mysql DB..
the link below explains the same in detail
http://
Hi,
1. Is authentication check based on user table in mysql database.
2. If there is a unix user, then only giving password through grant
command will suffice ..How the entry of that user got created in the
user table.
regards
Syamala
-
> Jack Daniel's Law of Motion: 'You can't fall off the floor'!
Try using Task Scheduler.
KHC> I am using MySql version 4.0.0-alpha in Windows 2000.
KHC> Everytime when I want to backup the database,i do it in MS-DOS.
KHC> Using this command:
>>mysqldump --opt mydatabasename > mybackup.sq
Short and simple, is it possible to escape by two different parameters? This
used to work:
SELECT * from allusa WHERE (updated_by='I' or updated_by='A' or
updated_by='L') AND (id<9) AND last_updated > '2002020100' ORDER BY
last_updated INTO OUTFILE
'/home/www/site/admin/admin/dbdump/bb200
mysql> select distinct(nexthop) ip from NameRoute
where OwnerIP='10.0.1.1' and
nexthop not in (select ip from NameIP where
OwnerIP='10.0.1.1');
ERROR 1064: You have an error in your SQL syntax near
'select ip from NameIP whe
re OwnerIP='10.0.1.1')' at line 1
_
Encounter the following error in MyCC:
[root@localhost:3306]ERROR 1005: Can't create table
'.\abc\def.frm' (errno 121)
I'm using MySQL 3.23.49 and Win98se. The statement I
used work on the default MYISAM table and DBD table
and I did changed the TYPE=InnoDB in the CREATE
statement.
The following
Hi,
I am using MySql version 4.0.0-alpha in Windows 2000.
Everytime when I want to backup the database,i do it in MS-DOS.
Using this command:
>mysqldump --opt mydatabasename > mybackup.sql
Now,lets say i never shut down my pc and the MySql is running all the time.
How can i do a regular backup (ie
Hi,
1. date_format(datecolumn,'%b');
2. date_format(datecolumn,'%d)+0; or
if you want a string result
trim(leading '0' from date_format(datecolumn,'%d));
The manual has very clear description of date functions.
Anvar.
At 01:47 AM 05/04/2002 +, you wrote:
>hi,
>
>I have some more
In the last episode (Apr 04), Bill Easton said:
> I have a bunch of users with a MySQL database on their local
> machines.
>
> Life would be simpler if they were able to access the MySQL database
> (read only) from Microsoft Access.
>
> Can this be done through an ODBC connection? Can somebody
I have a bunch of users with a MySQL database on their local machines.
Life would be simpler if they were able to access the MySQL database (read
only) from Microsoft Access.
Can this be done through an ODBC connection? Can somebody tell me how to
set it up?
--
hi,
I have some more problem with date query.
1.how to return month from numeric to aalpabet.04->Apr.
2.how to return day or month without 0 in front.
i mean if day is 01->1,same also month if 02-2.
Is it possible.please help me.
Thanks in advance.
At 20:25 -0500 4/4/02, James Hedrick wrote:
>Hi Gang,
>I am currently specing out a table in MySQL manager and I am trying to set
>sysdate as default value for ActivityDate column ( a datetime field). If I
>specify sysdate() in default value field then the DDL changes to show
>default as "default
Hi Gang,
I am currently specing out a table in MySQL manager and I am trying to set
sysdate as default value for ActivityDate column ( a datetime field). If I
specify sysdate() in default value field then the DDL changes to show
default as "default '-00-00 00:00:00'". What am I doing wrong?
T
select date_format(DATEFIELD, "%d-%m") from YOURTABLE;
-- Jason
On Thu, 2002-04-04 at 19:45, saraswathy saras wrote:
> hi,
>
> Can anyone help me.how to query out only day and month from the table.
> The result should be like this:-
> ---
> |05-04|
> ---
> |06-04|
> ---
> |07-04
At 11:03 3/4/2002 -0500, Eugene Mah wrote:
Hi!
Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.
C:\>c:\mysql\bin\mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.49-ma
hi,
Can anyone help me.how to query out only day and month from the table.
The result should be like this:-
---
|05-04|
---
|06-04|
---
|07-04|
---
is there any way to do this.Please help me.
thanks in advance.
_
Se
did you FLUSH (reload) your mysql server?
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "Dan Egli" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 6:21 PM
Subject: Authentication messed up?
> I trie
I tried to add a user to my mysql system for the MTA (exim) but am having a
hard time making it work.
I used grant to give exim permissions:
grant ALL PRIVILEGES on exim.* to exim@localhost IDENTIFIED BY PASSWORD
;
and the exim database does exist, BUT.
[root@shortcircuit root]# mysql exim
If you're on a unix-like machine, you might be able to just type edit at
the mysql> prompt, which might take you to a vi session, much better for
editing complex sql commands. When you want to execute the command, in vi
just do ZZ, which will take you back out to mysql client. Type go or \G t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At Donnerstag, 4. April 2002 17:57 Hathaway, Scott L wrote:
> Yes, that should only cause a reordering within the group itself, but in my
> case, the group breaks into two groups!
Your 'group by' clause needs to have the same fields (and in the same
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At Donnerstag, 4. April 2002 21:24 adam nelson wrote:
> Firewall isn't good enough (who else is inside your firewall, likely the
> entire hosting company or internal corporate network). The user table
> has a host column that I use. Also, you can en
catatrostrophy averted with kill -9 8374, and started up fine.
thx,
John
-Original Message-
From: John Parsons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 5:18 PM
To: 'john'
Subject: RE: Help. I have truly blundered.
> -Original Message-
> From: john [mailto:[EMAIL
You must specify the -p to the mysql, so it prompts you for a password.
> I'm learning mySQL and I think I missed something or
> missconfigured...because I get an Access denied error. Any hints what I am
> missing? What should I check?
> mysql -u root mysql
> ERROR 1045: Access denied for user
Ok.
Easy enough to fix.
As root..
Do a "kill -9 `ps -ef | grep mysqld | grep -v grep`" ( those are
backticks, not single quotes. )
Or you can do, more manually..
"ps -ef | grep mysqld | grep -v grep"
Then do a "kill -9 PID" where PID is the process ID of the line
returned.
Then try and star
I'm learning mySQL and I think I missed something or
missconfigured...because I get an Access denied error. Any hints what I am
missing? What should I check?
OS: OpenBSD 3.0
# ./mysqladmin -u root -p ver
Enter password:
./mysqladmin Ver 8.23 Distrib 3.23.49, for unknown-openbsd3.0 on i386
Copyr
Steven,
The contents are as follows:
020404 17:00:21 Aborting
mysqld ended on Thu Apr 4 17:00:21 CST 2002
mysqld started on Thu Apr 4 17:00:28 CST 2002
020404 17:00:28 Can't start server: Bind on TCP/IP port: Address already in
use
020404 17:00:28 Do you already have another mysqld serv
What do the contents of the ns1.acculock.com.err file look like?
--
sh
On Thu, 2002-04-04 at 14:45, john wrote:
> Yeah, I wish it were that easy. I have attempted to do so, and here is a
> transcription of my recent events to catch you up to me: ...and by the way
> thanks, john
>
> I was worki
Yeah, I wish it were that easy. I have attempted to do so, and here is a
transcription of my recent events to catch you up to me: ...and by the way
thanks, john
I was working in MySQL under user:john, which has direct privelages to all
features of MySQL. ...Anyway thinking I was root, I called o
Wow John... Sounds like you are in deep chit... Just kidding... Linux 6
doesn't say which distro it is, same with mysql 3, there are a bunch of
mysql version3s out there.
Your problem...
Log into as root then restart it.
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent:
Alright, this may come across as a stupid question -
In the mysql client, is there any way to get rid of the damn -> sign
when you are writing a query out?
I ask because it'd make it alot easier to copy and paste the query back
in, if lets say, I messed up on a single item.
mysql> create table
su as root
then restart mysqld
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 4:10 PM
To: MySQL Lists
Subject: Help. I have truly blundered.
Please help with ignorance, I was in mysqld making some changes to a
database. I run a Linux 6 box with M
Please help with ignorance, I was in mysqld making some changes to a
database. I run a Linux 6 box with MySQL 3 on it. I was logged in as user
john, who has all access privelages to mysqld. John is not root, and I told
mysql to stop. Well, mysql will not start again. What can I do?
Thanks for all the responses I've received.
I managed to fix it just before the first response arrived :-)
I untar'd an old backup I had just to get mysql seeing the tables and fields
again, then used mysqldump. After restarting mysql, I loaded the dumped
database back into mysql and all worked
Hello folks
Can anyone tell me an easy (1 SQL statement) to strip out non-alpha-numeric
characters from a field please, using SQL in MYSQL (ver 3 or 4)
eg.
'this house'> this house
<>-123 house> 123 house
I want to keep spaces, alpha chars and numerics, but everything else need
I want to run a scheduled task (WIN 2K Server) to backup a db (using
MySQLhotcopy) and need help -
Is this correct?
C:\mysql\mysqlhotcopy -p"password" database table > backup.db
xcopy [flags] C:\mysql\backup.db C:\backup\backup.db.
Is there a better MySQL feature to backup the db that someone w
Hi,
---
In MySQL Version 3.23, in-memory temporary tables will automatically be
converted to a disk-based MyISAM table after the table size gets bigger than
tmp_table_size.
---
It also says this though. I'm using mysql 4. Is the above not true for mysql
4?
Ric
- Original Message -
From:
Hi,
right now I am using MySQL for Linux and it quite fast, before that I used
MySQL for Windows and the connection from Java to MySQL was kinda slow
and I gained a lot of speed when I switched to the Linux version. My question
is I would like to use MySQL for HP UX, but I don't know how fast it
Hi list members,
I'm compiling mysql 3.23.49 using following configure options:
./configure --prefix=/usr/local/mysql-max --with-server-suffix=-max --with-i
nnodb --with-bdb
When the make process reaches mysql.cc en client subdir, the compilation
stops with following errors:
In file included fr
On Thursday 04 April 2002 2:21 pm, Guy-Maurice Lepoutre wrote:
> Hello,
>
> I would like to create a MySQL database using DAO and
> Visual C++ 6.0 (CDaoDatabase and CDaoRecordset). I
> know there is a Create() method on CDaoDatabase but I
> cannot figure out how to use it to create a mysql
> datab
Well also, 0x00 != 0
and to test for NULL in mysql you need to use special functions IS NULL,
IS NOT NULL etc.
Rodney Broom wrote:
>
> From: Andrew Hazen <[EMAIL PROTECTED]>
>
> > If it was blank, the sql statement would fail...
>
> Nope, you're passing an empty string with '$login'. NULL is
Hi Andrew,
If you insert NULL value into a column that is defined as NOT NULL , the
server puts in empty string ('') for the value... Try to use PHP to enforce
$login to have a string value.
Or you can compile a source distribution with -DDONT_USE_DEFAULT_FIELDS
option to overcome this. See : htt
Hello,
I would like to create a MySQL database using DAO and
Visual C++ 6.0 (CDaoDatabase and CDaoRecordset). I
know there is a Create() method on CDaoDatabase but I
cannot figure out how to use it to create a mysql
database. Does anyone know how to do this?
Moreover, do you know which files are
Greetings!
We're having a [reproducible] problem where a query suddenly gets very
slow. The table has a primary key and another key. Any operation that
affects the index, such as insert or update, slows down subsequent queries
that use the index.
Any of the following "fixes" the problem and mak
Using "EMS MySQL Manager" connect to your database and choose flush methods
and optimize tables from the menu. It may help you..
-Original Message-
From: John Parsons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:52 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: DESPER
From: Andrew Hazen <[EMAIL PROTECTED]>
> If it was blank, the sql statement would fail...
Nope, you're passing an empty string with '$login'. NULL is not empty, it's less that
that. It's nothing. What you want is:
emplogin=$login
Rather than:
emplogin='$login'
> ...is SOMETIMES blank
It is not inserting NULL. when $login is NULL or blank, then a a record,
with emplogin equal to a string of zero characters is inserted, which is
valid. A string with zero characters is NOT a NULL value. So, it is
accepted.
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED
Hi,
I'm getting a weird effect in the task manager app we use internally.
I have a table emp_tasktime which records work sessions on tasks.
The column emplogin varchar(25) not null
is intermittently allowing null entries for just one employee.
The insert statement is:
INSERT INTO emp_tasktime
From: Balteo <[EMAIL PROTECTED]>
> Why don't you create a php script that generates SQL instead of HTML; i
> will repopulate your database acting as a dump?
Not a bad idea. John, be carefull not to mess up whatever cache is currently in place
by changing something that will confuse the cache.
Why don't you create a php script that generates SQL instead of HTML; i
will repopulate your database acting as a dump?
I know it will take some time to develop...
Balteo,
John Parsons wrote:
>I have just been a complete muppet and trashed the tables in my database and
>don't have a recent b
I have just been a complete muppet and trashed the tables in my database and
don't have a recent backup.
The database is used for the phpBB system and still functions when I visit
the site via a web browser since the database is still cached. Is there any
way I can recover the database using the
It is quite POSSIBLE to submit SQL statements via a web browser.
It sounds to me like all you want is a simple ad-hoc query processor. If so, all
you need is a relatively simple perl or php script (or whatever language you want)
which executes your ad-hoc query and returns the result.
PHP e
- Original Message -
From: "Tobias K. Tobiasen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 6:46 PM
Subject: Group by?
> Hello
>
> I think the gruop by is behaving strange. Could someone please explain
> this or maybe point me to a definition of the gro
In the last episode (Apr 04), JW said:
> I was already looking at these... Does anyone have any experience
> with MySQL a v880? Someone on another list was saying:
>
> "You've got to remember that in a lot of scenerios, more processors
> can degrade preformance instead of enhancing it. 4 Dual pr
> This will not work for my example. I have a select box that was populated
> from the db with firstname lastname. The option tag has the value of
> firstname+lastname then. Here lies the problem, when I build the query, I
> have no way of distinguishing firstname and lastname.
if you really d
Firewall isn't good enough (who else is inside your firewall, likely the
entire hosting company or internal corporate network). The user table
has a host column that I use. Also, you can enable ipfw or some other
local firewall on the host itself if you are very serious.
-Original Message--
HI,
I am doing a project which looks at internals of a database and I
am trying to understand MySQL source code. I have installed the source
code of version 3.23.47, the most stable version. I am working on Redhat
linux 7.0 version.
I have complied it, made some change
Use CHAR, not TEXT for Nombre and Password
Also, INT will NOT be set to length of 1 in permiso
-Original Message-
From: Gastón Sancassano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 12:10 PM
To: [EMAIL PROTECTED]
Subject: SQl query in MySQL (1)
My name is Gastón Sancassano
Maybe you really wanted ORDER BY.
Tobias K. Tobiasen wrote:
> Hello
>
> I think the gruop by is behaving strange. Could someone please explain
> this or maybe point me to a definition of the group by. (Inspired by
> http://www.mysql.org/doc/E/x/Examples.html).
>
>
> CREATE TABLE shop (
> arti
Hi there,
Lets say i do the following query:
mysql > select something from some_table;
Then i will get the results , how many rows and how much time it took to
perform the query.
My question is how can i get the time it took for perform the query.
I want that cuz i would like to put in a web pag
bear with me-
my host disabled network so I can only connect thru SSH telnet via
localhost. i'd like to use mySQL-FRONT to utilize mySQL.
I am using PuTTY to establish SSH, and what I did was create local port
forwarding. L3306 forwards to localhost:3306 I then run mySQL-FRONT, using
localhost
[EMAIL PROTECTED] wrote:
>
> This will not work for my example. I have a select box that was populated
> from the db with firstname lastname. The option tag has the value of
> firstname+lastname then. Here lies the problem, when I build the query, I
> have no way of distinguishing firstname an
Will MYSQL run on Netware?
thanks
Ed
Edward Heiger III, CNE
Manager of I/S
Department of Medicine
Phone: 410-328-1807
Fax: 410-328-3861
http://www.medicine.umaryland.edu/is
-
Before posting, please check:
http://www.mys
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
DN >In the last episode (Apr 04), JW said:
DN >Heh. plus the maintenence nightmare of managing 48 servers, 96 mirrored
DN >boot disks, 96 power supplies, etc etc..
DN >
DN >A comparable system to the Dell link you pasted is the Sun Fire v880.
DN >For
If this is web based, you could store the id of the record in the VALUE
parameter of the OPTION tag
You could alternately create some kind of object(Vector, array, list
whatever your language is) that would track the id and have that be along
side of the select box, or perhaps your select box can
My name is Gastón Sancassano and I would like to make some questions about
MySQL because I am a novice.
My question is:
- How does PRYMARY KEY and UNIQUE works?
My problem is that I want to create a table with 3 columns (Nombre, Password
and Permiso) and I don't like to have the name repeated
When compiling Mysql on a Dec 3000 OSF1 V4.0 I get the following error:
sql_yacco.yy:719: Parse error before '}'
sql_yacco.yy:1462: Parse error before '}'
sql_yacco.yy:1689: Parse error before '}'
sql_yacco.yy:1723: Parse error before '}'
sql_yacco.yy:1746: Parse error before '}'
sql_yacco.yy:180
At 10:43 AM 4/4/2002, you wrote:
>Hi david,
>Just create another table in your database with the structure and data of
>the table. See "CREATE TABLE ... SELECT ..." syntax at :
>http://www.mysql.com/doc/C/R/CREATE_TABLE.html for this task.
>
> Then update all the category values from 2 to 4 in t
In the last episode (Apr 04), JW said:
> On Thursday 04 April 2002 09:48 am, you wrote:
> > I think you'll find that the RISC systems have fewer processors and
> > run at lower clockspeeds for the same total performance. 100k is a
> > HUGE amount of money to drop on a system. You could get 2 full
At 10:28 AM 4/4/2002, you wrote:
>On Thursday 04 April 2002 09:48 am, you wrote:
> > I think you'll find that the RISC systems have fewer processors and run at
> > lower clockspeeds for the same total performance. 100k is a HUGE amount of
> > money to drop on a system. You could get 2 full racks o
Ack, sorry (to you and Gurhan)... I've done this trick, but
I was actually looking at it with more than one ID, hence
the group by... either select from a whole table for a date
or joining against another table with the desired ids...
On Thu, Apr 04, 2002 at 06:59:30PM +0200, Roger Baklund wro
T'would help had you provided us with your code. Regardless, create your
SELECT box such that the values are comprised of first name and last name
separated by +. The construction would appear liek:
John Smith
John Van Buren
Sam Jones
Chuck Barnett
Zsa Zsa Gabor
Frank Zappa
process.php -
Anthony,
Is all the information you need to retrieve in one table? If yes , I don't
think you have to do join to get the row you want..
you should be able to do it by:
SELECT columns FROM table WHERE id=yourid AND DATE => 'date' ORDER BY DATE
LIMIT 1;
Is this what you are asking? And I think it
This will not work for my example. I have a select box that was populated
from the db with firstname lastname. The option tag has the value of
firstname+lastname then. Here lies the problem, when I build the query, I
have no way of distinguishing firstname and lastname.
Chuck
- Original Me
Read http://www.mysql.com/doc/A/c/Access_denied.html
> Everytime I try to setup an odbc connection from a windows 2000 to a
> sun unix box which is the sql server host is get the following error:
>
> ...Host '%-.64s' is nto allowed to connect to this MYSQL server.
>
> Any ideas???
>
> __
At 04:23 PM 4/3/2002, you wrote:
>hello,
>
>i have plans to create a complex SQL database.
>before that i'd like to draw a scheme of it.
>could you please advice which
>program(freeware/shareware)
>would fit for that purpose?
>any links to pages, tutorials about graphical
>databases projecting wou
At 12:16 PM 4/4/2002, you wrote:
>Is it possible to access a sql statement to mysql database through
>Internet explorer ? such as :
>
> http://www.abc.com?select * from test
>
>Thanks.
>
>
>--
>
>Best regards,
>
>
>Ridwan
>Goldbase Technology
Ridwan,
Of course, with something lik
SELECT * FROM mytable WHERE first_name=$first && last_name=$last
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: Query help
Hi. I have two fields, firstname, lastname. I populate a select box with
SELECT * FROM mytable WHERE date_field mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:30 AM
To: [EMAIL PROTECTED]
Subject: Getting the most recent record per id before date X
I am trying to figure out the best way to select
the row of data for a specific id that is the most
rece
* Anthony R. J. Ball
> I am trying to figure out the best way to select
> the row of data for a specific id that is the most
> recent entry on or before a specific date.
What about:
SELECT * FROM table
WHERE
id = $specific_id AND
date <= '$specific_date'
ORDER BY date DESC
LIM
Hi all,
I hav a problem while dumoing my data into a mysql server provider.
I have some lost connexion during dumping.
So I have to delete by hand the lines inserted and then resrtar wuth the
other.
Do u know a tool that can make this for me.
That meens redo with lines which hadnt been treated a
> I have a MySQL database containing records from several years. I want to
> calculate counts of records for each year and separate values for a couple
> of other fields. Each record contains a date-field, date. I tried putting
> the function YEAR(date) into a GROUP BY section, but this didnot wor
Hello
I think the gruop by is behaving strange. Could someone please explain
this or maybe point me to a definition of the group by. (Inspired by
http://www.mysql.org/doc/E/x/Examples.html).
CREATE TABLE shop (
article INT(4) UNSIGNED ZEROFILL DEFAULT '' NOT NULL,
dealer CHAR(20)
On Thursday 04 April 2002 09:48 am, you wrote:
> I think you'll find that the RISC systems have fewer processors and run at
> lower clockspeeds for the same total performance. 100k is a HUGE amount of
> money to drop on a system. You could get 2 full racks of high performance
> 1U systems, includi
Hi david,
Just create another table in your database with the structure and data of
the table. See "CREATE TABLE ... SELECT ..." syntax at :
http://www.mysql.com/doc/C/R/CREATE_TABLE.html for this task.
Then update all the category values from 2 to 4 in that table. Use
mysqldump to copy it into
Gilles,
Thursday, April 04, 2002, 7:20:35 PM, you wrote:
GM> When I try :
GM> mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
GM> I get this error message :
GM> The used command is not allowd with this MySQL version.
GM> I've nevertheless downloaded the latest stable version on
Hi Dean,
> I have a table with a char(2) and when I send it '02' I want it to stay
> 02,
> but instead it stores 2
>
> How do I make this store as '02'?
Works for me:
mysql> create table t ( a char(2) );
Query OK, 0 rows affected (0.08 sec)
mysql> insert into t values ('02');
Query OK, 1 row
Everytime I try to setup an odbc connection from a windows 2000 to a sun
unix box which is the sql server host is get the following error:
...Host '%-.64s' is nto allowed to connect to this MYSQL server.
Any ideas???
_
Join the wo
Hi. I have two fields, firstname, lastname. I populate a select box with
the firstname lastname. Now when a user selects a name and hits submit, the
program will(should) select * from table where the selected name equal
firstname+lastname. I guess you have to some how put the first and last
na
On Wednesday 03 April 2002 13:25, Russell E Glaue wrote:
> I am an avid PERL programmer, I also know java. I cannot completely agree
> with either of you.
> However, this debated subject is best discussed in another community.
> The focus here is what has the necessary abilities/functionality to c
I am trying to figure out the best way to select
the row of data for a specific id that is the most
recent entry on or before a specific date.
I realize that I could create a temp table and select
where date <= X and group by id, inserting the max
date into the table with the id, then do a
On Thursday 04 April 2002 09:48 am, you wrote:
> I think you'll find that the RISC systems have fewer processors and run at
> lower clockspeeds for the same total performance. 100k is a HUGE amount of
> money to drop on a system. You could get 2 full racks of high performance
> 1U systems, includi
GROUP BY is done on column value.
show us you query
-Original Message-
From: Han de Neeling [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 7:15 AM
To: [EMAIL PROTECTED]
Subject: group by year
I have a MySQL database containing records from several years. I want to
calculate
Rajeev,
please upgrade to 3.23.49a.
.37 is a very old version, and the current documents do not accurately
describe it.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http
Hi.
When I try :
mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
I get this error message :
The used command is not allowd with this MySQL version.
I've nevertheless downloaded the latest stable version on mysql.com.
The select version() statement gives me :
3.23.49-nt
MyS
Hi!
We apologize for the delay in releasing 3.23.50. InnoDB-3.23.50 has been
ready for 2 weeks now.
The problem is that Monty wants to compile on Linux the MySQL binaries with
gcc-3.0.4 and a rather new glibc version, and that combination does not seem
to produce stable binaries of MySQL. I aske
Yes but in fact i forgot to say that i have to change a value of a column,
Ex dump all data from table where category = 2 and
insert all this data into the other mysql with category = 4 and not 2
I think with too connection
i can select all data then insert in new server
ben delete on the old ser
IS it something that you can get the data with mysqldump into an sql file
and then load it into the database you want it to be transferred to? If yes
you can do it all in the command line.
Gurhan
-Original Message-
From: David BORDAS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04,
1 - 100 of 159 matches
Mail list logo