SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- phpMyAdmin SQL Dump -- version 4.7.9 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 03, 2019 at 11:13 AM -- Server version: 10.1.31-MariaDB -- PHP Version: 7.2.3 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `namefinalproject` -- -- -------------------------------------------------------- -- -- Table structure for table `posts` -- CREATE TABLE `posts` ( `id` int(11) NOT NULL, `username` varchar(30) NOT NULL, `title` varchar(30) NOT NULL, `info` text NOT NULL, `datepost` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `posts` -- INSERT INTO `posts` (`id`, `username`, `title`, `info`, `datepost`) VALUES (1, 'Vanessa', 'Information Technology', 'Information technology is concerned with improvements in a variety of human and organizational problem-solving endeavors, through the design, development and use of technologically based systems and processes that enhance the efficiency and effectiveness of information in a variety of strategic, tactical and operational situations. Ideally, this is accomplished through critical attention to the information needs of humans in problem-solving tasks and the provision of technological aids, including electronic communication and computer-based systems of hardware and software and associated processes. Information technology complements and enhances traditional engineering through emphasis on the information basis for engineering.', '2019-02-03 16:27:49'), (2, 'Andrew', 'New quantum system could help ', 'Spin transport electronics have the potential to revolutionize electronic devices as we know them, especially when it comes to computing. While standard electronics use an electron\'s charge to encode information, spintronic devices rely on another intrinsic property of the electron: its spin. Spintronics could be faster and more reliable than conventional electronics, as spin can be changed quickly and these devices use less power. However, the field is young and there are many questions researchers need to solve to improve their control of spin information. One of the most complex questions plaguing the field is how the signal carried by particles with spin, known as spin current, decays over time.', '2019-02-03 16:31:49'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `username` varchar(30) NOT NULL, `email` varchar(50) NOT NULL, `password` varchar(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `email`, `password`) VALUES (1, 'Vanessa', 'vanessa@gmail.com', '12345'), (2, 'Thomas', 'thomas@gmail.com', '54321'), (3, 'Andrew', 'andrew@gmail.com', '12345'), (4, 'Jessica', 'jessica@gmail.com', '54321'), (10, 'Winda', 'winda@gmail.com', '12345'); -- -- Indexes for dumped tables -- -- -- Indexes for table `posts` -- ALTER TABLE `posts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `posts` -- ALTER TABLE `posts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear