MYSQL :: Create Virtual Table During Query Or Load Table To Memory From Text File

Cant Load Text File Into Table From Remote Browser
I'm trying to run:

$sql = "LOAD DATA INFILE 'E:AHLog.txt' REPLACE INTO TABLE `items`
FIELDS TERMINATED BY '' LINES TERMINATED BY ''";
$result = mysql_query($sql);

And I thought that "REPLACE" would take care of repeating rows, but it doesn't. How do I write a mysql command that only inserts UNIQUE rows, and not repeat rows?

How To Create New Table From A Text File?
Is there a GUI utility which can create a new table in my mysql
database from a 50 million-record text file? I want mysql to get the
data into the database as whatever it can - varchar etc. I can change
columns later to double.... unless mysql is intelligent enough to see
that the field in the text file is numeric.

Load Null Values In Table Through LOAD FILE
I'M TRYING TO LOAD FILE WHICH HAS NULL VALUES FOR SOME COLUMNS AT THE FIRST ROW.IT Says "Incorrect Date Value for the column" as it has null values

Load Null Values In Table Through LOAD FILE
I'M TRYING TO LOAD FILE WHICH HAS NULL VALUES FOR SOME COLUMNS AT THE FIRST ROW . IT Says "Incorrect Date Value for the column" as it has null values.

Load Table From File
Is there a method if I wanted to load from a file but place a static value into each row that is loaded into the table?

Pseudo code:

declare aValue char;
set aValue = 'staticvalue';

LOAD DATA INFILE 'twoColumnFile.txt'
INTO TABLE ThreeColumnTable
(column1, column2, column3)
SET column3 = aValue;

Edited 1 time(s). Last edit at 01/09/2008 02:13PM by John Doe.

Create Table With SQL File
I'm fairly new to MySQL devlopment, and Im trying to create a table in and existing MySQL database using an sql file on windows platform ....

Truncating A Memory Table Wont Release Memory
I have a memory table that when i truncate it system memory that has been allocated by mysql isnt released. Im running mysql 5.1.

DB Log Vs Text File Log And 1 Table Vs N Tables
1. Storing log in DB/Text file which mayb keep increaing every second. Which one is more feasible?

2. I hv a situation which to record the impression, the record keeps growing and should be huge one day, i wonder, spliting the same type of data into several tables like

impression_[month]_[day]

which will create different tables to store same type of data. Is it a good idea to reduce the select/insert time for the system?

Loading Text File Into Table
i created a table with the key attribute having an autoincrement property... i loaded a text file without the key attribute column to populate my table...but there's an error... but when i loaded the file with the key attribute column it doesnt post an error... how can i insert or load a text file without the key attribute column since it is already autoincremented?

How Do I Create A Table For Holding File Permissions?
I am wanting to make file sharing website. So users can upload files and have control over who access the files. I am wanting to use MySQL for storing the users, passwords, home folders and access permissions for each file.

I want to make a table that has the userid and a list of all the files he can access. But I don't know how to make the table that would hold a list of files.

Loading Data Into A Table From A Text File
I have a table in MySQL with the columns: "ID, JokeText, JokeCategory, JokeDate"

I want to take a text file that is a long list of jokes, and load each joke into a new row of the table in the JokeText field.

I have tried a bunch of different approaches, and just can't get it to work right. Can anyone enlighten me?

If it helps, here is a sample from the jokes text file (yes, they are stupid :P)

Q: What goes up and down but does not move? A: Stairs
%%
Q: Where should a 500 pound alien go? A: On a diet
%%
Q: What did one toilet say to the other? A: You look a bit flushed.
%%
Q: Why did the picture go to jail? A: Because it was framed.
%%
Q: What did one wall say to the other wall? A: I'll meet you at the corner.
%%

How Do You Get A Local Text File Into A Mysql Table?
If you have a local text file in notepad, how do you get the data into table EMAILS2 in my myslq database?

Do you need to upload the whole file and then run the query

LOAD DATA INFILE emails2.txt to TABLE EMAILS2?

Regular Text File How To Sql 2000 Table Code
i have a text file as follow, line with ¡°|¡±and {LF},

8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|

i want to sign char(1)£¬year decimal(18,3) , month decimal(18,3), trandate
smalldatetime£¬update smalldatetime£¬after to sql table is as follow,

sign year month trandate update
8 -186075919.000 387820.000 3/31/2008 4/23/2001
9 -3919.000 -123620.000 3/31/2008 1/1/2001
8 -18623419.000 387820.000 5/30/2008 4/23/2001

Creating A Table From A Text File With Field Names
Is there a way to create a MYSQL table or database using a text file that
countains the Field name and the lenght ?

that is :

fields.txt

----- start ----------
name,10
address,15
address1,15
address2,15
city,10
state,2
zip,10

etc......

---end ----------------------

How Can I Load This Text File Into MySQL?
the following are the content of the txt file. It is 2 rows. There are much more rows like these in the txt file. I want to load every 1st line into my database. I used " load data infile ' file path/file name' into tablename fields terminated by ' ' lines starting 'r '; " to load the file.

But there is error. I think "V2Dir " of 2nd line make the error. It conflicts with lines starting 'r '. Could somebody give me any solution for loading this text into my database?

Code:

Choose Fields To Load From Text File
Have a text file with lots of fields but im only interested to load som of them into a table.
Must i have the same amount of fields in my table as a have in the text file.
Have tried to load a text file into a table with less fields than the text file.
My database has a table with only three fields, tried to use @dummy to exclude the
rest of the fields in the text file. The problem is it dont work, is it the right way to do it.

Ex.

load data infile 'log.txt' into table test fields terminated by ';' lines terminated by '.'
(field1,field2,field3,@dymmy,@dummy,@dymmy,@dymmy,@dymmy,@dymmy,
@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,
@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,
@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,@dymmy,);

INSERT Syntax For Text File To Load Into Tables?
I have successfully created a number of tables in my database and am looking for an efficient way to load data into the tables. I have the following (successful) command to find the text file and load it into the target table:

"load data local infile 'C:mySQL abledata.txt' into TABLE checks;"

It loads into the 'checks' table successfully, but the data is incorrect. What is the syntax of the INSERT command that I'm using in the text file itself-- assuming that I do use the INSERT command? Here is what I have in the NotePad text file I'm using, which only produces zeroes in the first and third columns:

insert into checks values
('1', 'Ma Bell', '150', 'Have sons next time',
'2', 'Reading R.R.', '245.34', 'Train to Chicago',
'3', 'Ma Bell', '200.32', 'Cellular phone',
'4', 'Local Utilities', '98', 'Gas',
'5', 'Joes Stale $ Dent', '150', 'Grocieries',
'6', 'Cash', '25', 'Wild Night Out',
'7', 'Joans Gas', '25.1', 'Gas');

LOAD DATA INFILE Command To Import A Text File
I am using the LOAD DATA INFILE command to import a text file into
mysql.

However, there is much more text in the file than needed in my tables.
How can I make a selection from the text line. For example position 5 -
10 in field A, position 20-23 in field B, etc ...

Create Table Query
I just dump this script from another database so I could add the same create table query for different db, when I run the query I get the error.

mysql> CREATE TABLE SENT_MESSAGES (
-> INDNUMBER int(11) NOT NULL auto_increment,
-> CLIENT varchar(100) NOT NULL default '',
-> CODE varchar(100) NOT NULL default '',
-> TYPE varchar(100) NOT NULL default '',
-> WHEN timestamp(14) NOT NULL,
-> PRIMARY KEY (INDNUMBER)
-> ) TYPE=MyISAM;
ERROR 1064: You have an error in your SQL syntax near 'WHEN timestamp(14) NOT NULL,
PRIMARY KEY (INDNUMBER)
) TYPE=MyISAM' at line 6

CREATE TABLE And MySQL Query Browser
I am using the ODBC 3.51 Driver to Do a "create database" and then create some tables on that database.

I see in the ..mysqldata directory my new database I have created and the associated .frm files, however MySQL Query Browser and Administrator do not see these schema's.

I am guessing it may be due to user privileges. MySQL is running locally and the connection string does not contain a Username and password.

Also, when I do show databases from within the Query Browser, it does not show my Database, only the one that I had created manually.

There must be some more setup that I am not aware of to register the Database or something.

How To Load A BLOB Data Into A DB Table And How To Get It From The DB Table?
Explains how to load a BLOB data into a DB table and how to get it from the DB table? image will be uploaded using cfform.

ERROR 1005: Can't Create Table './db/table.frm' (errno: 150)
I found the key to solve this problem in:

http://darkstar.ist.utl.pt/mysql/do...onstraints.html

You'll probably need an INDEX for that new foreign key you are declaring in
older versions this isn't neccesary but in latest ones it is a restriction.

You can have more info about the error description if you have root access
by typing
mysql> show innodb status;

LATEST FOREIGN KEY ERROR
------------------------
030807 1:27:10 Error in foreign key constraint of table database/table:
There is no index in the table database/table where the columns appear
as the first columns. Constraint:
foreign key (key) references database.table(key) on delete cascade)
type=innodb

also if you type:
shell> perror 150

you obtain:
150 = Foreign key constraint is incorrectly formed

I hope this to be enough...

Memory Table Full
I've read that memory tables are supposed to gracefully 'fallback' to the default engine when they reach a certain size, but I'm not finding that they behave that way. Within my application, I had run into situations where

CREATE TEMPORARY TABLE xxxx ENGINE=Memory
SELECT xxx...

would result in a "The table 'xxxx' is full" error. I had to change from memory to the default engine to ensure they would work, but most of the queries were much faster when using in memory temp tables where appropriate.

Is there a way to ensure MySQL will gracefully switch to another engine when the temporary table becomes too large for the heap engine?

Can't Create Table -- Error 1050 - Table Already Exists
I tried to create a table in the database. Here is the query sentence :

CREATE TABLE word (aff_code varchar( 10 ) NOT NULL default '',position tinyint( 1 ) NOT NULL default '0',flag tinyint( 1 ) NOT NULL default '0',PRIMARY KEY ( aff_code, position )) ENGINE = MYISAM DEFAULT CHARSET = latin1;

I was expecting to create a three column table. However, MySQL kept reporting error : ERROR 1050 (42S01): Table 'word' already exists. The fact is there is no table in this database. I then changed the table name, engine type, MySQL still report the same problem. I've tried changing database name. Still the same problem.

Prior to the query, I run a program that created (and inserted data as well) 65,000 tables in another database (same server although). I'm wonderring would this cause some kind of dead lock that result in the problem of not able to create any more table?

Can anybody give me some tips on how to solve the prolem?

Rights To Create Table, Select, Then Drop Table..
I have a need to get data from the db that requires me to=20

1) do a select and create a new table with the results=20
2) run a query against that new table=20
3) drop the new table=20

I have a script on my server that does this using the root account that has all on *.* for the db. It works fine.=20

I now want to get these results on a web page.=20 I want to create a new db user for my .php web page to use to connect to the db that only has the needed priviledges on that specific db to get the job done.=20

what priviledges do I need to give that user?=20

currently I have the following but the user can't even log into the db from the command line..=20

mysql> show grants for user;=20
+-----------------------------------------------------------------------
---------+=20
| Grants for user@% |=20
+-----------------------------------------------------------------------
---------+=20
| GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD
'6fe4c0ab2cf30ae3' |=20
| GRANT SELECT, INSERT, UPDATE, CREATE, DROP ON `db1`.* TO 'user'@'%' |=20
+-----------------------------------------------------------------------
---------+=20
2 rows in set (0.00 sec)=20

when I do a "show grants for user", what should I see to allow what I want?

Two Table Query: Grab Rows From One Table Even If No Related Row In Other Table
PHP

$gettray = mysql_query("SELECT trailers.title,
trailers.link,
trailers.movie,
movie.title AS mtitle
FROM trailers,movie
WHERE trailers.movie=movie.word
ORDER BY trailerid
DESC LIMIT 6",$connm);

It works great, but there is one problem. It will not grab any rows from the 'trailers' table if a corresponding movie row does not exist in the 'movies' table.

I want it to pull ALL rows from the 'trailers' table, even if the corresponding row in the 'movies' table does not exist yet.

If the row does not exist in 'movies', the program than uses the entire trailer title like so

PHP

if($ttray['mtitle']) {
$newttitle = explode("-",$ttray['title']);
$newttitle = array_reverse($newttitle);
$ttitle = $newttitle[0];
$ttitle = $ttray['mtitle'] ."- ". $ttitle;
} else {
$ttitle = $ttray['title'];
}

Thanks
Ryan

Create Table / Column Table Order
When creating a table, is there any advantage in specifying the columns in
any special order? For example, what about columns with data used more
frequently listed first, or column/data types giving some? Or.... am I being
pedantic even thinking about such?

How Can I Output Query Results Into A Text File?
I'm looking for a way to output the results of a simple SELECT statement into a text file instead of displaying it on the screen?

MySQL 4.0.13 Memory Problem Under Heavy Load
I want to get your opinions on how to increase available/free memory and
performance on a heavy volume database server.

I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using
same MySQL version.
Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap
space) started to suffer from memory outages because of heavy load.
During day available free memory is changing from 200Mb to 5Mb and when
available memory reaches to 5Mb MySQL starts to give 'Too many
connections' messages. Db server is working with 45-70 query/second and
more than 25,712 connection per hour. There are active 10-13 threads
serving databases.

To increase available free memory I've did the following :
1- Optimized all tables
2- Removed unneccessary/old indexes
3- Moved unused databases to replication server
4- Increased key_buffer_size from 8Mb to 128Mb
5- Have increased max_connection from 100 to 150
6- Have increased thread_cache to 5

This changes helped a bit but still memory is a problem for MySQL. What
should I do to prevent 'too many connections' messages and have more
memory available on database servers? Should I remove more indexes from
tables? Should I increase key_buffer_size to 256Mb or more?
Key_buffer_size doesn't look like a problem since key efficiency looks
100% most of the time.

MySQL 4.0.13 Memory Problem On Heavy Load
I want to get your opinions on how to increase available/free memory and
performance on a heavy volume database server.

I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using same
MySQL version.
Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap space)
started to suffer from memory outages because of heavy load. During day
available free memory is changing from 200Mb to 5Mb and when available memory
reaches to 5Mb MySQL starts to give 'Too many connections' messages. Db server
is working with 45-70 query/second and more than 25,712 connection per hour.
There are active 13-18 threads serving databases.

To increase available free memory I've did following :
1- Optimized all tables
2- Removed unneccessary/old indexes
3- Moved unused databases to replication server
4- Increased key_buffer_size from 8Mb to 16Mb

This changes helped a bit but still memory is a problem for MySQL. Average MySQL
thread used to consume 100-120 Mb memory before changes, now it is consuming
60-70Mb per thread. What should I do to prevent 'too many connections' messages
and have more memory available on database servers? Should I remove more indexes
from tables? Should I increase key_buffer_size to 32Mb or more? Key_buffer_size
doesn't look like a problem since key efficiency looks 100% most of the time.

MySQL 4.0.13 Memory Problem On Heavy Load
I want to get your opinions on how to increase available/free memory and
performance on a heavy volume database server.

I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using same
MySQL version.

Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap space)
started to suffer from memory outages because of heavy load. During day
available free memory is changing from 200Mb to 5Mb and when available memory
reaches to 5Mb MySQL starts to give 'Too many connections' messages. Db server
is working with 45-70 query/second and more than 25,712 connection per hour.
There are active 13-18 threads serving databases.

To increase available free memory I've did following :
1- Optimized all tables
2- Removed unneccessary/old indexes
3- Moved unused databases to replication server
4- Increased key_buffer_size from 8Mb to 16Mb

This changes helped a bit but still memory is a problem for MySQL. Average MySQL
thread used to consume 100-120 Mb memory before changes, now it is consuming
60-70Mb per thread. What should I do to prevent 'too many connections' messages
and have more memory available on database servers? Should I remove more indexes
from tables? Should I increase key_buffer_size to 32Mb or more? Key_buffer_size
doesn't look like a problem since key efficiency looks 100% most of the time.

MySQL 4.0.13 Memory Problem Under Heavy Load
I want to get your opinions on how to increase available/free memory and
performance on a heavy volume database server.

I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using
same MySQL version.

Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap
space) started to suffer from memory outages because of heavy load.
During day available free memory is changing from 200Mb to 5Mb and when
available memory reaches to 5Mb MySQL starts to give 'Too many
connections' messages. Db server is working with 45-70 query/second and
more than 25,712 connection per hour. There are active 10-13 threads
serving databases.

To increase available free memory I've did the following :
1- Optimized all tables
2- Removed unneccessary/old indexes
3- Moved unused databases to replication server
4- Increased key_buffer_size from 8Mb to 128Mb
5- Have increased max_connection from 100 to 150
6- Have increased thread_cache to 5

This changes helped a bit but still memory is a problem for MySQL. What
should I do to prevent 'too many connections' messages and have more
memory available on database servers? Should I remove more indexes from
tables? Should I increase key_buffer_size to 256Mb or more?
Key_buffer_size doesn't look like a problem since key efficiency looks
100% most of the time.

Create A New Table With Table Type??
I was creating a new table via a query and when i went back and looked at the size, it was over 3MB! This with only five records in it. Here's what I found:

table size(bytes) type
A 26 MyISAM
B 66 MyISAM
C 0 MyISAM
D 3276 InnoDB
E 0 MyISAM

so then i tried to create the table defining the type but it keeps erroring out on me.

My question is: How/Can you create a table with the TYPE defined via a query?

create table testtbl (yr varchar(4)) type=myisam <- works

create table testtbl as (select * from table1) type=myisam <- errors

Separate TEXT Table Or One BIG Table
In the past I have constructed my private message system into two database tables. One table held the message_id(KEY int), user_id(medium int), sender_id(medium int), subject(varchar), new(bool), and date(datetime) values. Then the records are fetched and are displayed into a HTML table. When the user clicks on any one of the records the browser is redirected to a page which displays the actual message. The message is stored into a table with the columns: message_id(KEY int), message(TEXT).

This whole process has worked fine, but is this really logical to split the TEXT type into its own table?

Multi Table Query, Grab More Than Single Row From Secondary Table
I have a query like so:

PHP Code:

$selectt = mysql_query("SELECT trailers.trailer_id,
trailers.trailer_title,
trailers.description, trailers.file_url,
trailers.runtime, trailers.views,
trailers.rating, trailers.tt, trailers.keyw, trailers.date,
tags.snub,
films.film_title, films.studio, films.keyw, films.image
FROM films,tags,trailers
WHERE trailers.trailer_id=tags.trailer_id
AND trailers.film_id=films.film_id
ORDER BY trailers.trailer_id DESC LIMIT 8",$dbh);

I know this is pretty sloppy, I have multiple 'tags' per trailer ID, and I was hoping to grab all of them in a single query; maybe into an array? So that it shows the row, and then all the tags that belong to it.

Possible?

Create Another Field After Create Table
i have create a table from CLI, i would like to add another field after create table.
How to do that ?

Load Into A Table
my problem is I want to load data from a file into a table command like that - - >

load table Users_interface from 'c:user.txt';
commit;

that works but when there is only one data in the file already in table the script stops whiteout inserting any data from file.

how can I make it inserting only the data what is not in table and ignors the data what is already in table ?

1 Simply Query Problem. Please Help With Insert Into 1 Table From Another Table
I have Table A that has some records already in and then I have Table B that does a few things and gets updated regularly.

With Table A, I want to get it updated every 8 hours or so with new data that has been inserted into Table B.

I will do this using the Cron.

But what would be the best insert query to use so that it does the process really quick.

The query that I have so far is:

Quote:

mysql_query("INSERT INTO table a (id, title, descrip) SELECT id, title, descrip FROM table b where app=1");

With the above query the id's match in both tables. But I only want the new records to be inserted into Table A where app=1 in Table B and the row is not already in Table A.

How can I add to the query so that it does this.

Query Table A And Return Records Not Found In Table B.
Given table A and table B.  Table A is a master table and table B is a list of authority or reference which is fed by selecting records from table A (via an UI I wrote in PHP).

The interface is working fine but I am left with one problem.    If I need to edit my table of authority, the source table (table A) should return ONLY entries not previously selected.

That said, if the A.key is in B.key, records from table A matching B.key should be omitted.

I could do this by looping through the query results from table A and querying table B, if no match, show A.key.  This I think is a bit antiquated and possibly too involved.

Is there a joint query command I can use?

Table Design Question? House Table, Owner Table, Code Violations Table - Best Way?
Given the tables:

HOUSE
house_ID
address

OWNER
owner_ID
name
telephone...

HOUSE_OWNER_JOIN
?

CODE_VIOLATION_HISTORY
house_ID
violation_ID
violationStatement
...

My goal is to be able to track code violations of the house PER owner.

For example, I need to display a page that shows the current house with it's coe violations and a link to show the HOUSE's history of violation regardless of owner, Like:

House 1009283
Address
Past history (link to the following)

House History
2001-01-04 Owner: John Smith Code Violation: Gutter issue
1999-06-01 Owner: John Smith Code Violation: Faulty Steps
1998-03-02 Owner: Sam Spade Code Violation: Driveway carcks
1990-01-12 Owner: Keith Sledge Code Violation: Grass untidy

For the design of the HOUSE_OWNER_JOIN table, I thought of two ways I could go on this and this is where I need your help.

Option 1:
Have the HOUSE_OWNER_JOIN table keep dates so I can track the ownership changes that way:

HOUSE_OWNER_JOIN
houseID
ownerID
dateOwnershipBegan
dateOwnershipEnded

then I could look up all code violations by date and associate them with their rightful owner.

==================================================
Option 2:
Have the HOUSE_OWNER_JOIN table be the primary keeper of identity data by adding a new primary key and changing the CODE_VIOLATION_HISTORY table to reference that table by chaning the referencing key from house_ID to house_owner_ID:

HOUSE_OWNER_JOIN
house_owner_ID
houseID
ownerID
dateOwnershipBegan
dateOwnershipEnded

CODE_VIOLATION_HISTORY
house_owner_ID
violationStatement
...

Help With 3 Table Query & Counting Rows In Third Table
I have three tables, a members, a vendors and a products. I'm using a query to grab all of the rows from the first two tables, matching on a primary key. This is easy and works fine. However, I'm trying to pull the number of products from the third table and it's giving me trouble. Basically, I can count the products for each vendor if products exist, but if there are no products, instead of returning 0, no rows are returning.

current query looks like this:

SELECT t1.*, t2.*, count(*) AS count FROM vendors as t1, members AS t2, products AS t3 WHERE t2.mem_id = t1.mem_id AND t3.vendors_id = t1.vendors_id GROUP BY t1.vendors_id;

So, all of the vendors that have zero products are being left out of the results. Does anyone know if it's possible to achieve this without using a temp table?

Load Limit On MyIsam Table?
I'm connecting to a MySQL DB (4.0.26-nt) using ODBC in ASP and trying to use AddNew to add records to some tables.

When assigning longer string values to a varchar field, I get the dreaded "Multiple-step operation generated errors. Check each status value." error. I know that this is related to trying to stuff too much data into a field, but...

Here's the funny thing -- when I check a field's defined size using:
rs(myFieldName).definedsize, it reports a number smaller than when I view the design of the table within MyPHPAdmin. That is, the field is a varchar(70), but definedsize gets reported as 50. Therefore my string of 60 characters won't fit and I get the error.

Increasing the field's size doesn't change the reported definedsize... unless I drop the table and re-create.

This is all on my ISP's server, so don't know if it's something they can deal with or not?

VB6 - MySQL 5 - Don't Load Some Field From The Table
I'm with a strange problem that occur in some fields of the table that are not being loaded in the form I'm usign the visual basic 6 as front end and MySQL 5.

When I do in this way the form load the fields from the table. i.e:

rsMySQL.Source = "Select * From tb_alunos

But in this another form some field don't load.

rsMySQL.Source = "Select A. *, B.*, C.*, E.* FROM tb_alunos AS A INNER JOIN tb_bairros AS B ON A.Id_Bairro = B.Id_Bairro INNER JOIN tb_cidades AS C ON A.Id_Cidade = C.Id_Cidade INNER JOIN tb_empresas AS E ON A.Id_Empresa = E.Id_Empresas"

I have tried with LEFT JOIN and RIGHT JOIN, without success.

Date Reformat On Table Load
i need to reformat a date field mm/dd/yyyy to the MySQL format of yyyy-mm-dd during the load data step (if possible). suggestions?

MySQL Table Types For Rapid Load
Which table type should I use for rapid-load systems, such as a php/mysql chat application?

Load Cvs Data Into An Exisitng Empty Table?
how do i load cvs data into an exisitng empty table?
i've tried to follow the syntax for the doumentation manual- the load infile... statement but it doesnt work, it says file not found

i also tried to use the import option with the phpMyAdmin GUI but it gave me an error saying check the syntax on that one. and there isnt any syntax to check b/c its just a file that i saved as csv and tried to import.