some question about create db

I have to create a database from an application (written in perl) how can I do? how can I create a db if the user is not a root? which command can I use? Thank you in advance, Mario. - Before posting, please check: http://www.

Re: Mysql can't start: help!

> Please check the manual both about common problems and how to post > problems in list. This error can depend on which MySQL version you > installed. Is it RPM, binary or source installation? Check the manual > again I'm very sorry for take a noice to mailing list... but I try it! i try also

Re: how to do a query using a file?

> query: load data local infile "file.txt" into table > my_table Thank you. But for creating an entire and complex database? I mean If you have to create 40 table?!? there is a way to do it by ascii file? I write the SQL commands once and then I can recreate the db whth tables in different compu

Mysql can't start: help!

I use RedHat (last release) I try to use Mysql but It doesen' works: I post you some lines can help you to understand the error. how can create a table, use Mysql? Thank you in advance, Mario. - [root@localhost mysql

how to do a query using a file?

I have to buitd a "big" database. I have to create table, insert row in database and then do the same thing on another computer. I'd like to do that using a file in whiich I write all ... but how can I do? Thank you in advance. Mario. --

mysqlgui: help.

I tried mysqlgui: mysqlgui-linux-static-1.7.5]$ ./mysqlgui but it didn't works well: It can't connect to mysql. Why? How can I do to connect for example to a database called "visia" with pw "pw_visia" from an user called "rino" in "localhost"? mysqlgui ask me a password: what passw

how to connect MySql with Java?

I'd like to use MySql with Java (under Linux) bu I can't be able to do that: how can I do? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

How compile a C/C++ program which use API for mysql?

I have write a simple program in C/C++. this program use API for Mysql (linux) the question is : How to compile this programs? Tank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the

how can I get code example of manual?

I'd like to write a simple application with API of MySql. I see "4.4.1 A Simple Exaple" of the manual but I can't find the file "simple1.cc" that should be in my computer... but there isn't. How can install it? thank you in advance, Mario.

how to make SQL command by a file?

It is easy make an error while writing SQL coimmand to create table, etc... So I'd like to write this command (CREATE TABLE) in a file then run this command in mysql: How can I do? how can I write it? Thank you in advance. Mario. -

where is a "visual" tool to use MySQL?

I saw a visual tool for use mysql in simplest way: under KDE in a window: it let do a query in simple way and see the result in a window... I mead there are program that let use Mysql in KDE ? Thank you in advance, Mario. P.S. where cah I find it? --

new type of data: IP or NETADDRES: help me.

I have to put in my table a new type of data: IP and NETADDRES how can I do? what is (for you) the best way to do it? I think I'll make 4 INTEGER ( an IP is made by 4 number eg. 121.33.122.133) But then I have to get the little Net to which belong an IP I mean: if in my database there is: 121.33