Hello!
two ways:
Fun way: Get Perl and write some cgi using html/javascript front end
Another way (maybe not as fun - but gets the job done):
Enter data in Excel spreadsheet and export to comma delimited file. Then go
and read the docs on mysqlimport command.
Cheers!
-Original Messag
Hello mysql,
Why after TRUNCATE TABLE data file with indexes not freed ?
and TRUNCATE TABLE is very slow ...
MySQL 3.23.51+InnoDB
OS: Linux 2.4.18/ReiserFS
Best regards,
Andrew Sitnikov
e-mail : [EMAIL PROTECTED]
GSM: (+372) 56491109
---
Hi.
On Thu 2002-07-25 at 11:44:26 -0400, [EMAIL PROTECTED] wrote:
>
> Mysql engine is running under win98, then at the prompt I type mysql
> mysql then press enter and I have control. I can delete users (root
> included), whatever I want, so How can I make Mysql always require a
> username and a
Hi.
On Thu 2002-07-25 at 16:44:19 +0100, [EMAIL PROTECTED] wrote:
[...]
> I want to create a query that will select the user from the users
> table and if they have any time data against them (for that day)
> return that also. If there is not data for that day only the user
> data should be retur
Hi.
On Thu 2002-07-25 at 11:24:36 -0400, [EMAIL PROTECTED] wrote:
> Hi
>
> I am storing a list of titles on a mysql db. Some of the records start
> with 'The','A' or 'An'. I would like to be able to enter the title in
> the form 'The Count .' instead of 'Count ..., The' and have the
> reco
Your application uses the field size and type to validate the data
BEFORE sending it to MySQL.
Norris, Joseph wrote:
>Hello,
>
>
>What you say below is of great interest to me. Currently I have been
>writing front end code to handle the size
>issue but I would like to be open to other possibil
I am in the process of testing out the 4.0 series of MySQL and am having
some problems when I try to install the php-mysql RPM. The machine is a
RedHat 7.2 i386 box with all current patches.
I pulled down the source RPM for 4.0.2-2 and rebuilt the RPM's with debug
enabled then installed all the n
On 2002-07-25 07:12, "William Bradley" <[EMAIL PROTECTED]> wrote:
> At the moment I have Mysql installed and understand command line entry
> of data, or entry via a text file. Either way, it is difficult,
> especially if you have been used to data entry screens. Is there a
> utility somewhere tha
I would buy a book called PHP Essentials. www.thickbook.com
I used it to learn how to write an html/php interface to my databases and i
use it all the time now. It takes a bit of work to get the interfaces built
but the book is really easy to follow and understand.
seth
-Original Message--
phpMyAdmin if you have a webserver with php you can use.
or you can use MyODBC and us MS Access to make a front end for data entry.
-- Forwarded Message --
Subject: Data Entry for a Newbie
Date: 25 Jul 2002 11:12:35 -0400
From: William Bradley <[EMAIL PROTECTED]>
To: Mysql <[
Victoria,
I am using mysql-3.23.49-ibm-aix4.3.3.0-rs6000.tar.gz,
which is the latest version posted on your site.
Also, when I try to compile mysql-3.23.51.tar.gz, I
get the following error executing the make command:
"my_gethostbyname.c", line 81.5: 1506-068 (S)
Operation between types "struct
MySql Front, http://www.anse.de/mysqlfront/, is a win32 GUI for admin and
data entry.
Yes, you can use html and some web programming to communicate with MySQL.
-Original Message-
From: William Bradley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 8:13 AM
To: Mysql
Subject: Dat
William R. Mussatto wrote:
>On Wed, 24 Jul 2002, Dermot Paikkos wrote:
>
>>Date: Wed, 24 Jul 2002 17:46:00 +0100
>>From: Dermot Paikkos <[EMAIL PROTECTED]>
>>To: [EMAIL PROTECTED]
>>Subject: how to update time field with current time?
>>
>>Hi
>>Probably a silly question but how can I set a tim
> am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
> characters of language such as hebrew/arabic?
My best suggestion would be to store all your test in Unicode UTF-8 format
and use the type BLOB in the table in order to store it. We do this
and can quite happily mix
Mysql is not working. I get an error pop up which says: Winmysqladmin 1.3.
: Error reading Memo2 -> Lines.Strings: The parameter is incorrect.
I get this message at startup and when I try to open winmysqladmin.exe.
Before I restarted the computer everything was fine.
Help anyone???
--
I've been running MySQL for 2 years with no problems. Yesterday, I
increased the max_connections because I was getting "too many connections"
error. This morning, the server again reached its limit but it never
seemed to recover from it and constantly gave the "too many connections"
error. I
Hi,
I just downloaded the binaries. I have followed the installation
instructions. Have run the command "mysqld-max-nt --install-manual " and
checked the service panel and MySql is installed as a service. However when
I either try to start the service in the service panel or issue the command
"ne
Subject: *FREE* slides of an upcoming web presendation : MVC+ STANDARD tags
From: "Vic C." <[EMAIL PROTECTED]>
===
Open source SQL web app:
In order to facilitate discussion of the live web presentation (coming
up in less than 24 hours) you can download the slides before the
presentation; I ha
It's not uncommon to run multiple MySQL servers on a given Unix system.
I'm wondering: Does anyone do this on Windows, and if so, what particular
configuration issues did you have to solve to keep them from interfering
with each other?
-
I have a product for which I would like to use mySql to hold information
used in a product demonstration. The product runs on Windows, HP, Solaris
and AIX. The demonstration (and the mySql database) will be distributed
with the product.
I am trying to determine the correct binary distribution of
Hi,
is it possible to change the default string quoting chars ('")?
I'm using MySQL with an older shop solution. The data to write has
both: ' and " chararcters. It isn't possible to escape those
chars. Therefor I have to change the quoting char to a char
that isn't used i.e "#".
Is it possible
because I have a cobalt server and the only version that they suggest are
the 3.23.36 an 37, this is the reason about I don't wish re-install another
version if I can.
anyway thanks for its aid.
sandra
- Original Message -
From: "Ralf Narozny" <[EMAIL PROTECTED]>
To: "SandraR" <[EMAIL PR
Hi,
On my application's setup.php I have quite simple MySQL queries like
DROP TABLE IF EXISTS `ee_test`
Now, some users (perhaps 5 out of 1000) complain that they get an SQL error
on the first query with backquotes, and when I provided them with a setup
file without any backquotes (luckily al
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support
]
>Synopsis:
>Severity: <[ non-
Hello!
Simon Green wrote:
>What I am trying to do in MySQL.
>
>Table1
>
>UserID ProductID Old_UserID
>1 2 4
>2 3 5
>
>Table2
>UserID ProductID
>4 Null
>5 Null
>
>Table1 has new correct data.
>Table2 has old incorrect data.
>The link i
Hi, I have a problem where the index for a SET column does not get used
once I link in another table.
The output to explain:
mysql> explain select count(*) from NS_articles where
find_in_set('approved', artFlags) > 0;
+-+---+---+--+-+--+--+
Francisco,
Thursday, July 25, 2002, 2:46:39 AM, you wrote:
FR> When I try to execute scripts/mysql_install_db, I get
FR> some errors about some libraries missing:
FR> exec(): 0509-036 Cannot load program
FR> ./bin/my_print_defaults because of the following
FR> errors:
FR> 0509-150 Dependent mo
Mysql engine is running under win98, then at the prompt I type mysql mysql then press
enter and I have control. I can delete users (root included), whatever I want, so How
can I make Mysql always require a username and a password to connect to it?
Alex
Hi
I have be scratching my head with this for a few days.
I want to select data from 2 tables conditionally. 1 table has users,
the other times relating to the users. I want to create a query that
will select the user from the users table and if they have any time
data against them (for that
I had this problem.
For some reason MySQL has decided to look at your tmp directory (which
contains vi.recover) instead of your data directory. Compiling
with -DHAVE_BROKEN_REALPATH fixed it for me, on FreeBSD 4.6, linuxthreads
and dual CPU.
--Mike
- Original Message -
From: "Dicky Wahy
Hi
I am storing a list of titles on a mysql db. Some of the records start
with 'The','A' or 'An'. I would like to be able to enter the title in
the form 'The Count .' instead of 'Count ..., The' and have the
record stored as 'Count ' but displayed as 'The Count ...' when I
display it.
Hi.
On Thu 2002-07-25 at 10:41:54 +0200, [EMAIL PROTECTED] wrote:
[...]
> >>
> >>Personally I find the former much easier to read though not sure about
> >>the practical differences between them when the statements are executed.
> >
> >AFAICT, there should be no differences on execution speed.
>
Hello everybody,
someone can tell me the best FS to run MyISAM along with InnoDB tables ?
SQL - For you-know-who
--
João Paulo Vasconcellos
Gerente de Tecnologia - NetCard
Tel. 21 3852-9008 Ramal 31
[EMAIL PROTECTED]
-
Be
At the moment I have Mysql installed and understand command line entry
of data, or entry via a text file. Either way, it is difficult,
especially if you have been used to data entry screens. Is there a
utility somewhere that would allow me to do this? Failing that, is it
possible to write a html f
Hello,
What you say below is of great interest to me. Currently I have been
writing front end code to handle the size
issue but I would like to be open to other possibilities. So my question
about your answer below is:
Just how does the developer obtain the error condition from Mysql when an
i
I'm looking for a script that will fill mysql tables with sample data so we can
see how our web pages look with data in them. Does anyone know of any? I've
written one in perl but I would like to see how someone else did it.
thanks,
Peter
Renato,
Thursday, July 25, 2002, 2:35:56 PM, you wrote:
RL> in the redhat instalation procedure. And I did that for all servers, but
RL> only this one has this behaviour.
Run
safe_mysqld --timezone=America/Manaus &
and show me the output of
SHOW VARIABLES LIKE 'timezone'
RL> Egor Egoro
SandraR,
Thursday, July 25, 2002, 2:54:39 PM, you wrote:
S> ok but I haven't a install folder as MySQLversion because the version that I
S> have instaled is binary and the software are by all sides (/usr/bin and
S> /var/lib) and in this folder I haven't a configure file.
S> ¿what can I do? I don
Hello Martin,
Thursday, July 25, 2002, 4:48:03 PM, you wrote:
Please, send your questions/answers to the mailing list, not to me.
>> MP> But when I do it I get:
>> MP> ERROR 1034: sort_buffer_size is to small
>> Hm..
>>
>> Error 1034 means:
>> "Incorrect key file for table ..."
>>
>> not a "so
Ashwin,
Wednesday, July 24, 2002, 3:15:25 PM, you wrote:
AK> I have a table with a field full of urls.. what I need to do is to append
AK> to those urls with a new url, so for example, if the field had
AK> http://www.yahoo.com i want to make it
AK> http://www.myserver.com/login?url=http://www.yah
hi guys,
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
characters of language such as hebrew/arabic?
thanks for help
sql
--
Hytham Shehab
-
Before posting, please check:
http://www.mysql.
Hi,
I would like to get the Chech complex character set.
Where can I find it?
Thanks,
Daniel
SQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
How about downloading the source of a newer version???
If you are too lazy to search for the URL:
http://www.mysql.com/downloads/index.html
SandraR wrote:
>ok but I haven't a install folder as MySQLversion because the version that I
>have instaled is binary and the software are by all sides (/
I have a product for which I would like to use mySql to hold information
used in a product demonstration. The product runs on Windows, HP, Solaris
and AIX. The demonstration (and the mySql database) will be distributed
with the product.
I am trying to determine the correct binary distribution of
Hi,
> MP> But when I do it I get:
> MP> ERROR 1034: sort_buffer_size is to small
> Hm..
>
> Error 1034 means:
> "Incorrect key file for table ..."
>
> not a "sort_buffer_size is to small"
>
> How did you installed the server?
I compiled it from the source files.
sql
--
Martin Pavlas
Pwrgen
Hello
I am trying to install mysql on macosx and in the INSTALL-BINARY
file it says
shell> groupadd mysql
shell> useradd -g mysql mysql
These commands are not available under MacOS X
Regards
--
Dave Houghton [EMAIL PROTECTED]
System Manager
Use LIKE '%%'
At least this works for Oracle
-Original Message-
From: David Durham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 3:39 PM
To: [EMAIL PROTECTED]
Subject: SQL Syntax (May be OT)
If this question is off topic, please let me know.
I have a description field with
Hello!
David Durham wrote:
> If this question is off topic, please let me know.
>
> I have a description field with a set of keywords. I need to update
> some data based on a keyword, which is randomly placed in the field.
> Can someone please help with a SQL syntax to find the word within th
ok but I haven't a install folder as MySQLversion because the version that I
have instaled is binary and the software are by all sides (/usr/bin and
/var/lib) and in this folder I haven't a configure file.
¿what can I do? I don´t want install another version if it was possible.
thanks.
sandraR
in the redhat instalation procedure. And I did that for all servers, but
only this one has this behaviour.
Egor Egorov wrote:
>Renato,
>Tuesday, July 23, 2002, 9:40:35 PM, you wrote:
>
>RL> I have several mysql servers installed, all without TZ variable, one of
>RL> them, insists in set the "s
Try
SELECT tableA.*
FROM tableA
WHERE NOT EXISTS (select * from tableA, tableB, tableC where tableA.id <>
tableB.idA
and tableA.id <> tableC.idA)
-Original Message-
From: Ralf Narozny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 2:46 PM
To: Guilherme
Cc: [EMAIL PROT
Desmond,
Thursday, July 25, 2002, 2:42:31 AM, you wrote:
DL> Mysql documentation says the following:
DL> "values are stored using only as many characters as are needed, plus one
DL> byte to record the length. Values are not padded; instead, trailing spaces
DL> are removed when values are store
Guilherme,
Thursday, July 25, 2002, 4:18:13 AM, you wrote:
G> I have 3 tables tableA, tableB and tableC and the fields tableA.id,
G> tableB.idA and tableC.idA.
G> I'm using this query (bellow) to call information from the database that has
G> in tableA but tableA.id is not found on tableB.idA and
Hytham,
Thursday, July 25, 2002, 12:54:22 AM, you wrote:
HS> am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
HS> characters of language such as hebrew/arabic?
MySQL returns char strings as they were inserted. For correct sorting
you can set up hebrew character set sta
If this question is off topic, please let me know.
I have a description field with a set of keywords. I need to update some
data based on a keyword, which is randomly placed in the field. Can
someone please help with a SQL syntax to find the word within the field.
Thanks in anticipation.
-Da
What I am trying to do in MySQL.
Table1
UserID ProductID Old_UserID
1 2 4
2 3 5
Table2
UserID ProductID
4 Null
5 Null
Table1 has new correct data.
Table2 has old incorrect data.
The link is Table2.UserID and Old_UserID
What I
Hytham Shehab wrote:
>hi guys,
>am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
>characters of language such as hebrew/arabic?
>
>thanks for help
>
>sql
>--
>Hytham Shehab
>
>
>
>
>-
>Before posting, p
Hello!
Barnali wrote:
>If you are NOT installing as root, you are trying to create mysql.sock in an area
>where
>you don't have write permission.
>what is the --prefix you supplied to ./configure ?
>
I'd say install as root, change owner and group of the mysql
directories, remove /tmp/mysql.s
Guilherme wrote:
>I have 3 tables tableA, tableB and tableC and the fields tableA.id,
>tableB.idA and tableC.idA.
>I'm using this query (bellow) to call information from the database that has
>in tableA but tableA.id is not found on tableB.idA and tableC.idA.
>
>SELECT tableA.*
> FROM tableA
Emma Grant wrote:
>Hi,
>
>Does anyone know how to separate values in a text area field, to enter
>the separated values into a database?
>
>For instance if enter these values into a text area field
>
>Dogs
>Cats
>Fish
>
>I want to be able to take Dogs, Cats and Fish and put them in different
>
Hello!
Desmond Lee wrote:
> Hello there
>
>
> Mysql documentation says the following:
>
> "values are stored using only as many characters as are needed, plus
> one byte to record the length. Values are not padded; instead,
> trailing spaces are removed when values are stored."
>
>
> So, then
Benjamin Pflugmann wrote:
>Hi.
>
>On Wed 2002-07-24 at 09:46:03 +0100, [EMAIL PROTECTED] wrote:
>
>
>
>>As I understand it an ANSI92 join is written as;
>>
>>SELECT b.columnA
>>FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id
>>
>>
>
>Ah. Okay. Was not aware that this was new in ANSI92
"Dave Dutcher" <[EMAIL PROTECTED]> wrote on 24.07.2002 21:35:03:
>
>Hi, I did some more research on my problem. (Sorry for not doing it before
>I posted the other message), and I think perhaps my question could be
>summarized into the following.
>
>Can I use an index to speed up a select max() o
Renato,
Tuesday, July 23, 2002, 9:40:35 PM, you wrote:
RL> I have several mysql servers installed, all without TZ variable, one of
RL> them, insists in set the "select now()" to 4 hours ahead of my internal
RL> clock, first I touch that I should set TZ to my time time zone in
RL> /etc/init.d/m
Richard,
Tuesday, July 23, 2002, 3:56:36 PM, you wrote:
RM> What instances can cause a Table to crash?
RM> Is this caused by a bug in itself, a power failure, or something else?
It may be a bug in MySQL, hardware errors, abnormal shutdown, running
myisamchk, when mysqld is running ...
Some of
Martin,
Tuesday, July 23, 2002, 10:29:13 AM, you wrote:
MP> I'm running a MySQL server v 3.23.39 on Linux Debian. The server has 500
MP> MB RAM. I have a table called "sender" with 18 columns (only integers
MP> and varchars, no blobs) and with 3 indexes. The table has about 15000
MP> records.
Tam,
Tuesday, July 23, 2002, 9:38:17 PM, you wrote:
T> Hi Victoria,
T>Do you know when the 4.0.2a-MAX would be available for download then?
T> Thank you.
Use mysql-win-4.0.2-alpha.zip instead. It the same as with -max.
--
For technical support contracts, goto https://order.mysql.com/?r
chuck,
Wednesday, July 24, 2002, 11:33:21 AM, you wrote:
ca> Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any
ca> issues that should be addressed ie uninstall v3 prior to installing v4
ca> or can i just install over v3.
ca> Any suggested sites' ,FAQ regarding my questio
SandraR,
Tuesday, July 23, 2002, 6:04:42 PM, you wrote:
S> I need re-compiling mysql 3.23.37 in linux, how can I do this.
S> In the maestrosdelweb link said how is the compilation, the problem is that
S> these commands (./config and make) are not available from my install
S> folders. I have not a
If you are NOT installing as root, you are trying to create mysql.sock in an area where
you don't have write permission.
what is the --prefix you supplied to ./configure ?
-Original Message-
From: Manisha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 12:18 PM
To: [EMAIL PROTECT
Pada Thu, 25 Jul 2002 09:28:45 +0200
Simas Cepaitis <[EMAIL PROTECTED]> menulis :
> Hello,
>
> Earlier i posted my message here, but haven't got any real solution.
> So now I'll try to post with some more details. I have a FreeBSD 4.6
> box, dual cpu, runing MySQL. It runs with linuxthreads
Thanx to all those how answered:
hcir
walt
William Mussatto
David Yahoo
The answer was now() or
update tab_name set fd_name = (now()) where_expr;
I had tried this but was missing a pair of brackets (honest..)
MYSQL
dp.
~~
Dermot Paikkos * [EMAIL PROTECTED]
Network Administrator @ Science Photo L
I have tried to install mysql, but there is something wrong...
When I start up my computer I get this error-message in a pop-up with a
'winmysqladmin.exe'-header: Error
reading Memo2 -> Lines.Strings: The parameter is incorrect.
Does anybody know what this means, and what I can do to make mysql
Hello,
Earlier i posted my message here, but haven't got any real solution.
So now I'll try to post with some more details. I have a FreeBSD 4.6
box, dual cpu, runing MySQL. It runs with linuxthreads enabled
and it is under heavy load all the time. Few weeks ago it started
to work a little
74 matches
Mail list logo