Table storage settings at table creation time
How can i set table storage settings at table creation time or any existing table
How can i set table storage settings at table creation time or any existing table
25 pts.
Recovering the MySQL database
In the process of editing my database, I accidentally deleted the MySQL database. I thought I recovered it, but when I opened MySQL Query Browser, it was not there. Is there an easy way to recover it for good?
In the process of editing my database, I accidentally deleted the MySQL database. I thought I recovered it, but when I opened MySQL Query Browser, it was not there. Is there an easy way to recover it for good?
AUTO INCREMENT
We created a File with an Auto Increment Field using MYSQL statements through PHP. I have no Idea how to do this using DDS statements or settings.
We created a File with an Auto Increment Field using MYSQL statements through PHP. I have no Idea how to do this using DDS statements or settings.
New to php/mySQL having an issue with Mac OSX
I'm following the lynda.com video series on php with mySQL and have run into a hangup. When I install mysql and I'm checking to make sure it's all running, pointing a browser to http://localhost gives me the apache is running page, but going to http://localhost/~(myusername)/, I get an error saying...
I'm following the lynda.com video series on php with mySQL and have run into a hangup. When I install mysql and I'm checking to make sure it's all running, pointing a browser to http://localhost gives me the apache is running page, but going to http://localhost/~(myusername)/, I get an error saying...
equivalent for crosstab query
Is there any function in MySQL that can create a query similar to crosstab query in MS Access???
Is there any function in MySQL that can create a query similar to crosstab query in MS Access???
Echo a variable in PHP which displays as a link
hi, I have a number of variables that i pull from a mysql database. I want 1 of the variables to show as a link to a web page. i have tried the following code, which displays everything fine, except for the $url bit echo "<p>$djname $genre $biography <a href='/$url'>...
hi, I have a number of variables that i pull from a mysql database. I want 1 of the variables to show as a link to a web page. i have tried the following code, which displays everything fine, except for the $url bit echo "<p>$djname $genre $biography <a href='/$url'>...
URL link in PHP/MySQL script
I am adding a URL within a table with PHP and a MySQL Database, my string doesn't show all of the URL, it cuts it off.
I am adding a URL within a table with PHP and a MySQL Database, my string doesn't show all of the URL, it cuts it off.
php script Question and Answer
I am looking for a php script that show a photo of a person and ask who is this person. and you type in the persons name and it will gave you and answer of yes or no. or something like this, where I might be able edit
I am looking for a php script that show a photo of a person and ask who is this person. and you type in the persons name and it will gave you and answer of yes or no. or something like this, where I might be able edit
How to optimize results coming from database
Sir, I hv created a software which searches for the information the user wants. If only one user is using database at a time then it gives response in milliseconds. But when at a time 10 or more than that start using it then throughput decreases. So how i should do optimization
Sir, I hv created a software which searches for the information the user wants. If only one user is using database at a time then it gives response in milliseconds. But when at a time 10 or more than that start using it then throughput decreases. So how i should do optimization
Storing Binary Data
I've been in the process of reviewing the pros and cons of storing binary data (e.g. image files) either in blob fields in a database (presumably MySQL) vs. the filesystem of a server. I'm aware there are some concerns of security, but I'm mainly interested in performance at present. I could...
I've been in the process of reviewing the pros and cons of storing binary data (e.g. image files) either in blob fields in a database (presumably MySQL) vs. the filesystem of a server. I'm aware there are some concerns of security, but I'm mainly interested in performance at present. I could...
MySQL Stored Procedures with Parameters in Crystal Reports 9???
Hi, am using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the...
Hi, am using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the...
MySQL Stored Procedures in Crystal Reports
Hi, am using Crystal Reports 9 and MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I...
Hi, am using Crystal Reports 9 and MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I...
MySql Query
Hi Gurus i have a problem in MYSql Query Browwser there is a table "jiuser" in "jasperserver" database. this table has a column "username". there is another table " jiresourcefolder" in the "jasperserver" database. this table has a column "uri". now i wana find out which user can access which...
Hi Gurus i have a problem in MYSql Query Browwser there is a table "jiuser" in "jasperserver" database. this table has a column "username". there is another table " jiresourcefolder" in the "jasperserver" database. this table has a column "uri". now i wana find out which user can access which...
Running different versions of MySql on same machine?
Is it possible to run different versions of MySql on the same server machine?
Is it possible to run different versions of MySql on the same server machine?
Is there a server running on localhost: 3306?
Has anyone seen this error before? We've got a Windows 2003 Standard Server running MySql 5.x.x, with ColdFusion MX 7.x.x. Everytime we try to add a new MySql DSN Connection we get this error: Connection verification failed for data source: cudefault java.sql.SQLException: Communication failure...
Has anyone seen this error before? We've got a Windows 2003 Standard Server running MySql 5.x.x, with ColdFusion MX 7.x.x. Everytime we try to add a new MySql DSN Connection we get this error: Connection verification failed for data source: cudefault java.sql.SQLException: Communication failure...
how to compare 2 dates == x day and delete the file
hi, do any one know how to compare the 2 dates.comparing today's and the file created date using mysql and c# here is my program but i am stuck string ConnectionString = "server=localhost;user id=name;password;persist security info=True;database=name of database;"; using...
hi, do any one know how to compare the 2 dates.comparing today's and the file created date using mysql and c# here is my program but i am stuck string ConnectionString = "server=localhost;user id=name;password;persist security info=True;database=name of database;"; using...
how do i display session id on the web
hi, I am doing a login page with mysql and asp.net/c#. I would like the program to run in the following sequence. 1. the user login 2. the login page will search through mysql database, 3. when it is Authenticate, it will allow the user to access. my concern now is how to you use the session id to...
hi, I am doing a login page with mysql and asp.net/c#. I would like the program to run in the following sequence. 1. the user login 2. the login page will search through mysql database, 3. when it is Authenticate, it will allow the user to access. my concern now is how to you use the session id to...
Membership login with mysql
hi, i doing a login program which will be using mysql. I would like to how do i do that, I have done a little but i am stuck half way can anyone help? protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { MySqlConnection conDatabase = new...
hi, i doing a login program which will be using mysql. I would like to how do i do that, I have done a little but i am stuck half way can anyone help? protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { MySqlConnection conDatabase = new...
MYSQL/PHP based CMS (Mambo,Joomla) on the 400.
Has anyone setup one of the MYSQL/PHP based CMS (Mambo,Joomla) on the 400 yet? I use these CMS on regular Apache 2.0 servers with MYSQL 5.0 & PHP 4+ These CMS are very flexible and adaptable and I would like to use on the 400.
Has anyone setup one of the MYSQL/PHP based CMS (Mambo,Joomla) on the 400 yet? I use these CMS on regular Apache 2.0 servers with MYSQL 5.0 & PHP 4+ These CMS are very flexible and adaptable and I would like to use on the 400.
Access to MySQL - How hard is this going to be?
I've just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I've agreed to help him do it. Does anyone have a feel for what it will take to get his data...
I've just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I've agreed to help him do it. Does anyone have a feel for what it will take to get his data...
