HI ALL
I study mysql, and I want to trace the source code.
Are there any documents that describe the data structure
and the relationships between function in MySQL?
Many thanks!
-
Before posting, please check:
http://www
I've been trying to figure this out for ages. I've compiled mysql with
the following options:
./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-user=mysq
l --with-comment --without-readline "$@"
and the compile goes just fine. Then I do make test (as one is want to do)
and i
I think a good soluthion it is to do a table for every thing and use MERGE
table for searching data in all the table (for MERGE see documentation at
pag. 271 "MySql table Type" chapter).
Il 16:24, mercoledì 14 marzo 2001, abdelhamid bettache scrisse:
> I want to ask you :
> 1- How many rows
I have to store data for Internet desining (10-20 Gb at Day)
so I have to use a data base very fast: MySql is fast?
I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb
(I know that reading manual of Mysql).
How to do a table so big?
Thank you in advance, Rino.
If I order a table using myiasmchk then, when I put other row in the table,
this thable is still ordered or I have to reorder again?
Thank you in advance,Mario.
-
Before posting, please check:
http://www.mysql.com/manual.php
Thanks for help .,
I tried it but also got the same error
any other advice
"Gerald L. Clark" wrote:
>
> Run isamchk on your tables.
>
> mohamed Abd El-Samei Mohamed wrote:
> >
> > Dear all i need help
> > i have mysql-3.22.26a over unix solairs 7
> > when i try to apply query from the consol
On 14.03.2001 22:33:13 Charles L Hagen wrote:
> Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it
> seems limited.
>
> Is there an HTML GUI for MySQL?
phpMyAdmin - see freshmeat
-
Before posting, pleas
Hi, alexander.skwar,
Mysql has the type as the MSSQL BIT???
Regards,
Sunrise
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
I got a problem.. im using mySQL the newest release on a redhat 7.x for the server..
And im doing some programming.. on a win2k pro with delphi 5.0 ent ed. and im using
the myODBC driver in windows to connect to the db.
Tho when the db is empty
[mailboxes]
mailbox char 50
fullnamechar
Hello Heikki,
Finally I was able to check the innobase tables included into mysql
3.23.34. Well first several times I was quite happy about them, but
later understud that this is because option --create-options is
broken :)
So now I must say On my system innobase seems to work as bad
Hello
I'm run a family/pedigree database with about 250.000 records of dogs.
The dogs are mostly (to 90%) searched by name.
To find similar records I have my own 'soundex' colums wich is searched
and ofcourse indexed.
table dog
id int4(indexed)
name varchar
soundex varchar (i
On Thu, Mar 15, 2001 at 09:54:18AM +0100, Mario Latens wrote:
> If I order a table using myiasmchk then, when I put other row in the table,
> this thable is still ordered or I have to reorder again?
You'll need to reorder again.
Ordering with myisamchk is meant to increase performance, not to o
Hi
I run a database using mysql 2.23 by a webspace provider.
I would like to keep a 1to1 mirror of it at home.
Unluckiely I have no shell/ftp access to the tables directory.
The database-dump (with php) is far too big to download it every day.
- Any ideas how to backup it?
- I'm dreaming o
Hi!
> "Gary" == Gary Shea <[EMAIL PROTECTED]> writes:
Gary> Today, Sinisa Milivojevic ([EMAIL PROTECTED]) wrote:
>> [EMAIL PROTECTED] writes:
>> > >Description:
>> >
>> > It appears that if a column generated by a select is
>> > a sum of variables generated in other columns of the
>
On Tue, Mar 13, 2001 at 04:18:41PM +0100, Alessandro de Manzano wrote:
> I'm planning to deploy MySQL for a project of my company but I've some
> concern about real size limit of BLOBs.
>
> I read on Paul DuBois' excellent book that longblob are 2^32-1 wide,
> but actually the communication _prot
Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect
Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for user:
'root@ipaddress' (Using password: YES)
On 15.03.2001 10:23:19 Sunrise wrote:
> Hi, alexander.skwar,
>
> Mysql has the type as the MSSQL BIT???
Pardon me? What do you mean?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
On Thu, 15 Mar 2001, Eric Holmbom wrote:
> Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect
> Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for
>user: 'root@ipaddress' (Using password: YES)
It is saying (quite straightforwardly) that you either
a)
Hi
I am trying to right a program to monitor mysql remotely (on the same
network). It's so if there is any problem I can go over to using the slave.
What is the best way of doing this?
Thanks Simon
-
Before posting, please check
Hello,
I have just had a little problem with a SELECT query like this:
SELECT DATE_FORMAT(Day,"%e.%m.%Y") AS ftag,* from TheTable;
this query returns an SQL error: ERROR 1064: You have an error in your
SQL syntax near '* from TheTable' at line 1
BUT:
SELECT *,DATE_FORMAT(Day,"%e.%m.%Y") AS ft
On 15.03.2001 11:10:24 Eric Holmbom wrote:
> Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect
> Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied
for
> user: 'root@ipaddress' (Using password: YES)
Wrong password, I'd say.
---
dear simon
hello
try mysqlman its the best tool to manage database remotely
naveed
- Original Message -
From: Simon Green <[EMAIL PROTECTED]>
To: Mysql <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 4:50 PM
Subject: Monitoring Database
> Hi
> I am trying to right a program to monito
I am experiencing problems with record locking on database updates.
When I use an Access update query to modify a record subsequent updates
to the same records result an Access 97 message stating that the record
is in use by another user. This happens if I am the sole user of the
database. It wou
Hi,
I tried to build from source the latest MySQL 3.23.34a and I found the
following problems:
1) The Makefile in the 'pars' and 'mem' directory have missing ../include/
paths on some dependencies.
2) In the 'mem' directory, the file mem0mem.c tries to include mem0dbg.c,
but I think this should
naveed wrote:
> dear simon
> hello
> try mysqlman its the best tool to manage database remotely
>
> naveed
> - Original Message -
> From: Simon Green <[EMAIL PROTECTED]>
> To: Mysql <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 4:50 PM
> Subject: Monitoring Database
>
> > Hi
> > I
BigBrother (www.bb4.com) has a plugin for MySQL. It monitors the IP port of
the mysqlserver and sends you a message when it is down (or start a script
and do wahtever you want e.g. start up the slave).
Hugo Burm
[EMAIL PROTECTED]
> -Original MessageH-
> From: Simon Green [mailto:[EMAIL
Hi,
How do I put two or more hosts in a single user row? I have all them at
'localhost' but I'd like to set it to something like
'localhost,machine.domain.tld,machine2.domain.tld' without having to
repeat the line since I've got to manage a *bunch* of users.
Thanks...
--
Hi Greg,
If you are speaking about show tables returns blank lines, than thank you
very much and I hope you will find it! Please, keep us on track!
Best regards,
Lumberer.
On Mon, Mar 12, 2001 at 09:57:28PM +, Greg Cope wrote:
> The following C and CXX flags will work (/usr/local/bin/gcc i
Martyn Perring writes:
> Hi,
>
> Can anyone shed any light on this?
>
> I'm trying to build mySQL V3.23.34a on Tru64 V4.0G using gcc2.95.2 and
> GNU Make version 3.79.1.
>
> The makefiles were created using ./configure --prefix=/nipweb/mysql. No
> other configure paramaters were used
Hi there,
i received the following message:
[TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server
(#1130)
any ideas
regards
denis
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
Hi,
I have a table:
CREATE TABLE http_refer(
rid int unsigned auto_increment,
refer varchar(255),
unique index(rid),
unique index(refer)
);
It is filled with referrers from our webserver log and has 4138 rows.
Today I've tried to execute:
mysql> select ma
I have been told you offer a service to convert ASP scripts that connect to
an access database to a mySQL database.
If this is the case could you send me the URL of this resource.
Many Thanks
Paris.
--
Paris Val Baker
E-mai
I failed to mention that I used the RedHat Source RPM and I am using RedHat
6.2.
Rick
-Original Message-
From: Mehalick, Richard RE SSI-GRAX
Sent: Thursday, March 15, 2001 6:10 AM
To: 'Heikki Tuuri'
Cc: '[EMAIL PROTECTED]'
Subject: Innobase compile problems
Hi,
I tried to build from
Hi all,
I'm having problems getting reasonable speed
queries from a simple table.
First, a little info about my server
setup:
From mysqladmin version:
mysqladmin Ver 7.11 Distrib 3.22.27, for
-free
I had two questions about table design and format.
I'm designing an application that has two tables.
The first table will have
-Many selects that return about 20 results on average.
-Few inserts
-Very few UPDATEs
For this table it is not important that the newest inserts show up in selects
im
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello Heikki,
Peter> Finally I was able to check the innobase tables included into mysql
Peter> 3.23.34. Well first several times I was quite happy about them, but
Peter> later understud that this is because option --c
hi
i am installing My Sql on Linux 7
i was trying it for the whole day..the only problem i
am facing since morning is that..
the SQL server starts during the booting of system
when i go in bin and give mysqladmin command it gives
error - Can't connect to server..
either the server is not running o
Yes, make sure you shutdown the server before running isamchk.
mohamed Abd El-Samei Mohamed wrote:
>
> Thanks for help .,
> I tried it but also got the same error
>
> any other advice
>
> "Gerald L. Clark" wrote:
> >
> > Run isamchk on your tables.
> >
> > mohamed Abd El-Samei Mohamed wrote:
>
On Fri, Mar 16, 2001 at 12:32:37AM +1030, Dan Makovec wrote:
> Hi all,
>
> I'm having problems getting reasonable speed queries from a simple table.
>
...
> I've created a simple table that contains stock exchange data, as follows:
>
> CREATE TABLE shares (
> date date DEFAULT '-00-00' NO
I am porting my accounting app. from Foxpro for DOS to
linux->perl->MySQL. I don't want to completely reinvent the wheel. I
am sure many a program has been written to do book keeping ( debit cash,
credit revenue, etc. ) Does any one know where I can get an idea about
how to code it and table de
>Description:
Compiling Mysql for aix. I receive an error saying char size is 0, I noticed
that another file is looked up and it is not present. "conftestval"
>How-To-Repeat:
I have set my c compiler and c++ compiler to gcc, then entered the following,
you shou
You did not tell us what hardware and MySQL version you are using.
There is no Linux 7.
If you are refering to RedHat Linux Version 7.0, and you installed the
mysql found on the CD, then you have 3 choices.
1. chown -R mysql /var/lib/mysql
If the mysql data directories are not in /var/lib/my
Did you read chapter 6 in the manual?
denis mettler wrote:
>
> Hi there,
>
> i received the following message:
>
> [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server
> (#1130)
>
> any ideas
>
> regards
> denis
>
>
No, it should not be.
Eric Morgan wrote:
>
> Yes, The prefix path I used below is the path to the source
> distribution. Should it not be?
>
> Eric
>
> Mohamad Ilhami wrote:
> >
> > On Wed, 14 Mar 2001, Eric Morgan wrote:
> >
> > > I configured and compiled mysql-3.23.34a without even a warni
Hello,
i´m trying to connect to mysql server from php but i can´t do it.
i created the databases successfully!!
i put :
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/juan/index.php
what happend? all look
>
>
>
>
> And I've filled this with a bit of data. Well, more than a bit - 5,791,651 rows
>actually. Still, while this is large, it doesn't seem rediculously huge.
>
> Let's say I want to perform a query
Rick,
>I tried to build from source the latest MySQL 3.23.34a and I found the
>following problems:
>
>1) The Makefile in the 'pars' and 'mem' directory have missing ../include/
>paths on some dependencies.
Do you mean that when you compile, on the compiler line there is not the
flag -I../include
Peter,
could you ftp your binary (compiled with -g option) to
support.mysql.com directory /pub/mysql/Incoming
I can then try to run the ATIS test on your binary on our SMP Linux.
One possible reason for the errors you get is that your version
of GCC is buggy in inlining of code, but that is only
Hi
I have a long-running select that's basicly just summing a couple of columns
in a 1-2GB big table.
It lasts for 5-10 hours and I notice that the disc activity is *very* high:
vmstat 1 says:
5 0 0 30332 3068 5240 129260 0 0 10260 658 498 63 35 3
4 0 0 30332 3192 5244 129132
Yes, there are a couple of methods such as mysqlimport. Please read the
manual for the others.
- Original Message -
From: "WANG_KING£¨Íõ¸Ö£©" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 10:30
Subject: Data tool
> I want to load data to mysql.
>
> Does mys
Dear Sir :
MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
a simple C API program which catched from MySQL tutorial, it
chokes at the end of compile process . The program is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_pa
Hi Mario,
I think I had the same problem as you, and got som help...
You have three ways of doing this:
1. Switch to a FileSystem that supports bigger Files
2. Use MERGE, create a lot of small tables and use MERGE
in you select Querys, The manual is quit god at explaining
how to do this, but I'll
> I want to ask you :
> 1- How many rows does a mysql table can hold?
> 2- I have to design a database for all universities of my country , Is it
> better to consider one database for each university or one database for
all
> universities . Note that a query on a table "student" would be more qui
All,
>I've got a quick question - In section 7.11 of the manual on
>Optimize_Table it states that the table is "locked" during
>optimization. It does not state however, if this is a
>read-lock, a write-lock or both. Can you clarify?
>
>Thanks
Since I'm not a member of this list, could any
resp
Hi
I am using Resin1.2.3 engine to run my servlet and
mysql database with mysql-jdbc driver to connect my
servlet with database but it gives me null pointer
exception when I run my servlet
500 servlet exception
java.lang.NullPointerException
I hope many of you might have face t
Hi , i have the following method:
public Object getValueAt(int row, int column){
// in here i want to construct a SQL query which gives the object at a
certain
row and column
}
Do you know how to do it?
Thanks
Pawan
-
Befor
Okay, the Access 97 vs. Access 2000 might have something to do with my
particular problem now. I will check it using Access 97 later today. I
know for a fact, however, that when I first found this problem, I was
using Access 97 and the only thing that I changed was the MySQL version.
I supp
In the last episode (Mar 15), Mark Dombeck, Ph.D. said:
> All,
>
> >I've got a quick question - In section 7.11 of the manual on
> >Optimize_Table it states that the table is "locked" during
> >optimization. It does not state however, if this is a
> >read-lock, a write-lock or both. Can you cla
Anyone know of a Source control system implemented in MySQL?
C. Duncan Hudson
Dynax Solutions, Inc.
Tel 216.292.8203
FAX 216.292.8273
EMail [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/man
>Description:
Performing a "mysqldump --all-databases --opt" produces invalid
SQL for the "db" table i.e.:
KEY User(User)
Attempting to rebuild tables with the mysql client using this SQL fails
with a syntax error.
If the SQL is modified to:
KEY User (User)
then the mysql
I see. I added the timestamp field (I never knew there was a field type
of timestamp), relinked the table in Access 2000 and the darn thing
actually worked! Did this just become a requirement in MySQL 3.23? As I
mentioned in a previous post, the timestamp field was not required when I
was w
Pawan Kanda wrote:
>
> Hi , i have the following method:
>
> public Object getValueAt(int row, int column){
> // in here i want to construct a SQL query which gives the object at a
> certain
> row and column
> }
>
> Do you know how to do it?
>
> Thanks
> Pawan
>
Maybe make your sql statemen
I'm having a problem with REGEXP :
I have several rows that look like this :
Health : health services : safety : physical abuse : women
Health : health services : safety : rescue
Health : health services : safety : sexual abuse
Health : health services : safety : sexual abuse : children
Health :
Does someone has an answer for this already done question ??
- Original Message -
From: "Jason Bell" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 5:58 PM
Subject: Postgres to MySQL Migration
> Anyone know an easy way to migrate a Database from P
Is like that much faster than =? If so, this would be a good thing to know. I'm
assuming that not putting a % either before or after the variable would make it the
equivilent of an =.
Can you possibly point me somewhere that explains this a bit or possibly gives some
kind of benchmarks?
Tha
I encountered a few problems with the genuine 1.7.8-1 binary RPM for
mysql++.
- If I compile:
Connection con("temp","localhost","root","temp",3306,0,60,1,"",0);
The linker complains: undefined reference to `MysqlConnection::MysqlConnection(char
const *, char const *, char const *, char con
Hi,
I would like to tune the performance of my database.
The database is rather small about 80 MB altogether. (with 20 Mb indexes)
The most complex selections open 32 tables at ones.
The database is mostly readonly (99%).
What settings show I use to maximize the speed of the queries?
What would
join
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PRO
I cant seem to find system requirements anywhere for MySQL, even inside the hundreds
of pages of the manual... I wish to run the latest stable release on MySQL on a
Windows NT Workstation PC, and will also use this PC to run ColdFusion Professional
4.5 server. Where could I find recommended
Does anybody know if this amount of memory usage is normal? (taken from *top*)
PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND
677 root 90 19228 0 18M 15801S 0.0
2.1 0:07 mysqld
679 root 9
I never found an answer. I plan to write a PHP page to help automate this, and
expect to have it done soon, time permitting.
--Jason Bell
Yurais Fernández Leal wrote:
> Does someone has an answer for this already done question ??
>
> - Original Message -
> From: "Jason Bell" <[EMAIL PRO
Cold Fusion 4.5 Server is a hog. If you can run that you probably have
enough memory for MySQL. I would not run them simultaneously with less
than 384 MB ram.
Charles Hagen
On Thu, 15 Mar 2001, Chris Peterson wrote:
> I cant seem to find system requirements anywhere for MySQL, even inside the
I saw that someone already gave you some suggestions, but the reply seemed
to lack a bit of WHY you have that limitation, so I thought I would explain.
The 2Gb limitation is not in MySQL. It's in your operating system. If you
read some of your OS's docs, you can see how to get around this probl
Hi,
I have to mananage a very big table (about 20 Go)
A database correspond to a directory.
A table correspond to a file.
Is it possible to distribute the table on several physical partition (like
with Oracle that can use several table space to store one table) ?
Thanks,
--
Pascal Thivent
Friends.
people out in here are very afraid , when they hear Mysql does not support foreign
keys.
It really become difficult , why foreign keys are not enforced by mysql.
Anyways, can u please tell me does our favourite database support composite primary
keys as in Acess databse key...?
U se
MySQLGui is a good option in graphical mode, there are other command line
clients too
At 19.40 14/3/01 +0100, you wrote:
>can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on
>win nt ?
>thank you in advance.
>regards.
>
>Andrea GIGLIOTTI
>
>G&B Net S.n.c.
>Via Bagni Caldi,
I seem to remember that Microsoft SQL Server has the concept of a "covered index" that
worked something like this:
Suppose you have a table with a product_category, and a price. You query alot on
product_category, so you create an index on it. You're expression might look like
this:
select
Please see my comments below.
>Do you mean that when you compile, on the compiler line >there is not the
>flag -I../include?
No, not really. I mean in the dependencies for a target.
>If the flag is missing, there obviously is something >wrong with our
Makefile.am's or configure.in's. You >prob
Sunrise wrote:
>
> Hi, alexander.skwar,
>
> Mysql has the type as the MSSQL BIT???
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
Yes and this is documented in manual.
--
MySQL Development Team
For some reason I cannot figure, mysqld is now leaving loads
of SQL.ISD/ISM files in /tmp/ .. perhaps 10 a minute..
there are no errors reported in the mysqld log file, other
than one or two connection aborted every hour.
the files are all owned by root, group root.
/tmp is rwx word with t bi
Rick,
have you downloaded version 3.23.34 and not 3.23.34a?
I downloaded 3.23.34a, untarred it, and mem0dbg.c was in innobase/mem
directory.
I have attached to this email a copy of mem0dbg.c.
Are your Makefile's such that they did not build all the
object files and libraries needed for linking
So sprach Tõnu Samuel am Thu, Mar 15, 2001 at 09:01:58PM +0200:
> Sunrise wrote:
> > Mysql has the type as the MSSQL BIT???
>
> Yes and this is documented in manual.
Hi Tõnu (geez, "strange" name you have - can't even paste it :])
Well, since you understood that question of sunrise - could you
- Original Message -
From: walkiriocosta
To: Sérgio floripa
Cc: adrianovarig ; berg ; beto
; emilson ; fenix ; jacira ; junior ; marcelao ; vagno ; zeus
Sent: Sunday, March 11, 2001 6:43 PM
Subject: En:Fw: [BQ75] Fwd: Re: LER COM URGÊNCIA (fwd)
E-mail grátis BOL com antivírus! Fa
Hi,
While searching the net I came across some perl to get enum values from
a table column, but I can't get it to work due to my lack of
understanding of what is going on, I am not even sure I have read the
data correctly.
my $sth = $dbh->prepare("SELECT $column FROM $sqlTable");
$sth
I downloaded the 34a version (if the RedHat SRPM on the MySQL site is also
34a). I will use the file you gave me and it should compile and link now.
Thanks,
Rick
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 1:12 PM
To: Mehalick, Richar
Does MySQL allow either user or group quotas to be enforced per
database?
Thanks,
Jose
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I have been getting this error quite a bit, and
keep losing my access to the database from my
persistent connection, it seems... any idea where
I should be looking to solve the problem?
Mysql 3.23.34 on Solaris 2.7
Error is:
010315 10:41:55 Aborted connection 27 to db: 'events' user: 'webde
I get the subject error when running the static or semi-static linux builds on
Mandrake 7.2. My database is working fine and I am able to use another client,
KMySQLAdmin, without problems.
Cal
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you
I have 2 tables with a common field of Title.
Table 1 defined as:
Name;varchar(60)
Title;varchar(60)
Year;varchar(4)
Other;varchar(30)
Other2;varchar(30)
act_no;int(8) unsigned zerofill
Table 2 defined as:
MM;varchar(4)
Title;varchar(48)
Archive;varchar(4)
record_num;int(8) unsigned zerofill
I
Your two Title fields are not the same size.
This could prevent a match.
It will slow down joins in 3.22.
Carl Schrader wrote:
>
> I have 2 tables with a common field of Title.
>
> Table 1 defined as:
> Name;varchar(60)
> Title;varchar(60)
> Year;varchar(4)
> Other;varchar(30)
> Other2;varchar(
Can someone tell me how to insert an selct back a directory into mysql using sql? I'm
trying to insert and reselect
c:\My Documents into a varchar field and I keep having a problem with the special
character \
Jeff
To whom it may concern:
When running, the /scripts/mysql_install_db, it starts off with preparing
the tables, and then it says it is Installing the tables. That is all it
does, it says the process is running and everything. Does it take a real
long time for it to install the tables? If so how
Somehow, our MySQL server just started giving the error:
Error writing file './mydb/mytable.frm' (Errcode: 28)
whenever I try to create a table using the following:
CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY
AUTO_INCREMENT);
Precisely where can I find the documentati
use \\ combination
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 11:55 PM
Subject: Special Character \
Can someone tell me how to insert an selct back a directory into mysql using
sql? I'm trying to insert and reselect
c:\My Docu
"Olivier, Dave" wrote:
>
> To whom it may concern:
>
> When running, the /scripts/mysql_install_db, it starts off with preparing
> the tables, and then it says it is Installing the tables. That is all it
> does, it says the process is running and everything. Does it take a real
> long time fo
Ken Whitmore wrote:
>
> Somehow, our MySQL server just started giving the error:
> Error writing file './mydb/mytable.frm' (Errcode: 28)
> whenever I try to create a table using the following:
> CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY
> AUTO_INCREMENT);
>
> Preci
Dear Software Manufacturer:
We can help you make it much easier to promote your software on the Internet.
Your company is invited to list its software products at no charge on BigSoftE, the
first Internet Software Search Engine. Launching this month, Bigsofte provides
detailed product informa
The problem with the \\ is that it inserts it into the database as \\ and
when it's retrieved it's a \\
- Original Message -
From: "Michail A.Baikov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 2:08 PM
Subject: Re: Special Character \
Hi there
I have a problem with one mysql table and i don't know how to
solve it .. the table has some important stuff.
when i make a select this is what happens
mysql> select * from imp_addr;
ERROR 1030: Got error 127 from table handler
mysql>
and isamchk
isamchk imp
No it does not.
[EMAIL PROTECTED] wrote:
>
> The problem with the \\ is that it inserts it into the database as \\ and
> when it's retrieved it's a \\
>
> - Original Message -
> From: "Michail A.Baikov" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday
1 - 100 of 130 matches
Mail list logo
