MySQL Database Forum

Hi all I inherited a server running MySQL 4.* from a previous developer. Now, the records on this database might be what I want, or they might just be test data. I think my only chance of finding out if this is the real thing is to find the date and time of the last insert into the database. How can I do that?

I have this kind of code : Declare a number; s1 number default 0; Begin a:=1; loop s1:=s1+a; exit when (a=100);

Hai All, This is my create statement CREATE TABLE `dbname`.`tablename` ( `vh_id` int(10) unsigned NOT NULL, `gh_utc` time NOT NULL, `gh_mydate` date default NULL, `gh_serverdate_time` timestamp NOT NULL default CURRENT_TIMESTAMP, KEY `FK_geo_gpsdata_2` (`vh_id`)

Anyone can explain the following? Table definition: CREATE TABLE testdate ( SalesDate DATETIME, SalesTotal DOUBLE, PRIMARY KEY (SalesDate) )

Hi, i am wondering how did a website like facebook, myspace or whatever social networking site store their images? do they store them in a DB or roughly like files? thankyou in advance and cya!

Hi, I just migrated a MySQL database from my test server to my production Server with success. This database ia a backend for a .net application Im running. Now the problem is that when I try to connect to the database on the server(new one) I get the following error: Connection Failed: Can't connect to MySQL server on 'localhost' (10060) ...

I got this error #1030 - Got error 28 from storage engine when i'm trying to access in table in my database.........or when i'm trying to edit particular entry from any table this error #1030 - Got error 28 from storage engine will come so anyone can tell me the solution of this error..........is it from my side or from server side????? ...

--Apple-Mail-2--68472726 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Can not make mysql connection - error log: 030708 08:53:48 mysqld started

Here is what I did: - I had a perfectly working compressed table: ccc in database ddd - uncompressed it: # myisamchk -u history200310 - recovering (with sort) MyISAM-table 'ccc' Data records: 13786290 - Fixing index 1 - then tried to access it

Recently, I began using a different MySQL verver (i.e. different machine as well as different version#, going from 4.12a to 4.1.9 max). The following query used to work: select firstname, lastname, from associates where username like 'nancianne' but now fails with: "You have an error in your SQL syntax; check the manual that corresponds...

I am a newbie in the world of MySQL. In fact I enabled it in my Linux box only because it is required to run WordPress (the blogging software). I was trying to plan ahead and figure out a way to backup (and restore) a database, should my Linux machine ever goes belly up. I disovered that the databases are stored in subdirectories under...

Greetings, I'm trying to execute a sql file in the command line for sql 5.5 on a windows 7 computer. My sql file is on my c drive in the directory "john". My sql file is named mysql-start.sql. How do I execute the source command to run this sql file? This is something I am learning from a free online database class from Stanford. Here is how...

Is it possible to copy a table from one schema to another schema by just copying the frm file to the directory for the new schema? What is the best way to create a new database with all the tables in it automatically? I was hoping to have the tables (the frm files) included in a subdirectory and when required, just create a new schema...

when I create a table, I always make the first column my unique-id, and make this primary key auto-increment. Does this mean that the table will be indexed by mysql on this key - or do I need to explicitly do this too? e.g. create table note ( note_id INTEGER(9) AUTO_INCREMENT PRIMARY KEY,

Hi all, For a project I m working on I am looking for a database with all current car-makes & models from post-WII till now. With all the car websites around I am sure this information should be available somewhere so that I can import it into my MySQL database, but I simply can't find it. Does anybody know where I can get my hands on...

my friend ever tell me that he have seen an update query without using SET , can anyone tell me how to use it in mysql thanks

I have installed mysql (under SuSE 8.1) and everything seems to work fine when I am logged in as root. However, with my normal user profile I can get a mysql> prompt but have no permissions to carry out any database operations. I would really like to work with my normal profile and am hoping that it is merely a question of setting...

Hi, Besides transaction capability, is there anything else about innodb tables that makes it superior to myISAM? I really don’t need transactions, but for example, I need superior reliability for index (too many index corruptions in the past). Is innodb better in that area, or any other areas? -- Posted using the...

Hi all, I got a quite strange problem when I tried to setup a database backup shell. I put it this way: "bin/mysqldump --opt --user=xxx --password=xxx DB > DB.bak" However, error 1045 came to me to say "Access denied for user 'xxx'@'localhost' (using password: YES) when trying to connect". None the less, I'm absolutely full of confidence...

In MSSQL you can create a table with a computed column, like this... CREATE FUNCTION CubicVolume -- Input dimensions in centimeters. (@CubeLength decimal(4,1), @CubeWidth decimal(4,1), @CubeHeight decimal(4,1) ) RETURNS decimal(12,3) -- Cubic Centimeters. AS BEGIN RETURN ( @CubeLength * @CubeWidth * @CubeHeight )

Hello all, Looking for some help here. BTW, to e-mail me directly, should you prefer, take the *nomail*. out the reply address. I uploaded data from another program ( GNU R-2.2.0 @ www.r-project.org ) into a MySQl (4.1.X ) database. R generated the tables for me, naming the columns, setting field types, and inserting the records. This...

Hello members, I need help on creating a database in mysql, I installed XAMPP server which installed php5, win mysql ver 1.4, Apeche server, phpAdmin on my windows XP with SP2 but i'm a newbie and. I don't even know what the phpAdmin is for. I want creat A web site that is database driven with php and mysql but I don't know where to start. Pls...

Hi, I am confused with the syntax for NOT in MYSQL where clause and wonder if an expert in MYSQL can enlighten me. There are possibly two places NOT can go in: select * from employee_data where NOT employee_id LIKE 'A%' select * from employee_data where employee_id NOT LIKE 'A%'

How do you get the current month - 1 month? (so not a particular day, but the whole month) Thanks, Gary

hi, I got this definitions from mysql official site now() - returns the current date and time. SYSDATE() returns the time at which it executes This differs from the behavior for NOW(), which returns a constant time that indicates the time at which the statement began to execute. (Within a stored function or trigger, NOW() returns...