hi, to run a sql script from mysql shell just use command "source
your_sql_script.sql"
if you want to run it directly from prompt use this
mysql --force -uusername -ppassword -e"source your_sql_script.sql"
- Original Message -
From: "Seena Blace" <[EMAIL PROTECTED]>
To: "Remko Lodder" <
thing that you must omit some parameter when establishing
connection.
(But I never tried to make connection from COBOL, I'm just using MYSQL C API
from C++)
- Original Message -
From: "Arunachalam" <[EMAIL PROTECTED]>
To: "KKoTY" <[EMAIL PROTECTED]>
Cc: <
- Original Message -
From: "/dev/null" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 11:27 PM
Subject: New to MySQL
> wow, nice product. Pretty easy to use and install - I like it.
>
> I know enough about SQL and databases to just about break any flavor o
this occures when you ommit the user name, MYSQL C API uses user ODBC as
default when you ommit or enter empty string as
user name when calling mysql_real_connect()
- Original Message -
From: "Arunachalam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 3:38 P
you can use TIMESTAMP data type, which have default NOW()
- Original Message -
From: "Riaan Oberholzer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 12:38 PM
Subject: [Q] setting DATE field with default NOW value?
> In a table definition, how do I get a
i'm using this one : http://vsbabu.org/webdev/zopedev/ieeditor.html
but it works just on IE5.5 SP1 and above (IE6;)
- Original Message -
From: "fab" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 04, 2004 5:06 PM
Subject: wysiwyg web soft
> Hi to all,
>
> I'm fe
hi, you can try something like this
mysql --force -uuser -ppass -Ddatabase -e"query.sql"
where you can put all your SQL commands into to file named "query.sql"
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 02, 2004 8:38 PM
Subject: mysql co
hi, i was solving same problem before month and i finished it by this way:
select dayname("2003-11-12"), yearweek("2003-11-12"),ADDDATE('2003-01-06',
INTERVAL 7*(WEEK('2003-11-12')-1) DAY),ADDDATE('2003-01-06', INTERVAL
7*(WEEK('2003-11-12')-1)+6 DAY);
but there is constant '2003-01-06', that's
try
SELECT domain,AVG(speed) FROM your_table GROUP BY domain
where domain and speed are columns of table your_table
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 24, 2004 10:59 AM
Subject: A fun one
> Here's a fun one to tickle your brain
try this, i found this when solving similar problem.There is another method
to make and free connection, here is just one change.
The trick is that you dont call mysql_close( ) on &mysql_connection , but
on return of mysql_real_connect();
Try it, i think that this solve your is problem.
static M
hi, i had same problem. But after I put mysql_free_result(MYSQL_RES
*pResult)
after fetching rows from query (or generaly after calling all queries), it
was OK without this message.
I think there is a problem when you allocate memory for result of a query
(with mysql_store_result(MYSQL *myData)),
11 matches
Mail list logo
