I recently exported a large Access database to MySQL using MyODBC.
It took me a while to figure out that MyODBC was the thing to try, but once I
did tried it, it only took me a few minutes to do the export. I highly
recommend that approach (MyODBC).
-Eric
> Original Message-
Alaios <[EMAIL PROTECTED]> added:
>
> Thx for your interest..
> The type of my question is for learning what to
> choose. I would use what u suggest me.. The only
> information i can provide u is that i am running
> linux..
> If u can suggest me the version of mysql and the
> appropriate function
Thomas Spahni <[EMAIL PROTECTED]> wrote:
> the column type will limit the number of characters per row. A column
> of
> type TEXT will hold up to 65,535 characters but with LONGTEXT you can
> put
> up to 4,294,967,295 charcters into one row. I have an application with
> Texts of up to 200 pages
I've looked in the documentation but didn't see any indication of the limits of
Full-Text Search in terms of how many characters/words it can process per row.
For example, if I have a column with 4,000 character strings in it, can I use
it effectively in Full-Text Searching?
What if the colum
[EMAIL PROTECTED] wrote:
> some command like
> describe all tables
>
> so that i can see structure of all tables in database.
I use a script to do this, if it's a help you are welcome to it:
http://paradigmb.com/describe_MySQL.htm
It produces a html page showing the database structure (all c
I am wondering:
I can see the MySQL data files for my various databases.
What technically prevents me from simply copying those files and using copies
- to move my database to another file structure or server
- to back-up my current db
Yes, I did put my finger in the electrical socket as a kid.
EP wrote:
OK, I need to ask a stupid question.
Obviously, MySQL can run on its own, not quite sure what you really mean
by this though.
Amazing that it wasn't obvious to me, but I originally installed MySQL
after installing Apache, based on home brew instructions that implied a
depen
r"; have I overlooked that it really is
a server by itself?
EP
"asking for a friend, I'm much smarter than this"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. In absence of this kind of technique I was struggling with the idea of
multiple "SELECT FROM's" within a single "INSERT" (is that even possible?)
I'm not sure what you mean here.
Will something like this work (with a correction of syntax which is unknown
to me)?
INSERT INTO webpages(autho
. In absence of this kind of technique I was struggling with the idea of
multiple "SELECT FROM's" within a single "INSERT" (is that even possible?)
I'm not sure what you mean here.
Will something like this work (with a correction of syntax which is unknown
to me)?
INSERT INTO webpages(autho
Paul DuBois wrote:
By the way, you may want to visit http://www.kitebird.com/mysql-cookbook
and grab a copy of the "recipes" distribution.
In net style led me to:
http://www.onlamp.com/pub/a/onlamp/excerpt/mysqlckbk/index2.html?page=1
Much appreciated strategy advice.
Is the Python API menti
is it just me, or do hosts underestimate how much data we might want to put
in a MySQL database? For instance, 250MB, the largest plan from that host
would not come close to holding all my data.
I guess what I'm really curious about: do others construct large (GB)
databases in MySQL? Is there
Struggling to get an INSERT to work, can anyone help?
Here's my scenario:
Students[table]
Student_ID [primary key, auto-increment]
Student_name
Student_sex
Extra_Credit[table]
EC_ID [primary key, auto-increment]
Student_ID
Points
First: INSERT INTO St
Dear all,
I got problem, I want to build application with Kylix + MySql.
These problem is when this password to connection mysql Null that
application running OK,
but if i fill password then message error on Kylix "Error mapping failed',
if I click again
then message "Unable to execute query"
Dear all,
I got problem, I want to build application with Kylix + MySql.
These problem is when this password to connection mysql Null that
application running OK,
but if i fill password then message error on Kylix "Error mapping failed',
if I click again
then message "Unable to execute query"
15 matches
Mail list logo
